datatable

Vivek Joy

11y987Visual Basic .NET

HI everyone

I need to upload datatable values in grid without using datasource.

I need to know how can we find the count value of datatable

My code is

SqlConnection con = new SqlConnection("server=QB_DT_2\\sqlexpress;database=QbAppDb1;user id=sa;password=admin123");

SqlCommand cmd = new SqlCommand("Select * from QbGroups where Groupname = 'primary'", con);

DataTable dt = new DataTable();

SqlDataReader rdr = null;

rdr = cmd.ExecuteReader();

for (int i = 0; i < dt.Rows.Count; i++)

{

RadGrid.Rows.Add();

RadGrid.Rows[i].Cells[0].Value = rdr["QBGUID"].ToString();

RadGrid.Rows[i].Cells[1].Value = rdr["GroupName"].ToString();

}

7 Replies

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

Priyaranjan K S11y ago
Accepted answer
Please try implementing in this manner .
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT CustomerId, Name, Country FROM Customers"))
{
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
//Create a new DataTable.
DataTable dtCustomers = new DataTable("Customers");

//Load DataReader into the DataTable.
dtCustomers.Load(sdr);
}
con.Close();
}
}

Thanks,
Priyan

If you found this useful Please mark this as Answer
0
Vivek Joy11y ago
Hi sir this is what i actually mean
0
Vivek Joy11y ago
hi sir thank you for your answer

I have another question that is

the below shown is my database

here i need to display the values like

on grid display for Bank_Accounts

under that it should diaplay

Bank Accounts
Cash-in-hand
Deposits (Asset)
Loans & Advances (Asset)
Stock-in-hand
Sundry Debtors

these values then continues to next ie Bank_Od_Account

and it should whter any relating componets are present or not
0
Vivek Joy11y ago
it shows this error

ExecuteReader requires an open and available Connection. The connection's current state is closed.
0
Priyaranjan K S11y ago
Hi Vivek,

You have to update the data table with the execute reader output as below :

DataTable dt = new DataTable();
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
dt.Load(rdr );

Now it should work.

Thanks,
Priyan

If you found this useful Please mark this as Answer.

0
Vivek Joy11y ago
yes

in my code for (int i = 0; i < dt.Rows.Count; i++)

this condition says count value is 0 but in my datatable there are 30 rows.

how can i solve it ?
0
Priyaranjan K S11y ago
what do you mean by 'count value of datatable' . Are you asking for the row count ?

Thanks,
Priyan
0