C
Carlos
When I try to access a SQL Saved view calleed FilteredLead I do not get
anythin back on asp.net if I run same SQL command on the SQL Editor I get
all my results. Is it any way to use views in C# diffrent than tables ?
See my code
MyString = "SELECT * from FilteredLead";
//where fullname like '%ja%'
SqlConnection myConnection = new
SqlConnection("server=TEST;database=CRMTEST_MSCRM;UID=Joe;PWD=xxxx");
SqlCommand myCommand = new SqlCommand(MyString, myConnection);
SqlDataReader reader;
string tempTotal = "";
try
{
myConnection.Open();
reader = myCommand.ExecuteReader();
while (reader.Read())
{
Response.Write(reader[0].ToString());
}
}
catch (SqlException ex)
{
Response.Write(ex.ToString());
}
anythin back on asp.net if I run same SQL command on the SQL Editor I get
all my results. Is it any way to use views in C# diffrent than tables ?
See my code
MyString = "SELECT * from FilteredLead";
//where fullname like '%ja%'
SqlConnection myConnection = new
SqlConnection("server=TEST;database=CRMTEST_MSCRM;UID=Joe;PWD=xxxx");
SqlCommand myCommand = new SqlCommand(MyString, myConnection);
SqlDataReader reader;
string tempTotal = "";
try
{
myConnection.Open();
reader = myCommand.ExecuteReader();
while (reader.Read())
{
Response.Write(reader[0].ToString());
}
}
catch (SqlException ex)
{
Response.Write(ex.ToString());
}