pls check this query?

Hardik Patel

try

{

string query = "";

// query += "SELECT WOInwardEntry.InvoiceNo FROM WOInwardEntry INNER JOIN WO ON WOInwardEntry.WOCode = WO.WOCode where WOInwardEntry.WOCode = '" + ddWONumber.SelectedItem.Value + "'";

query += "select InvoiceNo,InvoiceDate,InwardDate from WOInwardEntry where wocode ='" + ddWONumber.SelectedItem.Value + "'";

cmd = new SqlCommand(query, cn);

da = new SqlDataAdapter(cmd);

da.Fill(ds);

if ((ds != null) && (ds.Tables.Count != 0) && (ds.Tables[0].Rows.Count != 0))

{

txtInvoiceNo.Text = ds.Tables[0].Rows[0]["InvoiceNo"].ToString();

txtInvoiceDate.Text = Convert.ToDateTime( ds.Tables[0].Rows[0]["InvoiceDate"]).ToString("dd-mm-yyyy");

txtInwardDate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["InwardDate"]).ToString("dd-mm-yyyy");

}

//FillItems();

}

catch { }

finally { }

is it right to retrive more than one raw?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhineet Srivastava13y ago
Why not,You are using loop!
Syed Rizwan13y ago
if you are trying to retrive more than one raw then you need to loop over collection in this case ds and use textbox inside repeater or gridview.
Riyaz Akhtar13y ago
Your code looks fine.only problem is you are reading only 1st row, so if your query returns more than one records then it will ignored.

if u have more than one rows then i suggest to use textbox inside repeater or gridview.
Iftikar Hussain13y ago
Hi,
Are you trying to bind your output to any grid?

Regards,
Iftikar