hi i tried foreign key constraint in the following code,but not working (i.e not throws error when i tried to delete a row which is used by some other table),pls tell me know what is the issue on the following code
try
{
int salesid = 2;
DataSet ds1 = new DataSet();
DataSet fakeDS = new DataSet();
DataTable dt = null;
fakeDS.ReadXml(@"product.xml");
for (int i = 0; i < ds1.Tables[1].Rows.Count; i++)
{
if (ds1.Tables[1].Rows[i]["salesid"].Equals(salesid.ToString()))
//if (ds1.Rows[i]["productid"].Equals(salesid.ToString()))
{
//dt2.Rows[i].Delete();
Bookmarks