using (SqlCommand sqlCmd = new SqlCommand()) { sqlCmd.CommandText = "SELECT LNAME FROM PAYMAST"; sqlCmd.Connection = sqlConn; sqlConn.Open(); SqlDataAdapter da = new SqlDataAdapter(sqlCmd); DataTable dt = new DataTable(); da.Fill(dt); DropDownList1.DataSource = dt; DropDownList1.DataValueField = "LNAME"; DropDownList1.DataTextField = "LNAME"; DropDownList1.DataBind(); sqlConn.Close();
sqlCmd.CommandText = "SELECT LNAME + ' ' + FNAME AS [Name] FROM PAYMAST"; ... DropDownList1.DataValueField = "Name"; DropDownList1.DataTextField = "Name";
sqlCmd.CommandText = "SELECT LTRIM(RTRIM(LNAME + ' ' + FNAME)) AS [Name] FROM PAYMAST";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)