select particular column value from database to datatable

Meena S

dr1[0] = comboBox3.Text;

dr1[1] = obj.ReturnString("Select Itemcode from Item");

i want this code in C# can u please suggest

how to get value from database to particular column of datatable.

2 Replies

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

Rafnas T P7y ago
Accepted answer
hi,

Datatable having rows and columns so you can do as shown below

if your datatable name is dt then

dt.Rows[0][0] = comboBox3.Text;
dt.Rows[0][1] = obj.ReturnString("Select Itemcode from Item");
Rajanikant Hawaldar7y ago
Hi Meena, Refer this sample code private SqlConnection Conn; private void CreateConnection() { string ConnStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; Conn = new SqlConnection(ConnStr); } public DataTable getData() { CreateConnection(); string SqlString = "SELECT itemcode FROM item"; SqlDataAdapter sda = new SqlDataAdapter(SqlString, Conn); DataTable dt = new DataTable(); try { Conn.Open(); sda.Fill(dt); } catch (SqlException se) { MessageBox. Show(se.Mesaage.ToString()); } finally { Conn.Close(); } return dt; }