How to read data from datatable in C#

Question

I am developing a login page.First field is User name Secound field is Password and datatable has 3 field which is UserID,Password,UserName.I want to do after login page UserName show in text box how can do this.

Vishwash Roy · Answer

Lets assume that you have a datatable like this. and suppose your DataTable variable name is dtLoginTable. then we can use following code to get userName. string userName = dtLoginTable.Rows[0]["UserName"].ToString(); since there is only one record in datatable i have use zero(0) as row index. Hope this helps.

Methoun Ahmed · Answer

Hi Raesh Palanivel, I am alredy know that process.You don,t understand my question.I want to do read value from datatable.I want to Show userName.

Ramesh Palanivel · Answer

Hi Methoun, I try this code to pass the datatable from one form to another form .. Form1 code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using XsOCR; namespace OCRApplicationTest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load( object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add( "UserId" , typeof ( int )); dt.Columns.Add( "UserName" , typeof ( string )); dt.Columns.Add( "Password" , typeof ( string )); dt.Rows.Add(1, "Ramesh" , "Palanivel" ); Form2 f2 = new Form2(dt); f2.ShowDialog(); } } } Form2 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace OCRApplicationTest { public partial class Form2 : Form { public Form2(DataTable dt) { InitializeComponent(); label1.Text = dt.Rows[0][1].ToString(); } private void Form2_Load( object sender, EventArgs e) { } } }

Ramesh Palanivel · Answer

Hi Methoun, Is it windows form application or web application. If it is windows form application , just declare a variable in main page public static username=""; in Login page, login button event assign the value for that variable, mainform _main=new mainform(); _main.username=textBox1.text in mainform loadin event, textBox1.text=username; It will work and test