Execute Commands Methods: How to use it?

Submitted by planetsourcecode on
We have 4 types of Exceute methods, through which we can excecute the quries angainst Database. 1). ExecuteNonQuery(() 2). ExecuteReader() 3). ExecuteScalar() 4). ExceuteXmlReader() 1). ExecuteNonQuery(() Explanation: Executes a command but does not return any value or output usage conditions: UPDATE, INSERT, DELETE statements using System; using System.Data;

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.

Subscribe to