SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = new SqlCommand("Select Empid,EmpName,Location from EmpDetails", cnn);
        SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(da);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataColumn[] key = new DataColumn[1];
        key[0] = ds.Tables[0].Columns[0];
        ds.Tables[0].PrimaryKey = key;
        DataRow dr;
        dr = ds.Tables[0].Rows.Find(1);
        dr.Delete();
        da.Update(ds);