Explain DataAdapter Object

It populates dataset from data source. It contains a reference to the connection object and opens and closes the connection automatically when reading from or writing to the database.

Example:
SqlDataAdapter daEmp = new SqlDataAdapter( "select EmpID, EmpName, Salary from Employees", conn);

Fill Method
It is used to populate dataset.
example: daEmp.Fill(dsEmp,"Employee");

Update Method
It is used to update database.
example: daEmp.Update(dsEmp,"Employee");

Comments

Post a Comment

Popular posts from this blog

How do I calculate a MD5 hash from a string?

It is a common practice to store passwords in databases using a hash. MD5 (defined in RFC 1321 ) is a common hash algorithm, and using it from C# is easy. Here’s an implementation of a method that converts a string to an MD5 hash, which is a 32-character string of hexadecimal numbers. public string CalculateMD5Hash ( string input ) { // step 1, calculate MD5 hash from input MD5 md5 = System . Security . Cryptography . MD5 . Create ( ) ; byte [ ] inputBytes = System . Text . Encoding . ASCII . GetBytes ( input ) ; byte [ ] hash = md5 . ComputeHash ( inputBytes ) ; // step 2, convert byte array to hex string StringBuilder sb = new StringBuilder ( ) ; for ( int i = 0 ; i < hash . Length ; i ++ ) { sb . Append ( hash [ i ] . ToString ( "X2" ) ) ; } return sb . ToString ( ) ; } An example call: string hash = CalculateMD5Hash ( "abcdefghijklmnopqrstuvwxyz" ) ; …returns a s
Read more

What is WSDL?

WSDL stands for Web Service Description Language, a standard by which a web service can tell clients what messages it accepts and which results it will return. WSDL contains every details regarding using web service Method and Properties provided by web service URLs from which those method can be accessed. Data Types used. Communication Protocol used.
Read more