OleDB可以正常运行:
private const string SELECTUSERNAMESTRING = "Select * from Users where username=?";
private OleDbCommand cmd = null;
private OleDbConnection ole_con; protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
DataSet data = GetUsersData("test");
string a;
a = data.Tables["Users"].Rows[0]["EMPID"].ToString();
return;
} private void BuildCommand(CommandType ctype, string storedProcName, IDataParameter[] parms)
{
cmd.CommandType = ctype;
cmd.CommandText = storedProcName;
cmd.Parameters.Clear();
//cmd.CommandText = "Select * from Users where username='test'";
//return;
if (parms != null)
{
foreach (IDataParameter parm in parms)
{
cmd.Parameters.Add(parm);
}
} }
public void Open()
{
string s;
s = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;password= ;Initial Catalog=zhuzhoudbbus;Data Source=192.168.0.17";
ole_con = new OleDbConnection(s);
cmd = ole_con.CreateCommand();
} public DataSet GetUsersData(string username)
{
IDataParameter[] parms =
new IDataParameter[]{new OleDbParameter("USERNAME",OleDbType.VarChar,20,"USERNAME")
};
parms[0].Value = username;
DataSet data = new DataSet();
RunProcedure(CommandType.Text, SELECTUSERNAMESTRING, parms, data, "Users");
return data;
}
public void RunProcedure(CommandType ctype, string storedProcName, IDataParameter[] parameters, DataSet dataSet, string tableName)
{
Open(); BuildCommand(ctype, storedProcName, parameters);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); adapter.Fill(dataSet, tableName);
}
protected void Button1_Click1(object sender, EventArgs e)
{
DataSet data = GetUsersData("test");
string a;
a = data.Tables["Users"].Rows[0]["UserID"].ToString();
return;
}SQL却不行:
private const string SELECTUSERNAMESTRING = "Select * from Users where username=?";
private SqlCommand cmd = null;
private SqlConnection ole_con;
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
DataSet data = GetUsersData("test");
string a;
a = data.Tables["Users"].Rows[0]["EMPID"].ToString();
return;
} private void BuildCommand(CommandType ctype, string storedProcName, IDataParameter[] parms)
{
cmd.CommandType = ctype;
cmd.CommandText = storedProcName;
cmd.Parameters.Clear();
//cmd.CommandText = "Select * from Users where username='test'";
//return;
if (parms != null)
{
foreach (IDataParameter parm in parms)
{
cmd.Parameters.Add(parm);
}
} } public void Open()
{
string s;
s = "Persist Security Info=True;User ID=sa;password= ;Initial Catalog=zhuzhoudbbus;Data Source=192.168.0.17";
ole_con = new SqlConnection(s);
cmd = ole_con.CreateCommand();
} public DataSet GetUsersData(string username)
{
IDataParameter[] parms =
new IDataParameter[]{new SqlParameter("USERNAME",SqlDbType.VarChar,20,"USERNAME")
};
parms[0].Value = username;
DataSet data = new DataSet();
RunProcedure(CommandType.Text, SELECTUSERNAMESTRING, parms, data, "Users");
return data;
} public void RunProcedure(CommandType ctype, string storedProcName, IDataParameter[] parameters, DataSet dataSet, string tableName)
{
Open(); BuildCommand(ctype, storedProcName, parameters);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
dataSet.Tables.Add(tableName);
adapter.Fill(dataSet, tableName);
}请问一下是不是在SQL中不支持:“?”的用法
谢谢!
private const string SELECTUSERNAMESTRING = "Select * from Users where username=?";
private OleDbCommand cmd = null;
private OleDbConnection ole_con; protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
DataSet data = GetUsersData("test");
string a;
a = data.Tables["Users"].Rows[0]["EMPID"].ToString();
return;
} private void BuildCommand(CommandType ctype, string storedProcName, IDataParameter[] parms)
{
cmd.CommandType = ctype;
cmd.CommandText = storedProcName;
cmd.Parameters.Clear();
//cmd.CommandText = "Select * from Users where username='test'";
//return;
if (parms != null)
{
foreach (IDataParameter parm in parms)
{
cmd.Parameters.Add(parm);
}
} }
public void Open()
{
string s;
s = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;password= ;Initial Catalog=zhuzhoudbbus;Data Source=192.168.0.17";
ole_con = new OleDbConnection(s);
cmd = ole_con.CreateCommand();
} public DataSet GetUsersData(string username)
{
IDataParameter[] parms =
new IDataParameter[]{new OleDbParameter("USERNAME",OleDbType.VarChar,20,"USERNAME")
};
parms[0].Value = username;
DataSet data = new DataSet();
RunProcedure(CommandType.Text, SELECTUSERNAMESTRING, parms, data, "Users");
return data;
}
public void RunProcedure(CommandType ctype, string storedProcName, IDataParameter[] parameters, DataSet dataSet, string tableName)
{
Open(); BuildCommand(ctype, storedProcName, parameters);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); adapter.Fill(dataSet, tableName);
}
protected void Button1_Click1(object sender, EventArgs e)
{
DataSet data = GetUsersData("test");
string a;
a = data.Tables["Users"].Rows[0]["UserID"].ToString();
return;
}SQL却不行:
private const string SELECTUSERNAMESTRING = "Select * from Users where username=?";
private SqlCommand cmd = null;
private SqlConnection ole_con;
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
DataSet data = GetUsersData("test");
string a;
a = data.Tables["Users"].Rows[0]["EMPID"].ToString();
return;
} private void BuildCommand(CommandType ctype, string storedProcName, IDataParameter[] parms)
{
cmd.CommandType = ctype;
cmd.CommandText = storedProcName;
cmd.Parameters.Clear();
//cmd.CommandText = "Select * from Users where username='test'";
//return;
if (parms != null)
{
foreach (IDataParameter parm in parms)
{
cmd.Parameters.Add(parm);
}
} } public void Open()
{
string s;
s = "Persist Security Info=True;User ID=sa;password= ;Initial Catalog=zhuzhoudbbus;Data Source=192.168.0.17";
ole_con = new SqlConnection(s);
cmd = ole_con.CreateCommand();
} public DataSet GetUsersData(string username)
{
IDataParameter[] parms =
new IDataParameter[]{new SqlParameter("USERNAME",SqlDbType.VarChar,20,"USERNAME")
};
parms[0].Value = username;
DataSet data = new DataSet();
RunProcedure(CommandType.Text, SELECTUSERNAMESTRING, parms, data, "Users");
return data;
} public void RunProcedure(CommandType ctype, string storedProcName, IDataParameter[] parameters, DataSet dataSet, string tableName)
{
Open(); BuildCommand(ctype, storedProcName, parameters);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
dataSet.Tables.Add(tableName);
adapter.Fill(dataSet, tableName);
}请问一下是不是在SQL中不支持:“?”的用法
谢谢!
解决方案 »
- 点击text框出现选择框
- 调用dbhelper类怎么写插入代码?
- 站点部署时报错
- ascx自定义控件。想在里面加引入CSS文件。不用引入,也可以找的到。为什么??
- 按钮老是自动得到焦点
- .NET 里面怎么用Rewrite将整个站点生成静态页面啊?
- 怎么通过程序来获取"http://www.szhome.com/gov/bol/building.aspx?id=3087&Branch=1栋A单元"的文本
- SqlConnection可不可以连接DSN
- 如何做到点击 button1 后能把多个被 checkbox 选中的项的id号转到另一页,并生成新的DataGrid
- 各位大哥:有个问题,我有个控件要在网页上用,但不能确定客户系统中有没有,我想要flash控件一样,若客户端没有就自动下载并装入系统,请问该什样做
- 求学:爬虫技术
- 滚动新闻的一个怪问题
一个是用于Access数据库.
明白?
还有用于Oracle的.