如何在网格视图中创建一个单元格，我可以在其中放置整数值 [英] How to make a cell in a grid view where i can put integer values

问题描述

你好先生's，

请帮帮我..



1.如何在网格视图中制作单元格我可以输入整数值。

2.并将所有网格视图数据保存到数据库表中..



请帮我解决c＃代码&example ..

谢谢你提前...

Hello sir''s,
Please help me..

1. how to make a cell in a grid view where i can put integer values.
2. And save all grid view data into a database table..

Please help me with c# code & example..
Thank you advance...

推荐答案

my code is::
=================
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Datacollection.aspx.cs" Inherits="New_NPS.Datacollection" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <div>
     <script type="text/javascript">
      function isNumberKey(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode > 31 && (charCode < 48 || charCode > 57))
                return false;
            return true;
        }

   </script>




    <h1> put collection amount</h1>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True"

            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Member_ID"

            DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"

            GridLines="None" style="margin-right: 54px" Width="303px">

                <AlternatingRowStyle BackColor="White" />

                <Columns>
                <asp:BoundField DataField="Member_ID" HeaderText="Member_ID" ReadOnly="True"

                        SortExpression="Member_ID" />
                    <asp:BoundField DataField="First_Name" HeaderText="First_Name"

                        SortExpression="First_Name" ReadOnly="True" />
                    <asp:BoundField DataField="Last_Name" HeaderText="Last_Name"

                        SortExpression="Last_Name" ReadOnly="True" />


                    <asp:templatefield headertext="Collection Amount">
                    <itemtemplate>
                    <asp:textbox id="TextBox1" onkeypress="return isNumberKey(event)" type="Text" runat="server"></asp:textbox>
                    </itemtemplate>
                    </asp:templatefield>

                        </Columns>
                <EditRowStyle BackColor="#2461BF" />
                <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#EFF3FB" />
                <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                <SortedAscendingCellStyle BackColor="#F5F7FB" />
                <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                <SortedDescendingCellStyle BackColor="#E9EBEF" />
                <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                ConnectionString="<%

ConnectionStrings：MemberConnectionString ％> < span class =code-attribute>



< span class =code-attribute> < span class =code-attribute> SelectCommand = SELECT [Member_Info]。[Member_ID]，[Member_Info]。[First_Name]，[Member_Info]。[Last_Name] FROM [Member_Info]内部联接[Membermaster]上的[Member_Info]。[Member_ID] = [Membermaster]。 [Member_ID] > < / asp：SqlDataSource >



< asp：按钮 ID = btsave RUNAT < span class =code-keyword> = server onclick = btsave_Click 文字 = 保存 / >



< / div >



< / asp：Content >


========== ==========
使用System;
使用System.Collections.Generic;
使用System.Linq;
使用System.Web;
使用System.Web.UI;
使用System.Web.UI.WebControls;
使用System.Data.SqlClient;

命名空间New_NPS
{
公共部分类Datacollection：System.Web.UI.Page
{
protected void Page_Load（object sender，EventArgs e）
{

}

protected void btsave_Click（object sender，EventArgs e）
{

string Member_ID = string。空的;
// string Frist_Name = string.Empty;
// string Last_Name = string.Empty;
string TextBox1 = string.Empty;



int GVCount = GridView1.Rows.Count;

foreach（GridView1.Rows中的GridViewRow GVRow）
{
Member_ID = GVRow.Cells [0] .Text;
// Frist_Name = GVRow.Cells [1] .Text;
// Last_Name = GVRow.Cells [2] .Text;
TextBox1 = GVRow.Cells [3] .Text;
}

SqlConnection myConnection = new SqlConnection（user id = sa;+
password = prodip @ km; server = PRODIP;+
Trusted_Connection = yes;+
database = Member;）;
myConnection.Open（）;

SqlCommand myCommand = new SqlCommand（INSERT INTO [Collectionamt]（Member_ID，collectionamt，collectiondate）+
Values（@ Member_ID，@ TextBox1，GETDATE（）））;

// int Member_ID = int.Parse（GVRow.Cells [1] .Text）;


myCommand.Parameters.Add（@ Member_ID，System.Data.SqlDbType.Int）.Value = Convert.ToInt32（Member_ID）;
myCommand.Parameters.Add（@ TextBox1，System.Data.SqlDbType.Int）.Value = Convert.ToInt32（TextBox1）;


myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery（）;

Response.Write（< script language =' javascript ' > {alert（' +数据已保存）} < / script > ）;

myConnection.Close（）;

}
}
}


问题：
1.当我保存它然后显示''输入字符串是不正确的格式。''

ConnectionStrings:MemberConnectionString %>" SelectCommand="SELECT [Member_Info].[Member_ID], [Member_Info].[First_Name], [Member_Info].[Last_Name] FROM [Member_Info] inner join [Membermaster] on [Member_Info].[Member_ID]=[Membermaster].[Member_ID]"></asp:SqlDataSource> <asp:Button ID="btsave" runat="server" onclick="btsave_Click" Text="Save" /> </div> </asp:Content> ==================== 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; namespace New_NPS { public partial class Datacollection : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btsave_Click(object sender, EventArgs e) { string Member_ID = string.Empty; //string Frist_Name = string.Empty; //string Last_Name = string.Empty; string TextBox1 = string.Empty; int GVCount = GridView1.Rows.Count; foreach (GridViewRow GVRow in GridView1.Rows) { Member_ID = GVRow.Cells[0].Text; // Frist_Name = GVRow.Cells[1].Text; //Last_Name = GVRow.Cells[2].Text; TextBox1 = GVRow.Cells[3].Text; } SqlConnection myConnection = new SqlConnection("user id=sa;" + "password=prodip@km;server=PRODIP;" + "Trusted_Connection=yes;" + "database=Member;"); myConnection.Open(); SqlCommand myCommand = new SqlCommand("INSERT INTO [Collectionamt ] (Member_ID,collectionamt,collectiondate)" + "Values(@Member_ID,@TextBox1,GETDATE())"); //int Member_ID = int.Parse(GVRow.Cells[1].Text); myCommand.Parameters.Add("@Member_ID", System.Data.SqlDbType.Int).Value = Convert.ToInt32(Member_ID); myCommand.Parameters.Add("@TextBox1", System.Data.SqlDbType.Int).Value = Convert.ToInt32(TextBox1); myCommand.Connection = myConnection; myCommand.ExecuteNonQuery(); Response.Write("<script language='javascript'>{alert('" + "Data is Save')}</script>"); myConnection.Close(); } } } Problem: 1. when i save it then show ''Input string was not in a correct format.''

2.我如何保存datagridview中的所有值???

2. how i save all values in a datagridview???

所以我怎么样从文本框插入数据到数据库???

so how i insert data into database from a text box???

这篇关于如何在网格视图中创建一个单元格，我可以在其中放置整数值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！