CUSTMER Table AS Follows;
CUSID CUSNAME CUSDOB CUSADD CUSMOB CUSBILL
1 Raj 12/01/1990 HYD 8985500789 280
2 Ram 1 13/01/1990 HYD 898556789 900
from the above CUSTMER Table i wan the output as follows
READ 4 FIELDS (CUSNAME,CUSADD,CUSBILL,CUSDOB) TO SEND THE SMS TO CUS MOBILE
HOW TO WRITE THE QUARIE IN C#.NET
Loading
Akkiraju IvaturiPosted Jan 21, 2013, 10:57 PM
SqlConnection sqlConnection1 = new SqlConnection("Your Connection String");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "select EMPNAME + ' ' + EMPADD + ' ' + CAST(EMPMOBILE AS VARCHAR(100)) + ' ' + CAST(EMPSALARY AS VARCHAR(100)) as EMPDETAILS FROM EMP WHERE EMPID="+ EMPID;
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
reader = cmd.ExecuteReader();
while(reader.Read())
{
empData = reader.GetValue(0);
}
sqlConnection1.Close();