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 dont 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