how to data bind from store procedure and data display in

nitish rai

8y823Learn iOS Programming

how to data bind from store procedure and data display in tex box

Please help me.

protected void Page_Load(object sender, EventArgs e)

{

if (!this.IsPostBack)

{

MyLabel.Text = DateTime.Now.ToString("00:01:10 tt");

MyLabel.Visible = false;

}

string connect = ConfigurationManager.ConnectionStrings["demoConnectionString"].ConnectionString;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["demoConnectionString"].ConnectionString);

con.Open();

SqlDataReader myReader = null;

SqlCommand cmd = con.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "GetProcreatePossimate";

DataTable dt = new DataTable();

myReader = cmd.ExecuteReader();

while (myReader.Read())

{

TextBox1.Text = (myReader["Active Power KW"].ToString());

TextBox2.Text = (myReader["Power Factor"].ToString());

TextBox3.Text = (myReader["Current Amp"].ToString());

TextBox4.Text = (myReader["Voltage V"].ToString());

TextBox5.Text = (myReader["Frequency Hz"].ToString());

}

con.Close();

}

code is not work.

2 Replies

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

Dharmraj Thakur8y ago
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["demoConnectionString"].ConnectionString);

SqlCommand cmd = new SqlCommand()
{
    Connection = con,
    CommandType = CommandType.StoredProcedure,
    CommandText = "GetProcreatePossimate"
};

DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter();
adp.Fill(ds);

if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
    DataRow dr = ds.Tables[0].Rows[0];
    TextBox1.Text = (dr["Active Power KW"].ToString());
    TextBox2.Text = (dr["Power Factor"].ToString());
    TextBox3.Text = (dr["Current Amp"].ToString());
    TextBox4.Text = (dr["Voltage V"].ToString());
    TextBox5.Text = (dr["Frequency Hz"].ToString());
}
This is the way you can do.... you have not mensioned that do you want to load multiple textboxes or you have only one row?
+1
Laxmidhar Sahoo8y ago
sir insted of datareader you can use adaptor class like bellow
string connect = ConfigurationManager.ConnectionStrings["demoConnectionString"].ConnectionString;
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["demoConnectionString"].ConnectionString);
            con.Open();
            SqlDataReader myReader = null;
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "GetProcreatePossimate";

            DataSet ds = new DataSet();
            SqlDataAdapter ada = new SqlDataAdapter();
            ada.SelectCommand = cmd;
            ada.Fill(ds);

            DataTable dt = ds.Tables[0];
0