Datasource control with MySQL Datasource control with MySQL

Submitted by planetsourcecode on
We can use the Datasource control with MySQL, for this we have to require two things. This can be done without writing any codes,simpy we have to assign the ConnectionsString in the SQLDataSource control. the string will be like that DS1.ConnectionString="Driver={MySQL ODBC 3.51 Driver};server=YourServerIP;database=" & _ "YourDB;user=YourUID;pwd=YourPWD;option=3;"

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”);

Subscribe to