不在数据库中插入值 [英] Not inserting values in database
问题描述
以下是代码:
protected void cmdLogin_Click(object sender,EventArgs e)
{
Class1.con = CreateConnection();
string str =从Admin_Profile中选择Ad_Regid WHERE Ad_Regid LIKE @TempPasscode;
cmd = new SqlCommand(str,Class1.con);
cmd.Parameters.AddWithValue(@ TempPasscode,txtcurrentpwd.Text.Trim ());
SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())
{
if(dr [4] .ToString( )== txtcurrentpwd.Text)
{
cmd = new SqlCommand(_ insertAdminLogin,Class1.con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@ AdminType,ddltype.SelectedItem.Text);
cmd.Parameters.AddWithValue(@ AdminUsrname,txtuname.Text);
cmd.Parameters.AddWithValue(@ AdminPwd,txtconfirmpwd.Text);
cmd.ExecuteNonQuery();
}
其他
{
ClientScript.RegisterStartupScript(GetType(),警告,javascript:alert('临时密码不匹配!');,true);
}
}
Sp:
CREATE PROCEDURE [dbo]。[ _insertAdminLogin]
(
@AdminType VARCHAR(100),
@AdUsrname VARCHAR(12),
@ AdminPwd varchar(12)
)
AS BEGIN
INSERT INTO dbo.AdminLogin(AdminType,AdminUsrname,AdminPwd)
VALUES(@AdminType,@ AdUsrname,@ AdminPwd)
结束
}
试试这个Class1.con = CreateConnection();
string str = 从Admin_Profile中选择Ad_Regid在哪里Ad_Regid喜欢@TempPasscode;
cmd = new SqlCommand(str,Class1.con);
if (Class1.con.State == ConnectionState.Closed)
Class1.con.Open();
cmd.Parameters.AddWithValue( @ TempPasscode,txtcurrentpwd.Text.Trim() );
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr [ 4 ]。ToString()== txtcurrentpwd.Text)
{
cmd = new SqlCommand( _ insertAdminLogin,Class1.con);
if (Class1.con.State == ConnectionState.Closed)
Class1.con.Open();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue( @ AdminType,ddltype.SelectedItem.Text);
cmd.Parameters.AddWithValue( @ AdminUsrname,txtuname.Text);
cmd.Parameters.AddWithValue( @ AdminPwd,txtconfirmpwd.Text);
cmd.ExecuteNonQuery();
}
受保护 void cmdLogin_Click( object sender,EventArgs e)
{
Class1.con = CreateConnection();
string str = 从Admin_Profile中选择Ad_Regid在哪里Ad_Regid LIKE'%' + @ TempPasscode + '%';
cmd = new SqlCommand(str,Class1.con);
cmd.Parameters.AddWithValue( @ TempPasscode,txtcurrentpwd.Text 。修剪());
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr [ 4 ]。ToString()== txtcurrentpwd.Text)
{
cmd = new SqlCommand( _ insertAdminLogin,Class1.con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue( @ AdminType,ddltype.SelectedItem.Text);
cmd.Parameters.AddWithValue( @ AdminUsrname,txtuname.Text);
cmd.Parameters.AddWithValue( @ AdminPwd,txtconfirmpwd.Text);
cmd.ExecuteNonQuery();
}
else
{
ClientScript.RegisterStartupScript(GetType(), 警告, javascript:alert('临时密码不匹配!');, true );
}
}
Sp:
CREATE PROCEDURE [dbo]。[_ insertAdminLogin]
(
@AdminType VARCHAR( 100 ),
@AdUsrname VARCHAR( 12 ),
@AdminPwd varchar( 12 )
)
AS BEGIN
INSERT INTO dbo.AdminLogin(AdminType ,AdminUsrname,AdminPwd)
VALUES(@ AdminType,@ AdUsrname,@ AdminPwd)
END
}
您只需尝试此代码
受保护 void cmdLogin_Click( object sender,EventArgs e)
{
Class1.con = CreateConnection();
string str = 从Admin_Profile中选择Ad_Regid在哪里Ad_Regid喜欢@TempPasscode;
cmd = new SqlCommand(str,Class1.con);
con.Open();
cmd.Parameters.AddWithValue( @ TempPasscode,txtcurrentpwd.Text.Trim() );
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr [ 4 ]。ToString()== txtcurrentpwd.Text)
{
cmd = new SqlCommand( _ insertAdminLogin,Class1.con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue( @ AdminType,ddltype.SelectedItem.Text);
cmd.Parameters.AddWithValue( @ AdminUsrname,txtuname.Text);
cmd.Parameters.AddWithValue( @ AdminPwd,txtconfirmpwd.Text);
cmd.ExecuteNonQuery();
con.Close();
}
else
{
ClientScript.RegisterStartupScript(GetType(), 警告, javascript:alert('临时密码不匹配!');, true );
}
}
)
AS BEGIN
INSERT INTO dbo.AdminLogin(AdminType,AdminUsrname,AdminPwd)
VALUES(@AdminType,@ AdUsrname,@ AdminPwd)
结束
}
Here is the code:
protected void cmdLogin_Click(object sender, EventArgs e)
{
Class1.con = CreateConnection();
string str = "SELECT Ad_Regid from Admin_Profile WHERE Ad_Regid LIKE @TempPasscode";
cmd = new SqlCommand(str, Class1.con);
cmd.Parameters.AddWithValue("@TempPasscode", txtcurrentpwd.Text.Trim());
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr[4].ToString() == txtcurrentpwd.Text)
{
cmd = new SqlCommand("_insertAdminLogin", Class1.con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AdminType", ddltype.SelectedItem.Text);
cmd.Parameters.AddWithValue("@AdminUsrname", txtuname.Text);
cmd.Parameters.AddWithValue("@AdminPwd", txtconfirmpwd.Text);
cmd.ExecuteNonQuery();
}
else
{
ClientScript.RegisterStartupScript(GetType(), "Warning", "javascript:alert('Temporary Password Does not Match!');", true);
}
}
Sp:
CREATE PROCEDURE [dbo].[_insertAdminLogin]
(
@AdminType VARCHAR(100),
@AdUsrname VARCHAR(12),
@AdminPwd varchar(12)
)
AS BEGIN
INSERT INTO dbo.AdminLogin (AdminType, AdminUsrname, AdminPwd)
VALUES (@AdminType, @AdUsrname, @AdminPwd)
END
}
try thisClass1.con = CreateConnection(); string str = "SELECT Ad_Regid from Admin_Profile WHERE Ad_Regid LIKE @TempPasscode"; cmd = new SqlCommand(str, Class1.con); if(Class1.con.State==ConnectionState.Closed) Class1.con.Open(); cmd.Parameters.AddWithValue("@TempPasscode", txtcurrentpwd.Text.Trim()); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr[4].ToString() == txtcurrentpwd.Text) { cmd = new SqlCommand("_insertAdminLogin", Class1.con); if(Class1.con.State==ConnectionState.Closed) Class1.con.Open(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AdminType", ddltype.SelectedItem.Text); cmd.Parameters.AddWithValue("@AdminUsrname", txtuname.Text); cmd.Parameters.AddWithValue("@AdminPwd", txtconfirmpwd.Text); cmd.ExecuteNonQuery(); }
protected void cmdLogin_Click(object sender, EventArgs e) { Class1.con = CreateConnection(); string str = "SELECT Ad_Regid from Admin_Profile WHERE Ad_Regid LIKE '%'"+@TempPasscode+"'%'"; cmd = new SqlCommand(str, Class1.con); cmd.Parameters.AddWithValue("@TempPasscode", txtcurrentpwd.Text.Trim()); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr[4].ToString() == txtcurrentpwd.Text) { cmd = new SqlCommand("_insertAdminLogin", Class1.con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AdminType", ddltype.SelectedItem.Text); cmd.Parameters.AddWithValue("@AdminUsrname", txtuname.Text); cmd.Parameters.AddWithValue("@AdminPwd", txtconfirmpwd.Text); cmd.ExecuteNonQuery(); } else { ClientScript.RegisterStartupScript(GetType(), "Warning", "javascript:alert('Temporary Password Does not Match!');", true); } } Sp: CREATE PROCEDURE [dbo].[_insertAdminLogin] ( @AdminType VARCHAR(100), @AdUsrname VARCHAR(12), @AdminPwd varchar(12) ) AS BEGIN INSERT INTO dbo.AdminLogin (AdminType, AdminUsrname, AdminPwd) VALUES (@AdminType, @AdUsrname, @AdminPwd) END }
You Just Try This Code
protected void cmdLogin_Click(object sender, EventArgs e) { Class1.con = CreateConnection(); string str = "SELECT Ad_Regid from Admin_Profile WHERE Ad_Regid LIKE @TempPasscode"; cmd = new SqlCommand(str, Class1.con); con.Open(); cmd.Parameters.AddWithValue("@TempPasscode", txtcurrentpwd.Text.Trim()); cmd.CommandType = CommandType.Text; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr[4].ToString() == txtcurrentpwd.Text) { cmd = new SqlCommand("_insertAdminLogin", Class1.con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AdminType", ddltype.SelectedItem.Text); cmd.Parameters.AddWithValue("@AdminUsrname", txtuname.Text); cmd.Parameters.AddWithValue("@AdminPwd", txtconfirmpwd.Text); cmd.ExecuteNonQuery(); con.Close(); } else { ClientScript.RegisterStartupScript(GetType(), "Warning", "javascript:alert('Temporary Password Does not Match!');", true); } } )
AS BEGIN
INSERT INTO dbo.AdminLogin (AdminType, AdminUsrname, AdminPwd)
VALUES (@AdminType, @AdUsrname, @AdminPwd)
END
}
这篇关于不在数据库中插入值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!