如题,我使用同一段代码在有窗体时执行通过,而在无窗体时总提示出错.
以下是我的代码:
string dataLink = ".....";
SqlConnection conn = new SqlConnection(dataLink);
conn.Open();
string sqlStr = "SELECT * FROM USERDATA ";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
SqlDataAdapter sqlAd = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sqlAd.Fill(ds, "USERDATA");执行到最后这句就出问题了.请各位指点迷津.
以下是我的代码:
string dataLink = ".....";
SqlConnection conn = new SqlConnection(dataLink);
conn.Open();
string sqlStr = "SELECT * FROM USERDATA ";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
SqlDataAdapter sqlAd = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sqlAd.Fill(ds, "USERDATA");执行到最后这句就出问题了.请各位指点迷津.
Debug一下看问题出在哪里
这样试试:
string dataLink = ".....";
SqlConnection conn = new SqlConnection(dataLink);
conn.Open();
string sqlStr = "SELECT * FROM USERDATA ";
SqlDataAdapter sqlAd = new SqlDataAdapter(sqlStr,conn);
DataSet ds = new DataSet();
sqlAd.Fill(ds, "USERDATA");
未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 system.data.dll 中.PS:刚刚转到C#来还不太明白如何调试,谁给大概讲下调试的思路也行.
再从菜单上执行Debug-->start就可以了
SqlCommandBuilder cmb = new SqlCommandBuilder(sqlAd );//添加这行代码
DataSet ds = new DataSet();
sqlAd.Fill(ds, "USERDATA");
TO:bufan2162(步帆) 有打开没有关闭试因为后面还有代码我没有贴出来.
TO:JasonHeung(拥有一切不过就这样笑着哭) 我试着创建了你所说的SqlCommandBuilder类,可是不行,还是出同样的问题.可能问题不是出在这里.
using System.Data;
using System.Data.Client;
{
string dataLink = ".....";
SqlConnection conn = new SqlConnection(dataLink);
conn.Open();
string sqlStr = "SELECT * FROM USERDATA ";
SqlDataAdapter sqlAd = new SqlDataAdapter(sqlStr,conn);
DataSet ds = new DataSet();
sqlAd.Fill(ds, "USERDATA");
}
catch(Exception ex)
{
...
}把ex的内容贴上来.
你的错误,好像是sql语句问题,错误信息还可以再完整一些!
{
string dataLink = ".....";
SqlConnection conn = new SqlConnection(dataLink);
string sqlStr = "SELECT * FROM USERDATA ";//自己确认没有错,表名区分大小写
SqlDataAdapter sqlAd = new SqlDataAdapter(sqlStr,conn);
DataSet ds = new DataSet();
sqlAd.Fill(ds);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}