this the solution
int flg = 0,flg1=0;
foreach (string chk in City)
{
foreach (string skls in keyskills)
{
cmd = new SqlCommand("Mat_Part2", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Keys", SqlDbType.VarChar).Value = skls;
cmd.Parameters.Add("@HighQualification", SqlDbType.VarChar).Value = HighQualification;
cmd.Parameters.Add("@Exp", SqlDbType.Int).Value = TotalExpYear;
cmd.Parameters.Add("@Location", SqlDbType.VarChar).Value = chk;
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (flg == 0)
{
mainTable = dt.Clone();
flg++;
}
DataRow dRow;
foreach (DataRow row in dt.Rows)
{
if (flg1 == 0)
{
mainTable = dt.Copy();
flg1++;
}
int xts = mainTable.Rows.Count;
for (int cv = 0; cv < xts; cv++)
{
dRow = mainTable.NewRow();
for (int gh = 0; gh < dt.Rows.Count; gh++)
{
int yst = Convert.ToInt32(dt.Rows[gh]["Id"].ToString());
int pretemp = 0;
int flag = 0;
while (pretemp < mainTable.Rows.Count)
{
int xst = Convert.ToInt32(mainTable.Rows[pretemp]["Id"].ToString());
if (xst == yst)
{
flag = 1;
}
pretemp++;
}
if (flag == 0)
{
dRow.ItemArray = row.ItemArray;
mainTable.Rows.Add(dRow);
}
}
}
}
}
}