read values from sqldatabase

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 System.Data.OleDb;
namespace Textbox_related_data
{
    public partial class Form1 : Form
    {
        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
        OleDbCommand com;
        string str;

        public Form1()
        {
            InitializeComponent();
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            textBox2.Text = "";
            textBox3.Text = "";

            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from emp where mobile='" + textBox1.Text + "'";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                textBox2.Text = reader["name"].ToString();
                textBox3.Text = reader["referalid"].ToString();
            }
            con.Close();
            reader.Close();
        }

       
    }
}

hi,

i think this is same as
http://www.c-sharpcorner.com/Forums/Thread/213479/read-the-values-fraom-table.aspx

use this query in texbox1_textchanged event after autopostback tru of first tbox.
sqlconnection conn=new sqlconnection("your connection string");
sqlcommand cmd=new sqlcommand("select top(1) name,referalid from table where mobile='"+textbox1.Text+"'", conn);
sqldataadapter da=new sqldataadapter(cmd);
datatable dt=new datatable();
da.Fill(dt);
textbox2.Text=dt.rows[0]["name"].tostring();
textbox3.Text=dt.rows[0]["referalid"].tostring();


mark as answered if helpfull

Hi Vinay,

create an event OnTextChanged in your mobile textbox and make AutoPostBack="True" in this textbox. Write code to display name and referal Id in OnTextChanged  event

Thanks
RA