字符串DATA出现问题 [英] Problem with string DATA
本文介绍了字符串DATA出现问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
protected void Button1_Click(object sender, EventArgs e)
{
string dbString = ConfigurationManager.ConnectionStrings["CallingetcConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sqlConn = new System.Data.SqlClient.SqlConnection(dbString);
if (sqlConn.State.ToString() == "Open")
{
foreach (ListItem li in CheckBoxList1.Items)
{
if (li.Selected)
{
dbString += li.Value + ", ";
sqlConn.Open();
string sql = " INSERT INTO [Tableone] ([CoverDesired]) VALUES ($dbString[$li])";
SqlCommand cmd = new SqlCommand(sql, sqlConn);
cmd.ExecuteNonQuery();
sqlConn.Close();
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Insert_and_retrieve._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:CheckBoxList ID="CheckBoxList1" runat="server"
DataSourceID="SqlDataSource1" DataTextField="CoverDesired"
DataValueField="CoverDesired" Height="19px" RepeatDirection="Horizontal"
Width="779px">
<asp:ListItem Text="Package" Value="Package">Package
<asp:ListItem Text="Fire and/or Theft Only with Liability" Value="Fire and/or Theft only with Liability">Fire and/or Theft only With Liability
<asp:ListItem Text="Fire Only" Value="Fire Only">Fire Only
<asp:ListItem Text="Theft Only" Value="Theft Only">Theft Only
<asp:ListItem Text="Liability Only" Value="Liability Only">Liability Only
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CallingetcConnectionString %>"
InsertCommand="INSERT INTO Tableone(CoverDesired) VALUES (Package,Fire and/or theft only with Liability,Fire Only,Theft Only,Liability Only)">
<insertparameters>
<asp:ControlParameter Name="CoverDesired" Type="String" PropertyName="Text" />
</insertparameters>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource2"
RepeatColumns="1" Width="170px">
<itemtemplate>
CoverDesired:
<asp:Label ID="CoverDesiredLabel" runat="server"
Text='<%# Eval("CoverDesired") %>' />
<br />
<br />
</itemtemplate>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:CallingetcConnectionString2 %>"
SelectCommand="SELECT * FROM [Tableone]">
</form>
</body>
</html>
推荐答案
dbString
li])"; SqlCommand cmd = 新 SqlCommand(sql,sqlConn); cmd.ExecuteNonQuery(); sqlConn.Close(); } } }
li])"; SqlCommand cmd = new SqlCommand(sql, sqlConn); cmd.ExecuteNonQuery(); sqlConn.Close(); } } }
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Insert_and_retrieve._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:CheckBoxList ID="CheckBoxList1" runat="server"
DataSourceID="SqlDataSource1" DataTextField="CoverDesired"
DataValueField="CoverDesired" Height="19px" RepeatDirection="Horizontal"
Width="779px">
<asp:ListItem Text="Package" Value="Package">Package
<asp:ListItem Text="Fire and/or Theft Only with Liability" Value="Fire and/or Theft only with Liability">Fire and/or Theft only With Liability
<asp:ListItem Text="Fire Only" Value="Fire Only">Fire Only
<asp:ListItem Text="Theft Only" Value="Theft Only">Theft Only
<asp:ListItem Text="Liability Only" Value="Liability Only">Liability Only
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%
ConnectionStrings:CallingetcConnectionString %> ; " InsertCommand =" 插入Tableone(覆盖所需)值(仅包装,火灾和/或盗窃,并附带责任,仅火灾,仅盗窃,仅责任)" < 插入参数 > < asp:ControlParameter 名称 =" 类型 字符串" PropertyName 文本" / < /insertparameters > < asp:Button ID =" runat 服务器" onclick Button1_Click" 文本 按钮" / > < asp:DataList ID =" runat 服务器" DataSourceID SqlDataSource2" span> RepeatColumns =" 1" 宽度 170像素" < itemtemplate > 所需的封面: < asp:Label ID =" runat 服务器" span> 文本 " CoverDesired") > < br > < br > < /itemtemplate > < asp:SqlDataSource ID =" runat 服务器" span> ConnectionString =" <%
ConnectionStrings:CallingetcConnectionString %>" InsertCommand="INSERT INTO Tableone(CoverDesired) VALUES (Package,Fire and/or theft only with Liability,Fire Only,Theft Only,Liability Only)"> <insertparameters> <asp:ControlParameter Name="CoverDesired" Type="String" PropertyName="Text" /> </insertparameters> <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" /> <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource2" RepeatColumns="1" Width="170px"> <itemtemplate> CoverDesired: <asp:Label ID="CoverDesiredLabel" runat="server" Text='<%# Eval("CoverDesired") %>' /> <br /> <br /> </itemtemplate> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%
这篇关于字符串DATA出现问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文