No error alert but new record still no insert to database
my procedure:
ALTER PROCEDURE [dbo].[insert_lienlac]
-- Add the parameters for the stored procedure here
@name nvarchar(max),
@Email nvarchar(max),
@subject nvarchar(max),
@content nvarchar(max)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO lienlac (name, Email, subject , content)
VALUES (@name, @Email, @subject , @content )
END
my cs file in App_Code:
public class Lienlac : SqlDataProvider
{
public SqlDataAdapter da1 = new SqlDataAdapter();
public void Insert_Lienlac(string name, string Email, string subject, string content )
{
try
{
using (SqlCommand dbCmd = new SqlCommand("insert_lienlac", GetConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.AddWithValue("@name", name);
dbCmd.Parameters.AddWithValue("@Emai",Email);
dbCmd.Parameters.AddWithValue("@subject ",subject );
dbCmd.Parameters.AddWithValue("@content",content);
da1.InsertCommand = dbCmd;
}
}
catch (Exception ex)
{
MsgBox(ex.ToString() + " ham insert lien lac");
}
disconnect();
}
}
my SqlDataProvider cs file:
public class SqlDataProvider
{
// private static string strConStr = "Data Source=112.213.89.173;Initial Catalog=baucana;User ID=MRSTAR;Password=123456";
private static string strConStr = "Data Source=VIETFORUM;Initial Catalog=datatest;Integrated Security=True";
//private static string strConStr="workstation id=baucana.mssql.somee.com;packet size=4096;user id=yeutuihokha;pwd=34557897;data source=baucana.mssql.somee.com;persist security info=False;initial catalog=baucana";
/// <summary>
/// Global SQL server connection
/// </summary>
public static SqlConnection connection;
public SqlDataProvider()
{
if (connection == null) { connection = new SqlConnection(strConStr); }
//if (connection.State != ConnectionState.Open) { connection.Open(); }
}
public static SqlConnection GetConnection()
{
if (connection.State == ConnectionState.Closed)
{
//connection.Close();
connection.Open();
return connection;
}
else
return connection;
}
public static SqlConnection disconnect()
{
if (connection.State == ConnectionState.Open)
{
//connection.Close();
connection.Close();
return connection;
}
else
return connection;
}
#region DB Access Functions
public DataTable GetData(string sql)
{
return GetData(GetCommand(sql));
}
public DataTable GetData(SqlCommand cmd)
{
try
{
if (cmd.Connection == null) { cmd.Connection = GetConnection(); }
using (DataSet ds = new DataSet())
{
using (SqlDataAdapter da = new SqlDataAdapter())
{
da.SelectCommand = cmd;
da.Fill(ds);
return ds.Tables[0];
}
}
}
finally
{
}
}
public void ExecuteNonQuery(string sql)
{
ExecuteNonQuery(GetCommand(sql));
}
public void ExecuteNonQuery(SqlCommand cmd)
{
try
{
if (cmd.Connection == null) { cmd.Connection = GetConnection(); }
cmd.ExecuteNonQuery();
}
finally
{
}
}
public object ExecuteScalar(string sql)
{
return ExecuteScalar(GetCommand(sql));
}
public object ExecuteScalar(SqlCommand cmd)
{
try
{
if (cmd.Connection == null) { cmd.Connection = GetConnection(); }
return cmd.ExecuteScalar();
}
finally
{
}
}
private SqlCommand GetCommand(string sql)
{
SqlCommand cmd = new SqlCommand(sql, GetConnection());
return cmd;
}
public string MaxId(string Table, string ColId)
{
string strReturn = "";
strReturn = ExecuteScalar("SELECT max(" + ColId + ") as maxid FROM " + Table).ToString();
return strReturn;
}
public int DBSize()
{
using (SqlCommand cmd = new SqlCommand("select sum(size) * 8 * 1024 from sysfiles"))
{
cmd.CommandType = CommandType.Text;
return (int)ExecuteScalar(cmd);
}
}
#endregion DB Access Functions
}
my apsx page:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<%@ Register Src="Client_usercontrol/Album_ads.ascx" TagName="Album_ads" TagPrefix="uc1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div id="contact-page" class="container">
<div class="bg">
<div class="row">
<div class="col-sm-8">
<div class="contact-form">
<h2 class="title text-center">Contact us </h2>
<div class="status alert alert-success" style="display: none"></div>
<div class="form-group col-md-6">
<asp:TextBox id="name" type="text" name="name" class="form-control" required="required" placeholder="name" runat="server"></asp:TextBox>
</div>
<div class="form-group col-md-6">
<asp:TextBox id="enteremail" type="email" name="enteremail" class="form-control" required="required" placeholder="Email" runat="server"></asp:TextBox>
</div>
<div class="form-group col-md-12">
<asp:TextBox type="text" id="subject" name="subject" class="form-control" required="required" placeholder="subject" runat="server"></asp:TextBox>
</div>
<div class="form-group col-md-12">
<asp:TextBox name="message" id="message" required="required" class="form-control" rows="8" placeholder="conttent" runat="server" TextMode="MultiLine" Height="200px"></asp:TextBox>
</div>
<div class="form-group col-md-12">
<asp:Button ID="BT_submit" runat="server" Text="submit" class="btn btn-primary pull-right" OnClick="BT_submit_Click"/>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
</body>
</html>
my aspx.cs file:
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class test : System.Web.UI.Page
{
public Lienlac Lienlac = new Lienlac();
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
}
}
protected void BT_submit_Click(object sender, EventArgs e)
{
string name = name.Text;
string email = enteremail.Text;
string subject= subject.Text;
string content = message.Text;
Lienlac.Insert_Lienlac(name , email, subject, content );
Response.Redirect("index.aspx");
}
}
i click submit button and no anything new in database