select data from database and display it in textbox

Question

my database i like this

no name age
1    n1    32
2    n2    45
3    n3    56

i will give a no and that particular row will be displayed in textboxes
eg
if the no is 1

in textbox1 =1
textbox2=n1
textbox3=32

i am having 2 windows form .the query will be given in one form and data to be displayed in textbox is done in another form .i want to know how to parse query from one form to another
and how to display data in textboxes ?

Iftikar Hussain · Answer

try like this. I don't have much expertise in vb.net therefor you may need to correct syntax error public function LoadData(string data) Dim con As OleDbConnection = New OleDbConnection() con.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Database1.accdb;Persist Security Info=False; Dim sqlCmd As OleDbCommand = New System.Data.OleDb.OleDbCommand() sqlCmd.CommandText = Select nonameage from YourTable where no=@no sqlCmd.Parameters.AddWithValue(@no data); sqlCmd.Connection = con con.Open() Dim reader As OleDbDataReader reader = sqlCmd.ExecuteReader() If reader.HasRows Then While reader.Read() textBox1.Text = reader(no).ToString() textBox2.Text = reader(name).ToString() textBox3.Text = reader(age).ToString() Console.WriteLine(reader(Column1)) 'output specific column End While End If reader.Close() con.close() End function Regards Iftikar

Nandhini Jayachandran · Answer

vb.net

Iftikar Hussain · Answer

you are asking in vb.net or vb? Regards Iftikar

Nandhini Jayachandran · Answer

can u say how to do this in vb with ms acess

Iftikar Hussain · Answer

Hi Try like this In Form 1 ---------- Declare one TextBox and one Button. On Button click write the below code private void button1_Click(object sender EventArgs e) { string data = textBox1.Text; Form2 form2=new Form2(); form2.LoadData(data); this.Hide(); form2.Show(); } In Form 2 ---------- Declare 3 TextBox and write the below method public void LoadData(string data) { using (SqlConnection conn = new SqlConnection(@Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=MyPassword)) { if (conn.State == ConnectionState.Closed) conn.Open(); string sql = Select nonameage from YourTable where no=@no; SqlCommand cmd = new SqlCommand(sql conn); cmd.Parameters.AddWithValue(@no data); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { textBox1.Text = reader[no].ToString(); textBox2.Text = reader[name].ToString(); textBox3.Text = reader[age].ToString(); } reader.Close(); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } } Regards Iftikar