SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand myCommand = new SqlCommand("UpdateDocument", myConnection); // Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure; // Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ItemID", SqlDbType.Int, 4);
parameterItemID.Value = itemId;
myCommand.Parameters.Add(parameterItemID); SqlParameter parameterModuleID = new SqlParameter("@ModuleID", SqlDbType.Int, 4);
parameterModuleID.Value = moduleId;
myCommand.Parameters.Add(parameterModuleID); SqlParameter parameterUserName = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
parameterUserName.Value = userName;
myCommand.Parameters.Add(parameterUserName); SqlParameter parameterName = new SqlParameter("@FileFriendlyName", SqlDbType.NVarChar, 150);
parameterName.Value = name;
myCommand.Parameters.Add(parameterName); SqlParameter parameterFileUrl = new SqlParameter("@FileNameUrl", SqlDbType.NVarChar, 250);
parameterFileUrl.Value = url;
myCommand.Parameters.Add(parameterFileUrl); SqlParameter parameterCategory = new SqlParameter("@Category", SqlDbType.NVarChar, 50);
parameterCategory.Value = category;
myCommand.Parameters.Add(parameterCategory); SqlParameter parameterContent = new SqlParameter("@Content", SqlDbType.Image);
parameterContent.Value = content;
myCommand.Parameters.Add(parameterContent); SqlParameter parameterContentType = new SqlParameter("@ContentType", SqlDbType.NVarChar, 50);
parameterContentType.Value = contentType;
myCommand.Parameters.Add(parameterContentType); SqlParameter parameterContentSize = new SqlParameter("@ContentSize", SqlDbType.Int, 4);
parameterContentSize.Value = size;
myCommand.Parameters.Add(parameterContentSize); myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
SqlCommand myCommand = new SqlCommand("UpdateDocument", myConnection); // Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure; // Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ItemID", SqlDbType.Int, 4);
parameterItemID.Value = itemId;
myCommand.Parameters.Add(parameterItemID); SqlParameter parameterModuleID = new SqlParameter("@ModuleID", SqlDbType.Int, 4);
parameterModuleID.Value = moduleId;
myCommand.Parameters.Add(parameterModuleID); SqlParameter parameterUserName = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
parameterUserName.Value = userName;
myCommand.Parameters.Add(parameterUserName); SqlParameter parameterName = new SqlParameter("@FileFriendlyName", SqlDbType.NVarChar, 150);
parameterName.Value = name;
myCommand.Parameters.Add(parameterName); SqlParameter parameterFileUrl = new SqlParameter("@FileNameUrl", SqlDbType.NVarChar, 250);
parameterFileUrl.Value = url;
myCommand.Parameters.Add(parameterFileUrl); SqlParameter parameterCategory = new SqlParameter("@Category", SqlDbType.NVarChar, 50);
parameterCategory.Value = category;
myCommand.Parameters.Add(parameterCategory); SqlParameter parameterContent = new SqlParameter("@Content", SqlDbType.Image);
parameterContent.Value = content;
myCommand.Parameters.Add(parameterContent); SqlParameter parameterContentType = new SqlParameter("@ContentType", SqlDbType.NVarChar, 50);
parameterContentType.Value = contentType;
myCommand.Parameters.Add(parameterContentType); SqlParameter parameterContentSize = new SqlParameter("@ContentSize", SqlDbType.Int, 4);
parameterContentSize.Value = size;
myCommand.Parameters.Add(parameterContentSize); myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
解决方案 »
- 导出到Excel的图片问题
- 上传图片
- datalist的item是一个gridview和一个lable,gridview的row里有lnkbutton,如何让linkbutton获得lable的值?
- asp.net&c#中在后台写什么代码,能使控件在页面中显示出来
- 求CS/BS相关类库
- 请教一下COOKIE+SESSION购物车的问题
- 存储过程的简单问题
- 字符取植函数是怎样的?
- asp.net中怎么把Repeater中的数据导入到Excel里
- System.Data.SqlClient.SqlException: 用户 'JACK\ASPNET' 登录失败。
- 我是新手,请大家帮忙呀!!!!!!!!!!!!
- 对字符串的操作!
'login为存储过程名
Imports System.Data.DataSet
Imports System.Data.SqlClientPublic Class Login
Inherits System.Web.UI.Page
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents Textid As System.Web.UI.WebControls.TextBox
Protected WithEvents Textpass As System.Web.UI.WebControls.TextBox
Protected WithEvents RequiredFieldValidator1 As System.Web.UI.WebControls.RequiredFieldValidator
Protected WithEvents submit As System.Web.UI.WebControls.Button
Protected WithEvents ValidationSummary1 As System.Web.UI.WebControls.ValidationSummary
Protected WithEvents RegularExpressionValidator1 As System.Web.UI.WebControls.RegularExpressionValidator
Protected WithEvents RegularExpressionValidator2 As System.Web.UI.WebControls.RegularExpressionValidator
Protected WithEvents RequiredFieldValidator2 As System.Web.UI.WebControls.RequiredFieldValidator Public check As String#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
End Sub Private Sub submit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles submit.Click
If Page.IsValid Then
Dim Sqlconn As SqlConnection
Dim ConString, SQL As String ConString = ConfigurationSettings.AppSettings("ConnStr")
Sqlconn = New SqlConnection(ConString)
Sqlconn.Open() SQL = "select * from member where (user_id='" & Textid.Text & "' and user_pa='" & Textpass.Text & "') or (phone_id='" & Textid.Text & "' and phone_pa='" & Textpass.Text & "')" Dim Sqlcmd As New SqlCommand("login", Sqlconn)
Sqlcmd.CommandType = CommandType.StoredProcedure ' '''''''''''
Dim Sqldr As SqlDataReader
'''''''''
Dim pid As New SqlParameter("@UserID", SqlDbType.VarChar, 8)
Dim ppwd As New SqlParameter("@Password", SqlDbType.VarChar, 8)
Dim phone_id As New SqlParameter("@phone_id", SqlDbType.VarChar, 8)
Dim phone_pa As New SqlParameter("@phone_pa", SqlDbType.VarChar, 8)
With Sqlcmd.Parameters
.Add(pid)
.Add(ppwd)
.Add(phone_id)
.Add(phone_pa)
End With
pid.Value = Trim(Textid.Text)
ppwd.Value = Trim(Textpass.Text)
phone_id.Value = pid.Value
phone_pa.Value = ppwd.Value
Sqldr = Sqlcmd.ExecuteReader If Sqldr.Read() Then
Sqldr.Close()
Sqlconn.Close()
Session("USERID") = Textid.Text
Response.Redirect("GIMS.aspx")
Else
Sqldr.Close()
Sqlconn.Close()
check = "密码不正确"
Response.Redirect("login.aspx?check=" & check)
End If
End If
End Sub
End Class
SqlCommand myCommand = new SqlCommand("strProAnswerB",myConnection);
myCommand.CommandType =CommandType.StoredProcedure;
myCommand.CommandText ="strProAnswerB";
//添加参数
myCommand.Parameters.Add("@ProjName",SqlDbType.VarChar,100);
//参数赋值
myCommand.Parameters["@ProjName"].Value=edtProjName.Text;
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();