SELECT 4 FIELDS SEND SMS TO MOBILE

Question

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

Akkiraju Ivaturi · Answer

string empData = ; 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();