public static DataRow GetTableRow(string ID, string table)
{
string pkSQL = "SELECT column_name FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE
OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1 AND
table_name = '" + table + "';";
DataTable dtPK = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection cnConn = new
SqlConnection(ConfigurationManager.ConnectionStrings["myConnections"].Co
nnectionString);
da.SelectCommand = new SqlCommand(pkSQL, cnConn);
cnConn.Open();
da.fill(dtPK);
string pk = Convert.ToString(dtPK.Rows[0][0]);
string stRow = "SELECT * FROM dbo." + table + " WHERE " + pk
+ " = '" + ID + "';";
DataTable dtRow = new DataTable();
SqlDataAdapter daNr = new SqlDataAdapter();
daNr.SelectCommand = new SqlCommand(stRow, cnConn);
da.Fill(dtRow);
cnConn.Close();
cnConn.Dispose();
DataRow myDataRow = dtRow.Rows[0];
//myDataRow =
return myDataRow;
}
Thursday, September 30, 2010
Get Datarow by PrimaryKey ID and Table Name
Here's the code:
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment