select data from database and display it in textbox

Nandhini Jayachandran

13y1.8kSQL

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 ?

5 Replies

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

Iftikar Hussain13y ago
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 no,name,age 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 Jayachandran13y ago
vb.net
Iftikar Hussain13y ago
you are asking in vb.net or vb?

Regards,
Iftikar
Nandhini Jayachandran13y ago
can u say how to do this in vb with ms acess
Iftikar Hussain13y ago
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 no,name,age 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