数据不会显示在表单中 [英] data is not display in the form

问题描述

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（）;

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();

推荐答案

这个问题已经得到解答。

在这里看到我的回答：

表格中没有提取数据 [ ^ ]



-KR

This question is already been answered.
See my answer over here :
data is not fetch in the form[^]

-KR

这篇关于数据不会显示在表单中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！