using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;private void tel_Click(object sender, System.EventArgs e){
string ph_users;
ph_users=phusers.SelectedItem.Value;
SqlConnection myConnection = new SqlConnection ("server=hasigt;uid=sa;pwd=123;database=workstate");
SqlDataAdapter myCommand = new SqlDataAdapter("phone_Add",myConnection);
myCommand.SelectCommand .CommandType=CommandType.StoredProcedure ;
SelectCommand.Parameter.Add(new SqlParameter ("@userid",SqlDbType.VarChar ,40));
SelectCommand.Parameter["@userid"].Value=ph_users;
myConnection.Open ();
myCommand.GetHashCode();
myConnection.Close ();找不到类型或命名空间名称“SelectCommand”(是否缺少 using 指令或程序集引用?)请问该怎么修改?
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;private void tel_Click(object sender, System.EventArgs e){
string ph_users;
ph_users=phusers.SelectedItem.Value;
SqlConnection myConnection = new SqlConnection ("server=hasigt;uid=sa;pwd=123;database=workstate");
SqlDataAdapter myCommand = new SqlDataAdapter("phone_Add",myConnection);
myCommand.SelectCommand .CommandType=CommandType.StoredProcedure ;
SelectCommand.Parameter.Add(new SqlParameter ("@userid",SqlDbType.VarChar ,40));
SelectCommand.Parameter["@userid"].Value=ph_users;
myConnection.Open ();
myCommand.GetHashCode();
myConnection.Close ();找不到类型或命名空间名称“SelectCommand”(是否缺少 using 指令或程序集引用?)请问该怎么修改?
解决方案 »
- 用户 'NT AUTHORITY\SYSTEM' 登录失败
- .net弹窗提示问题
- asp.net表单无法提交的问题
- 继承IDisposable接口重写了Dispose()方法,问会自动调用这个方法?
- 关于字符过滤的问题?
- 送分: 一个 javascript 和 asp.net C# 配合使用的 问题
- 关于asp.net类浏览器classbrowser的问题
- 如何实现某个程序的自动运行
- sharepoint 2013中自定义站点的母版页中添加一个button,再添加一个cs,如何在cs中调用母版页的button事件
- DataFormatString如何定义百分数据显示数据?
- 有人用过资源文件吗? 用过请进来看看? 谢谢
- 请问在DataGrid中操作CheckBox的问题
myCommand.CommandType=CommandType.StoredProcedure ;
myCommand.Parameter.Add(new SqlParameter ("@userid",SqlDbType.VarChar ,40));
myCommand.Parameter["@userid"].Value=ph_users;
myConnection.Open ();
myCommand.GetHashCode();
myConnection.Close ();
myCommand.CommandType=CommandType.StoredProcedure;OleDbParameter a;
a=new OleDbParameter("@userid",OleDbType.Char,40);
a.Direction=ParameterDirection.Input;
a.Value=ph_users;
myCommand.Parameters.Add(a);myCommand.ExecuteNonQuery();
myConnection.Close();