字符串DATA出现问题 [英] Problem with string DATA

查看：49 发布时间：2019/6/20 10:29:54 C# ASP.NET

本文介绍了字符串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屋！

查看全文

字符串DATA出现问题 [英] Problem with string DATA

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

字符串DATA出现问题 [英] Problem with string DATA

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭