从Sql server 2005数据库检索数据并将其显示在c＃ASP.net的文本框中时的另一个问题 [英] Another problem while retrieving data from Sql server 2005 database and display it into textbox in c# ASP.net

问题描述

如果我在一个文本框中显示数据，下面提到的代码工作正常，但如果我添加多个texbox，则会出现错误====用户代码未处理无效操作异常



Pls Pls有人帮助我....



谢谢

Kshitija

Below mentioned code is working fine if i display data in one textbox but if if i add multiple texboxes it gives error==== "invalid operation exception was unhandled by user code"

Pls Pls Somebody help me....

thanks
Kshitija

SqlCommand cmd = default(SqlCommand);
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
        con.Open();
        cmd = new SqlCommand("Select * from Call_Reg where Complaint_no='" + ddlupCompl.SelectedItem.ToString() + "'", con);
        SqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())

            txtFname.Text = Convert.ToString(reader["Cust_FName"]);
            txtLname.Text = Convert.ToString(reader["Cust_LName"]);
            txtPh.Text = Convert.ToString(reader["ph_no"]);
            txtMob.Text = Convert.ToString(reader["mob_no"]);
        con.Close();

推荐答案

while (reader.Read())
{
            txtFname.Text = Convert.ToString(reader["Cust_FName"]);
            txtLname.Text = Convert.ToString(reader["Cust_LName"]);
            txtPh.Text = Convert.ToString(reader["ph_no"]);
            txtMob.Text = Convert.ToString(reader["mob_no"]);
}

你错过了括号

you missed the parenthesis

这篇关于从Sql server 2005数据库检索数据并将其显示在c＃ASP.net的文本框中时的另一个问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！