初学c#向sql 添加数据 怎么都不成功 望高人指点
<%@ Import Namespace= "System.Data " %>
<%@ Import Namespace= "System.Data.SqlClient " %>
<html>
<head id= "Head1 " runat= "server ">
<title> 无标题页 </title>
</head>
<script language= "c# " runat= "server ">
SqlConnection objConnection = new SqlConnection( "database=gewei;server=(local);Connect Timeout=30;User=sa;pwd=123456 ");
public void Page_Load(Object sender, EventArgs e)
{
if (!IsPostBack)
{
binggrid();
}
}
void binggrid()
{
DataSet ds = new DataSet();
string strcomm = "SELECT *FROM score ";
string strConnection = "database=gewei;server=(local);Connect Timeout=30;User=sa;pwd=123456 ";
using (SqlConnection objConnection = new SqlConnection(strConnection))
{
SqlDataAdapter adap = new SqlDataAdapter(strcomm, objConnection);
adap.Fill(ds, "score ");
}
dg.DataSource = ds.Tables[ "score "].DefaultView;
dg.DataBind();
}
void addscore(object sender, EventArgs e)
{
DataSet ds;
string insercmd = "insert into score(名称,站址,确认,类别,说明) values( ' ";
insercmd += s_name.Value + " ', ' ";
insercmd += s_url.Value + " ', ";
insercmd += s_queren.Value + ", ' ";
insercmd += s_leibie.Value + " ', ' ";
insercmd += s_shuoming.Value + " ' ";
objConnection.Open();
SqlCommand adap = new SqlCommand(insercmd, objConnection);
/*adap.ExecuteNonQuery();*/
objConnection.Close();
message.InnerHtml = "数据添加成功 ";
/* try
{
}
catch (System.Data.DataException myexception)
{
Response.Write(myexception.Message);
}
adap.Parameters.Add( "@name ", SqlDbType.Char, 10);
adap.Parameters[ "@name "].Value = s_name.Value;
adap.Parameters.Add( "@url ", SqlDbType.Char, 20);
adap.Parameters[ "@url "].Value = s_url.Value;
adap.Parameters.Add( "@queren ", SqlDbType.Bit, 1);
adap.Parameters[ "@queren "].Value = s_queren.Value;
adap.Parameters.Add( "@leibie ", SqlDbType.Char, 10);
adap.Parameters[ "@leibie "].Value = s_leibie.Value;
adap.Parameters.Add( "@shuoming ", SqlDbType.Char, 10);
adap.Parameters[ "@shuoming "].Value = s_shuoming.Value;
adap.Connection.Open();*/
binggrid();
}
</script>
<body>
<form id= "form1 " runat= "server ">
<table>
<tr>
<td valign= "middle ">
<asp:DataGrid ID= "dg " runat= "server " Width= "100% " BackColor= "Ivory " Font-Size= "9pt "
HeaderStyle-BackColor= "lightblue " BorderWidth= "1px " BorderColor= "#000000 " BorderStyle= "None "
CaptionAlign= "Top " CellPadding= "0 " EnableTheming= "True ">
</asp:DataGrid>
</td>
<br />
<br />
<br />
</tr>
<tr>
<td valign= "middle ">
<table style= "font: 9pt 宋体 ">
<tr>
<td>
名称: <input type= "text " id= "s_name " runat= "server " size= "6 " />
</td>
</tr>
<tr>
<td>
网址: <input type= "text " id= "s_url " runat= "server " size= "6 " />
</td>
</tr>
<tr>
<td>
确认: <input type= "text " id= "s_queren " runat= "server " size= "6 " />
</td>
</tr>
<tr>
<td>
类别: <input type= "text " id= "s_leibie " runat= "server " size= "6 " />
</td>
</tr>
<tr>
<td>
说明: <input type= "text " id= "s_shuoming " runat= "server " size= "6 " />
</td>
</tr>
<tr>
<td>
<input id= "Submit1 " type= "submit " name= "submit " value= "添加 " onserverclick= "addscore "
runat= "server " />
</td>
</tr>
<tr>
<td>
<span id= "message " runat= "server "> </span>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
[解决办法]
SqlCommand adap = new SqlCommand(insercmd, objConnection);
这个 adap 都不 ExecuteNonQuery
也就是没有执行
怎么会有数据写进去
LZ 仔细看看 MSDN 里 SqlCommand 的用法
[解决办法]
晕，竟然没抱错！！
当adap 执行ExecuteNonQuery()的时候 老是报错 说什么
异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: ', ' 附近有语法错误。
是应为你的插入sql语句有错；换上我写的看看吧~