Hi all,
I try to get all data one by one by using sql n array. After done getting all data, and i want bind it into gridview. But the problem arise when it show only one data. The 1st data seem like had overwritten. Can anyone help me with this? Thanks. Below is my code:
SqlConnection myConnection = new SqlConnection(strProvider );
SqlCommand lCmd = new SqlCommand();
// MySqlDataReader lRd;
string lsCmd = null;
SqlTransaction lTx;
DateTime end = Convert.ToDateTime(txtEndDate.Text);
//DateTime start = Convert.ToDateTime(txtEndDate.Text);
string aging = txtAge.Text;
string cust = ddlage.SelectedValue;
DataSet ds_wip;
int count;
myConnection.Open();
lCmd.Connection = myConnection;
//link the transaction command
...
Go to the complete details ...