如何使用Asp.Net（C＃）将数据插入数据库 [英] How do Insert data to database using Asp.Net(C#)

问题描述

我在按钮上申请的以下代码

the below code i have applied on button

protected void Submit_Button_Click(object sender, EventArgs e)
       {
           string connString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
           SqlConnection con = null;
           try
           {
               con = new SqlConnection(connString);
               using (SqlCommand cmd = new SqlCommand())
               {
                   cmd.Connection = con;
                   cmd.CommandType = CommandType.Text;
                   cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId,EmployeeId,Date,NoOfPage,Deadline,IsDeleted,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy)values(@ProjectId,@EmployeeId,@Date,@NoOfPages,@Date,@Deadline,@IsActive,@CreatedOn,@CreatedBy,@UpdatedOn,@UpdatedBy)";
                   cmd.Parameters.AddWithValue("@ProjectId", ProjectId_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId_TB.Text.Trim());
                    cmd.Parameters.AddWithValue("@Date", Date_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@NoOfPage", NoOfPages_TB.Text.Trim());

                   cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());

                   cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedOn", UpdatedOn_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedBy", UpdatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@IsDeleted", IsDeleted_TB.Text.Trim());
                   int rowsAffected = cmd.ExecuteNonQuery();
                   if (rowsAffected == 1)
                   {
                       Label1.Text = "registered successful.";
                   }
                   else
                   {
                       //Error notification
                   }

               }
           }
           catch (Exception ex)
           {
               //log error
               //display friendly error to user
           }
           finally
           {
               if (con != null)
               {
                   //cleanup connection i.e close
               }
           }
       }

这是我的连接字符串

and this is my Connection string

<connectionStrings>
        <add name="conString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Amplits\CelebralProspectus\AssignProject\AssignProject\App_Data\celebral.mdf;Integrated Security=True;User Instance=True"/></connectionStrings>

推荐答案

在Sql Server Studio中运行相同的查询并检查是否插入了记录。

这应该可以让您知道这是否是您的查询错误。

Run the same query in Sql Server Studio and check if a record inserts or not.
That should give you an idea if this is an error with your query.

正确检查你的参数

@IsActive，@ IsDeleted

check your parameters correctly
@IsActive , @IsDeleted

cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId,EmployeeId,Date,NoOfPage,Deadline,IsDeleted,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy)values(@ProjectId,@EmployeeId,@Date,@NoOfPages,@Date,@Deadline,@IsActive,@CreatedOn,@CreatedBy,@UpdatedOn,@UpdatedBy)";
                   
Checkout here above You have taken @IsActive instead of @IsDeleted

cmd.Parameters.AddWithValue("@ProjectId", ProjectId_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId_TB.Text.Trim());
                    cmd.Parameters.AddWithValue("@Date", Date_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@NoOfPage", NoOfPages_TB.Text.Trim());
 
                   cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());
 
                   cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedOn", UpdatedOn_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedBy", UpdatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@IsDeleted", IsDeleted_TB.Text.Trim());

Hai

您是否使用断点检查了您的代码？如果你点击Submit_Button它会触发Submit_Button_Click事件，我的意思是断点进入Submit_Button_click？尝试将您的按钮名称更改为提交，不要为您的按钮名称添加下划线。

Hai
Did u check ur code with break point ? if u click Submit_Button it fire Submit_Button_Click event,i mean break point goes inside of Submit_Button_click ? try to change ur button name as Submit,don't give underscore for ur button name.

这篇关于如何使用Asp.Net（C＃）将数据插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！