这是关键字“添加”附近的错误“语法错误”请帮我解决一下 [英] this is the error "Incorrect syntax near the keyword 'Add" please help me to solve it

问题描述

 使用系统; 
 使用 System.Collections.Generic; 
 使用 System.Linq; 
 使用 System.Web; 
 使用 System.Web.UI; 
 使用 System.Web.UI.WebControls; 
 使用 System.Data.SqlClient; 
 使用 System.Data; 
 
 命名空间 ASSIGNMENT_WORK.Forms 
 {
  public   partial   class  addnumber：System.Web.UI.Page 
 {
  protected   void  Page_Load（ object  sender，EventArgs e） 
 {
 
} 
 
  protected   void  btnResult_Click（ object  sender，EventArgs e）
 {
  int  firstNumber， secondNumber，结果; 
 firstNumber = Convert.ToInt32（txtFirstno.Text.Trim（））; 
 secondNumber = Convert.ToInt32（txtSecondno.Text.Trim（））; 
 result = firstNumber + secondNumber; 
 txtresult.Text = Convert.ToString（result）; 
 SqlConnection cnn =  new  SqlConnection（System.Configuration.ConfigurationManager.ConnectionStrings [  myConnectionString]的ConnectionString）。 
 cnn.Open（）; 
 SqlCommand cmd =  new  SqlCommand（）; 
 cmd.CommandText =   select * from Add; 
 cmd.Connection = cnn; 
 SqlDataAdapter da =  new  SqlDataAdapter（）; 
 da.SelectCommand = cmd; 
 DataSet ds =  new  DataSet（）; 
 da.Fill（ds， 添加）; 
 SqlCommandBuilder cb =  new  SqlCommandBuilder（da）; 
 DataRow drow = ds.Tables [  Add]。NewRow（）; 
 drow [  result] = txtresult.Text; 
 ds.Tables [ 添加]。Rows.Add（drow）; 
 da.Update（ds，  Add）; 
  string  script =  @ < script language =javascript> 
 alert（'信息已成功保存....... !!!!!。'）; 
< / script> ;;; 
 Page.ClientScript.RegisterStartupScript（ this  .GetType（），  myJScript1，脚本）; 
 
} 
} 
} 

解决方案

使用选择命令文本，如下所示



cmd.CommandText =select * from [Add];

删除Add之前和之后的间距。



ds.Tables [添加]。行。添加（卓尔）;

da.Fill（ds，添加 ）;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace ASSIGNMENT_WORK.Forms
{
    public partial class addnumber : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnResult_Click(object sender, EventArgs e)
        {
            int firstNumber, secondNumber, result;
            firstNumber = Convert.ToInt32(txtFirstno.Text.Trim());
            secondNumber = Convert.ToInt32(txtSecondno.Text.Trim());
            result = firstNumber + secondNumber;
            txtresult.Text = Convert.ToString(result);
            SqlConnection cnn=new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
        cnn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select * from  Add";
        cmd.Connection = cnn;
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        da.Fill(ds, " Add ");
        SqlCommandBuilder cb = new SqlCommandBuilder(da);
        DataRow drow = ds.Tables["Add"].NewRow();
        drow["result"] = txtresult.Text;
        ds.Tables["Add "].Rows.Add(drow);
        da.Update(ds, " Add ");
        string script = @"<script language=""javascript"">
        alert('Information have been Saved Successfully.......!!!!!.');
       </script>;";
        Page.ClientScript.RegisterStartupScript(this.GetType(), "myJScript1", script);

        }
    }
}

解决方案

use select command text as like below

cmd.CommandText = "select * from [Add]";

Remove spaced before and after "Add" like this.

ds.Tables["Add"].Rows.Add(drow);
da.Fill(ds, "Add");

这篇关于这是关键字“添加”附近的错误“语法错误”请帮我解决一下的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！