ho qst codice:
string connectionString = null;
SqlConnection conn = new SqlConnection();
ConnectionStringSettings settings = WebConfigurationManager.ConnectionStrings["CnnStr"];
if (settings != null)
{
connectionString = settings.ConnectionString;
}
conn.ConnectionString = connectionString;
DataTable getDataTable=new DataTable ();
DataTable ds = null;
SqlDataAdapter adapter = null;
SqlCommand cmd = null;
conn.Open();
string sSQL="SELECT UserName,Password FROM AnagraficaUtenti WHERE UserName='qwerty' and Password='qwerty'";
cmd = new SqlCommand(sSQL, conn);
cmd.CommandType = CommandType.Text;
adapter = new SqlDataAdapter(cmd);
ds = new DataTable();
adapter.Fill(ds);
adapter.Dispose();
mi da l errore nel conn.open...
qlk mi aiuta?
grazie
