如何在asp.net c＃中组合名字和姓氏，并从数据库中读取它 [英] how to combine first name and last name in asp.net c# and read it from database

问题描述

亲爱的朋友们，



如何在asp.net c＃中组合名字和姓氏，并从数据库中读取。



这是我的代码。



BtnSearch_Click

============= ====

 SqlConnection con =  new  SqlConnection（_connString）; 
 SqlCommand cmd =  new  SqlCommand（）; 
 cmd.Connection = con; 
 cmd.CommandText =  从ResidentTable中选择FirstName，LastName，CompanyName，Department，Location，MobileNo，其中EmployeeNo = ' + TxtSearch.Text +  '; 
 
 使用（con）
 {
 con.Open（）; 
 SqlDataReader reader = cmd.ExecuteReader（）; 
  if （reader.Read（））
 {
 lblFirstName.Text = reader [  FirstName]。ToString（）; 
 lblLastName.Text = reader [  LastName]。ToString（）; 
 lblCompanyName.Text = reader [  CompanyName]。ToString（）; 
 lblDepartment.Text = reader [  Department]。ToString（）; 
 lblLocation.Text = reader [  Location]。ToString（）; 
 lblMobileNo.Text = reader [  MobileNo]。ToString（）; 
} 
 
  else  
 {
 lblFirstName.Text =  ; 
 lblLastName.Text =  ; 
 lblCompanyName.Text =  ; 
 lblDepartment.Text =  ; 
 lblLocation.Text =  ; 
 lblMobileNo.Text =  ; 
 
 ScriptManager.RegisterStartupScript（ this ， this  .GetType（），  RunCode，  javascript：alert（'员工编号不存在，请再试一次。'）;， true ）; 
 
} 

当我输入员工编号后点击搜索按钮
必须合并名字和姓氏，并且必须显示为Sandeep Kumar 。



这里，名字是Sandeep，姓氏是Kumar。

但它应该显示为Sandeep Kumar。



请帮助..

谢谢

解决方案

使用C＃非常简单。 ;）

 字符串 name =  string  .empty; 
 
f（reader.Read（））
 {
 lblCompanyName.Text = reader [ 公司名称]的ToString（）; 
 lblDepartment.Text = reader [  Department]。ToString（）; 
 lblLocation.Text = reader [  Location]。ToString（）; 
 lblMobileNo.Text = reader [  MobileNo]。ToString（）; 
 
  name = reader [  FirstName]。ToString（ ）+   + reader [  LastName]。ToString（）; 
 nameLbl.Text = name;  
} 

-KR

尝试：

 cmd.CommandText =   SELECT FirstName +''+ LastName，CompanyName，Department，Location，MobileNo来自ResidentTable，其中EmployeeNo =' + TxtSearch.Text +  '; 

但请不要这样做！不要连接字符串以构建SQL命令。它让您对意外或故意的SQL注入攻击持开放态度，这可能会破坏您的整个数据库。请改用参数化查询。

 cmd.CommandText =   SELECT FirstName +''+ LastName，CompanyName，Department，Location，来自ResidentTable的MobileNo，其中EmployeeNo = @ EN; 
 cmd.Parameters.AddWithValue（  @ EN，TxtSearch.Text）; 

这很容易做到 -

 cmd.CommandText =   SELECT FirstName + LastName FullName，FirstName，LastName，CompanyName，Department，Location，MobileNo来自ResidentTable，其中EmployeeNo =' + TxtSearch。< span class =code-keyword>文本 +  '; 

Dear frnds,

how to combine first name and last name in asp.net c# and read it from database.

This is my code.

BtnSearch_Click
=================

SqlConnection con = new SqlConnection(_connString); 
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT FirstName,LastName,CompanyName,Department,Location,MobileNo from ResidentTable where EmployeeNo='" + TxtSearch.Text + "'";

        using (con)
        {
            con.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read())
            {
lblFirstName.Text = reader["FirstName"].ToString();
lblLastName.Text = reader["LastName"].ToString();
lblCompanyName.Text = reader["CompanyName"].ToString();
lblDepartment.Text = reader["Department"].ToString();
lblLocation.Text = reader["Location"].ToString();
lblMobileNo.Text = reader["MobileNo"].ToString();
}

else
{
lblFirstName.Text = "";
lblLastName.Text = "";
lblCompanyName.Text="";
lblDepartment.Text="";
lblLocation.Text="";
lblMobileNo.Text="";

ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Employee No. not exists,  please try again.');", true);

}

when i click search button after entering employee No. The First Name and Last Name must be combined and must be displayed as Sandeep Kumar.

here, First Name is Sandeep and Last Name is Kumar.
But it should be displayed as Sandeep Kumar.

Please help ..
THANKS

解决方案

It's pretty simple using C#. ;)

string name = string.empty;

f (reader.Read())
{
    lblCompanyName.Text = reader["CompanyName"].ToString();
    lblDepartment.Text = reader["Department"].ToString();
    lblLocation.Text = reader["Location"].ToString();
    lblMobileNo.Text = reader["MobileNo"].ToString();
    
    name = reader["FirstName"].ToString() + " " + reader["LastName"].ToString();
    nameLbl.Text = name;
}

-KR

Try:

cmd.CommandText = "SELECT FirstName + ' ' + LastName, CompanyName, Department, Location, MobileNo from ResidentTable where EmployeeNo='" + TxtSearch.Text + "'";

But please, don't do that! Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.

cmd.CommandText = "SELECT FirstName + ' ' + LastName, CompanyName, Department, Location, MobileNo from ResidentTable where EmployeeNo=@EN";
cmd.Parameters.AddWithValue("@EN", TxtSearch.Text);

This is quite easy to do -

cmd.CommandText = "SELECT FirstName + LastName FullName, FirstName,LastName,CompanyName,Department,Location,MobileNo from ResidentTable where EmployeeNo='" + TxtSearch.Text + "'";

这篇关于如何在asp.net c＃中组合名字和姓氏，并从数据库中读取它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！