Comments by Member 12005342 (Top 16 by date)

Yes john still searching for the code

Could you please help in the code

Its reading all the values but not displaying .. Even after using execute reader I am getting the same output only last value is getting displayed

In this code I am getting runtime error stating " syntax value error in query" @ Da1.fill(table2);

Hi john can you please help me in writing that code

I am not getting how to save data inside loop without overwrite and display outside

As John said here I am reading all productid for given customerid

And in my DB customer I'd is alphanumeric

Can you please help in this how to add one by one data inside loop
And display all values??

Not getting how to write code foe that

As suggested I created two methods

I stored first database value to array and trying to use in database 2 all working fine but only last value is getting printed

Here is my code:
method1:

using System.Data.SqlClient;

// .....

string queryString = "Select productID from Table1 where custid="+ textbox1.text;

List TempproductID = new List() ;


using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
if (!reader.IsDBNull(0))
{
Tempproductid.add( reader[0].ToString());


}
}
reader.Close();
tempproductid.toarray();
}

method 2:
String stringprovider = "@database connection string ";
for ( int I = 0; I < tempproductid.count; I++)
{
Sqlconnection con2 = new sqlconnection(stringprovider); Con2.open();
Cmd2.connection=con2; Cmd2.commandType = new commandType.text; Cmd2.commandText = "select * from Table2 where Productid = @productid"; Cmd2.parameters.addwithvalue("@productid",Tempproductid[i].to string());

Dataset Ds = new dataset(); sqldataadaptaer da1 = new sqldataadapter(cmd2); Datatable Table2 = new Data table(); Da1.fill(table2);
Datagridview2.source = table2;
}
}

In that for loop only one value is getting in datagridview not getting all

As suggested I created two methods

I stored first database value to array and trying to use in database 2 all working fine but only last value is getting printed

Here is my code:
method1:

using System.Data.SqlClient;

// .....

string queryString = "Select productID from Table1 where custid="+ textbox1.text;

List TempproductID = new List() ;


using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
if (!reader.IsDBNull(0))
{
Tempproductid.add( reader[0].ToString());


}
}
reader.Close();
tempproductid.toarray();
}

method 2:
String stringprovider = "@database connection string ";
for ( int I = 0; I < tempproductid.count; I++)
{
Sqlconnection con2 = new sqlconnection(stringprovider); Con2.open();
Cmd2.connection=con2; Cmd2.commandType = new commandType.text; Cmd2.commandText = "select * from Table2 where Productid = @productid"; Cmd2.parameters.addwithvalue("@productid",Tempproductid[i].to string());

Dataset Ds = new dataset(); sqldataadaptaer da1 = new sqldataadapter(cmd2); Datatable Table2 = new Data table(); Da1.fill(table2);
Datagridview2.source = table2;
}
}

In that for loop only one value is getting in datagridview not getting all

As suggested I created two methods

I stored first database value to array and trying to use in database 2 all working fine but only last value is getting printed

Here is my code:
method1:

using System.Data.SqlClient;

// .....

string queryString = "Select productID from Table1 where custid="+ textbox1.text;

List<string> TempproductID = new List<string>() ;


using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
if (!reader.IsDBNull(0))
{
Tempproductid.add( reader[0].ToString());


}
}
reader.Close();
tempproductid.toarray();
}

method 2:
String stringprovider = "@database connection string ";
for ( int I = 0; I < tempproductid.count; I++)
{
Sqlconnection con2 = new sqlconnection(stringprovider); Con2.open();
Cmd2.connection=con2; Cmd2.commandType = new commandType.text; Cmd2.commandText = "select * from Table2 where Productid = @productid"; Cmd2.parameters.addwithvalue("@productid",Tempproductid[i].to string());

Dataset Ds = new dataset(); sqldataadaptaer da1 = new sqldataadapter(cmd2); Datatable Table2 = new Data table(); Da1.fill(table2);
Datagridview2.source = table2;
  }
}

In that for loop only one value is getting in datagridview not getting all

I have two database In database1 I am having table1 (custid,productid,customername )
Database2 : table2 (productname,productid, pice, mfg)

I want to display all the products purchased by particular custid


Here is my code :
C#

using System.Data.SqlClient;

// .....

string queryString = "Select custID from Table1 where custId ="+ textbox1.text;
String TempCustID;

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
if (!reader.IsDBNull(0))
{
TempCustID = reader[0].ToString();

String stringprovider = "@database connection string ";
Sqlconnection con2 = new sqlconnection(stringprovider);
Con2.open();
Cmd2.connection=con2;
Cmd2.commandType = new commandType.text;
Cmd2.commandText = "select * from Table2 where Productid = @productid";
Cmd2.parameters.addwithvalue("@productid",TempCustID);
}
}
reader.Close();
Dataset Ds = new dataset();
Oledbdataadaptaer da1 = new oledbdataadapter(cmd2);
Datatable Table2 = new Data table();
Da1.fill(table2);
Datagridview2.source = table2;


}


In this I am getting only the first product details of that customer its not displaying all the products at a time.
Please suggest.

I tried constructing query but its giving me error

Here is my code for that
String strsql = "select * from customer where custID = " + TempCustID; //connecting database

DataTable customer = new Datable();
da1.Fill(Customer); // here I am getting error "no value given for one or more required parameters"
Datagridview1.data source = Customer;