ASP.NET C# Code
Posted on 2008-02-11
I can get the text below to populate my output.
How do I get the "eng" to populate with the data from the SQl Server?
It's always going to be a single record and a single field that's returned.
private void QueryDatabase2()
strSQL99 = @"SELECT eng FROM tblCategoryWelcome WHERE category = 'oceanfront'";
string conString = @"Data Source=mydata.com;Database=db1;UID=user;PWD=password";
SqlConnection myConn = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand(strSQL99, myConn);
eng = "Data Here";