Hi
Pls help me to slove this problem.I have a method and I pass a dataset to it.and inside the
method it generate another dataset,i want to join dataset1 and dataset2.How do i do tha
below I mention the coidng,it just testing coding.In dataset it contains Retailercode and dataset 2 it also contains RetailerCode,so I want to join both dataset and generate another dataset.
public void Process_Start(DataSet D3)
{
int y = 3;
SqlConnection Con3 = new SqlConnection("Data Source=IT;Initial Catalog=Test;Integrated Security=True");
Con3.Open();
for (int i = 0; i < y;i++)
{
MessageBox.Show(D3.Tables[0].Rows[i]["Shop_Code"].ToString());
string str2 = "Select SalesExecutiveCode,ID from Retailer where RetailerCode='" +"00000"+ D3.Tables[0].Rows[i]["Shop_Code"] + "'";
SqlDataAdapter da4 = new SqlDataAdapter(str2, Con3);
DataSet dt2 = new DataSet();
da4.Fill(dt2,"Test");