Search an object in Dababase

Submitted by planetsourcecode on
Always forgot to remember one query. So for them only Below query you can any table, stored procedure or views who ever have that expression as a column or object name. SELECT * FROM SYSOBJECTS WHERE ID IN (SELECT ID FROM SYSCOMMENTS WHERE TEXT LIKE ‘%PRODUC%’) The query produced all the object names. where ever it finds expression like ‘PRODUC‘

Barcode development in dot net

Submitted by planetsourcecode on
Recently we were working on Barcode application and want details of the Barcode mechanism like how the barcode works, what are the different types of barcode, which one is better for which condition and other important questions by googling we got the following website which are providing efficient information to deal with these type of issues

Database Programming with JDBC

Submitted by coderz on

Type 4 drivers or Native protocol driver is known to be the one with the best features and functions. Type 4 driver does not have any native methods and is a complete Java driver. You need not to install it on the client before use and the can be easily downloaded or configured on a system very easily. One of the best features of Type 4 driver is that it interacts directly with the DBMS server.

Firstly, you need to register the type of driver that you are using by using the string,
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

Database Programming with Microsoft Access

Submitted by coderz on

Microsoft Access is a DBMS that is known to almost all of us. Most of the computer professionals must have used this DBMS at least once in their lifetime. With the help of Microsoft Access we can easily create new relational databases, insert, and update and delete data. Microsoft Access has gained more popularity with its ability to relate one or more tables in the database.

DotNetNuke (DNN) – An Introduction

Submitted by planetsourcecode on
We are going to organize a workshop in sans and the topic for that discussion will be DotNetNuke. DotNetNuke is an open source web application framework ideal for creating, deploying and managing interactive web, intranet, and extranet sites securely. It is open source framework which is providing different benefits to the users. Let us we discuss some of the major benefits by DotNetNuke.

Check Existence of File in ASP.NET and C#

Submitted by planetsourcecode on
We have to check if file exists before doing some things with that particular file. It will prevent error and work flow will be smooth, for this we have to include required namespace i.e system.IO; Using system.IO; We have to place these controls on the webpage (ASPX page) Text box with ID=Textbox1 Button with ID= button1 Label with ID= label1