data is not fetch in the form

Question

2.00/5 (1 vote)

See more:

protected void BtnCase_Click(object sender, EventArgs e)
{
if (!(IsPostBack))
{
if (Request.QueryString.HasKeys() && Request.QueryString["id"].ToString() != null)
{

SqlConnection sc = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["hospitalmanagementdb"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from patient where patient_id= " + Request.QueryString["id"].ToString();
cmd.Connection = sc;
sc.Open();
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
sc.Close();

txtFirstnm.Text = sdr[1].ToString();
txtLastnm.Text = sdr[2].ToString();
RadioMF.Text = sdr[3].ToString();
txtAge.Text = sdr[4].ToString();
txtContact.Text = sdr[5].ToString();
txtEmail.Text = sdr[6].ToString();
txtAddress.Text = sdr[7].ToString();

}
}
}

there is no error but data from table can not be display in form

Posted 24-Mar-14 5:30am

Member 10694442

Add a Solution

3 solutions

Solution 1

How do you know there is no error? You aren't checking...

The most likely reasons for it not displaying anything are that it failed one of your tests:
IsPostBack could be true.
HasKeys could return false - there are no keys.
They may not be a query string "id".

In this case, I suspect IsPostBack, since it will always be true for a button click event handler...

Posted 24-Mar-14 5:53am

OriginalGriff

Comments

Member 10694442 24-Mar-14 12:17pm

still data can not be fetched

OriginalGriff 24-Mar-14 12:27pm

So what is happening?
Have you used the debugger at all to look at what actually does happen?

Solution 2

You need to remove:

if (!(IsPostBack))
 {
 }

That is why your code is not running.

[EDIT]

Change your query to this:

cmd.CommandText = "select * from patient where patient_id= '" + Request.QueryString["id"].ToString() + "'";

This will work provided you are actually passing "id" in the query string.

Posted 24-Mar-14 5:54am

Richard C Bishop

Updated 24-Mar-14 6:50am

v3

Comments

Member 10694442 24-Mar-14 12:19pm

still data not display

Richard C Bishop 24-Mar-14 12:24pm

Is your query returning anything?

Member 10694442 24-Mar-14 12:37pm

no

Richard C Bishop 24-Mar-14 12:39pm

Ok, have a look at my updated solution and use that code.

Member 10694442 24-Mar-14 13:07pm

oh no its also not worked

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Accepted Answer · 2014-03-24T08:11:00

C#

protected void BtnCase_Click(object sender, EventArgs e)
{
if (!(IsPostBack))
{
if (Request.QueryString.HasKeys() && Request.QueryString["id"].ToString() != null)
{
 
SqlConnection sc = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["hospitalmanagementdb"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from patient where patient_id= " + int.Parse(Request.QueryString["id"].ToString());  // or .... patient_id = '" + Request.QueryString["id"]+ "'";
cmd.Connection = sc;
sc.Open();
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
sc.Close();
 
txtFirstnm.Text = sdr[1].ToString();
txtLastnm.Text = sdr[2].ToString();
RadioMF.Text = sdr[3].ToString();
txtAge.Text = sdr[4].ToString();
txtContact.Text = sdr[5].ToString();
txtEmail.Text = sdr[6].ToString();
txtAddress.Text = sdr[7].ToString();

}
}
}

-KR

data is not fetch in the form

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

data is not fetch in the form

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us