DZone Snippets: ado code

Using Rows.Find in ADO.NET

brainwipe (Rob Lang) — Mon, 19 Mar 2007 16:01:02 GMT

When using a DataTable in ADO.NET, you may want to search your table given a key. The Find method requires the index of the primary key to find the row that you're looking for. However, before you do this you must set the primary key of the Datatable. Setting the primary key in your database is not enough. To set the primary key, create a new column and then set the primary key field on the Datatable like so:





// Create the DataColumn list for holding the columns of the primary keys. In this case, we are using only one primary key

DataColumn[] primaryKeyColumns = new DataColumn[1];



// Set the first primary key to the column 'id' in the datatable

primaryKeyColumns[0] = myDataTable.Columns["id"];



// Now apply the primary key to the datatable

myDataTable.PrimaryKey = primaryKeyColumns;

RecordSet to tab-separated values

mrclay (Steve Clay) — Wed, 07 Mar 2007 21:51:49 GMT



Function TSV(rs)

	Dim field

	For Each field In rs.Fields

		TSV = TSV & field.Name & VBTab

	Next

	TSV = Left(TSV, Len(TSV) - 1) & vbCr & rs.GetString()

End Function

The rows are separated by vbCr ("\r" in most languages).
The first row is the field names.

conectarte a una base de datos con .net

ivan_cursos (Ivan) — Thu, 06 Apr 2006 21:44:35 GMT

// description of your code here



SqlConnection conn = null;

SqlCommand cmd = null;

SqlDataReader dr = null;



String s = null;

Product prod = null;



try

{

	conn = new SqlConnection("Provider=SQLOLEDB;SERVER=sissql2;UID=sa;PWD=AlfaRoma440;DATABASE=genericatest2");



	s = " ";





	cmd = new SqlCommand(s,conn);

	dr = cmd.ExecuteReader();

	// lleno el objeto producto



	while( dr.Read())

	{



	}





}

catch (Exception ex)

{

	// poner el manejo de errores	

}

finally

{

	dr.Close();

	conn.Close();

}

dr.Close();

conn.Close();

return prod;

}