如何制作可编辑的gridview [英] How to make editable gridview

查看：68
本文介绍了如何制作可编辑的gridview的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个Gridview，我只是通过拖动Visual Stdio中的SQL数据表生成的。我想让所有字段都可编辑，即我可以更改任何字段并更新它们而不使用额外的编辑链接字段。

I have a Gridview which I generated only by dragging a SQL data table in Visual Stdio. I want to make all the field editable, that is I can change any field and update them without using extra edit linked field.

<asp:GridView CssClass="mGrid" ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
            <Columns>
                <asp:BoundField DataField="session" HeaderText="Session" SortExpression="session" />
                <asp:BoundField DataField="dept" HeaderText="Department" SortExpression="dept" />
                <asp:BoundField DataField="subject" HeaderText="Subject" SortExpression="subject" />
                <asp:BoundField DataField="courseCode" HeaderText="Course Code" SortExpression="courseCode" />
                <asp:BoundField DataField="quizNum" HeaderText="Quiz" SortExpression="quizNum" />
                <asp:BoundField DataField="stdId" HeaderText="Stduent Id" SortExpression="stdId" />
                <asp:BoundField DataField="marks" HeaderText="Total marks" SortExpression="marks" />
                <asp:BoundField DataField="gainMark" HeaderText="Gain Marks" SortExpression="gainMark" />
            </Columns>
        </asp:GridView>



对应的数据源代码是


corresponding data source code is 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BBAConnectionString1 %>" 

            DeleteCommand="DELETE FROM [writtenExamResult] WHERE [Id] = @Id" 

            InsertCommand="INSERT INTO [writtenExamResult] ([tchId], [stdId], [session], [dept], [subject], [courseCode], [quizNum], [examDate], [questionNum], [question], [answer], [marks], [gainMark]) VALUES (@tchId, @stdId, @session, @dept, @subject, @courseCode, @quizNum, @examDate, @questionNum, @question, @answer, @marks, @gainMark)" 

            ProviderName="<%$ ConnectionStrings:BBAConnectionString1.ProviderName %>" 

            SelectCommand="SELECT * FROM [writtenExamResult] where [tchId] = @getTchId and [questionNum] = '0' ORDER BY examDate, session, stdId ASC" 

            UpdateCommand="UPDATE [writtenExamResult] SET [tchId] = @tchId, [stdId] = @stdId, [session] = @session, [dept] = @dept, [subject] = @subject, [courseCode] = @courseCode, [quizNum] = @quizNum, [examDate] = @examDate, [questionNum] = @questionNum, [question] = @question, [answer] = @answer, [marks] = @marks, [gainMark] = @gainMark WHERE [Id] = @Id">
            <SelectParameters>
                <asp:SessionParameter Name="getTchId" SessionField="getTchId" Type="String" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="Id" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="tchId" Type="String" />
                <asp:Parameter Name="stdId" Type="String" />
                <asp:Parameter Name="session" Type="String" />
                <asp:Parameter Name="dept" Type="String" />
                <asp:Parameter Name="subject" Type="String" />
                <asp:Parameter Name="courseCode" Type="String" />
                <asp:Parameter Name="quizNum" Type="String" />
                <asp:Parameter Name="examDate" Type="String" />
                <asp:Parameter Name="questionNum" Type="Int32" />
                <asp:Parameter Name="question" Type="String" />
                <asp:Parameter Name="answer" Type="String" />
                <asp:Parameter Name="marks" Type="Decimal" />
                <asp:Parameter Name="gainMark" Type="Decimal" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="tchId" Type="String" />
                <asp:Parameter Name="stdId" Type="String" />
                <asp:Parameter Name="session" Type="String" />
                <asp:Parameter Name="dept" Type="String" />
                <asp:Parameter Name="subject" Type="String" />
                <asp:Parameter Name="courseCode" Type="String" />
                <asp:Parameter Name="quizNum" Type="String" />
                <asp:Parameter Name="examDate" Type="String" />
                <asp:Parameter Name="questionNum" Type="Int32" />
                <asp:Parameter Name="question" Type="String" />
                <asp:Parameter Name="answer" Type="String" />
                <asp:Parameter Name="marks" Type="Decimal" />
                <asp:Parameter Name="gainMark" Type="Decimal" />
                <asp:Parameter Name="Id" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>

推荐答案

ConnectionStrings：BBAConnectionString1％>

DeleteCommand = DELETE FROM [writtenExamResult] WHERE [Id] = @Id

InsertCommand=\"INSERT INTO [writtenExamResult] ([tchId], [stdId], [session], [dept], [subject], [courseCode], [quizNum], [examDate], [questionNum], [question], [answer], [marks], [gainMark]) VALUES (@tchId, @stdId, @session, @dept, @subject, @courseCode, @quizNum, @examDate, @questionNum, @question, @answer, @marks, @gainMark)\"

ProviderName=\"<%
ConnectionStrings:BBAConnectionString1 %>" DeleteCommand="DELETE FROM [writtenExamResult] WHERE [Id] = @Id" InsertCommand="INSERT INTO [writtenExamResult] ([tchId], [stdId], [session], [dept], [subject], [courseCode], [quizNum], [examDate], [questionNum], [question], [answer], [marks], [gainMark]) VALUES (@tchId, @stdId, @session, @dept, @subject, @courseCode, @quizNum, @examDate, @questionNum, @question, @answer, @marks, @gainMark)" ProviderName="<%


ConnectionStrings:BBAConnectionString1.ProviderName %>\"

SelectCommand=\"SELECT * FROM [writtenExamResult] where [tchId] = @getTchId and [questionNum] = '0' ORDER BY examDate, session, stdId ASC\"

UpdateCommand=\"UPDATE [writtenExamResult] SET [tchId] = @tchId, [stdId] = @stdId, [session] = @session, [dept] = @dept, [subject] = @subject, [courseCode] = @courseCode, [quizNum] = @quizNum, [examDate] = @examDate, [questionNum] = @questionNum, [question] = @question, [answer] = @answer, [marks] = @marks, [gainMark] = @gainMark WHERE [Id] = @Id\">
<SelectParameters>
<asp:SessionParameter Name=\"getTchId\" SessionField=\"getTchId\" Type=\"String\" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name=\"Id\" Type=\"Int32\" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name=\"tchId\" Type=\"String\" />
<asp:Parameter Name=\"stdId\" Type=\"String\" />
<asp:Parameter Name=\"session\" Type=\"String\" />
<asp:Parameter Name=\"dept\" Type=\"String\" />
<asp:Parameter Name=\"subject\" Type=\"String\" />
<asp:Parameter Name=\"courseCode\" Type=\"String\" />
<asp:Parameter Name=\"quizNum\" Type=\"String\" />
<asp:Parameter Name=\"examDate\" Type=\"String\" />
<asp:Parameter Name=\"questionNum\" Type=\"Int32\" />
<a sp:Parameter Name=\"question\" Type=\"String\" />
<asp:Parameter Name=\"answer\" Type=\"String\" />
<asp:Parameter Name=\"marks\" Type=\"Decimal\" />
<asp:Parameter Name=\"gainMark\" Type=\"Decimal\" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name=\"tchId\" Type=\"String\" />
<asp:Parameter Name=\"stdId\" Type=\"String\" />
<asp:Parameter Name=\"session\" Type=\"String\" />
<asp:Parameter Name=\"dept\" Type=\"String\" />
<asp:Parameter Name=\"subject\" Type=\"String\" />
<asp:Parameter Name=\"courseCode\" Type=\"String\" />
<asp:Parameter Name=\"quizNum\" Type=\"String\" />
<asp:Parameter Name=\"examDate\" Type=\"String\" />
<asp:Parameter Name=\"questionNum\" Type=\"Int32\" />
<asp:Parameter Name=\"question\" Type=\"String\" />
<asp:Parameter Name=\"answer\" Type=\"String\" />
<asp:Parameter Name=\"marks\" Type=\"Decimal\" />
<asp:Parameter Name=\"gainMark\" Type=\"Decimal\" />
<asp:Parameter Name=\"Id\" Type=\"Int32\" />
</UpdateParameters>
</asp:SqlDataSource>
ConnectionStrings:BBAConnectionString1.ProviderName %>" SelectCommand="SELECT * FROM [writtenExamResult] where [tchId] = @getTchId and [questionNum] = '0' ORDER BY examDate, session, stdId ASC" UpdateCommand="UPDATE [writtenExamResult] SET [tchId] = @tchId, [stdId] = @stdId, [session] = @session, [dept] = @dept, [subject] = @subject, [courseCode] = @courseCode, [quizNum] = @quizNum, [examDate] = @examDate, [questionNum] = @questionNum, [question] = @question, [answer] = @answer, [marks] = @marks, [gainMark] = @gainMark WHERE [Id] = @Id"> <SelectParameters> <asp:SessionParameter Name="getTchId" SessionField="getTchId" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="Id" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="tchId" Type="String" /> <asp:Parameter Name="stdId" Type="String" /> <asp:Parameter Name="session" Type="String" /> <asp:Parameter Name="dept" Type="String" /> <asp:Parameter Name="subject" Type="String" /> <asp:Parameter Name="courseCode" Type="String" /> <asp:Parameter Name="quizNum" Type="String" /> <asp:Parameter Name="examDate" Type="String" /> <asp:Parameter Name="questionNum" Type="Int32" /> <asp:Parameter Name="question" Type="String" /> <asp:Parameter Name="answer" Type="String" /> <asp:Parameter Name="marks" Type="Decimal" /> <asp:Parameter Name="gainMark" Type="Decimal" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="tchId" Type="String" /> <asp:Parameter Name="stdId" Type="String" /> <asp:Parameter Name="session" Type="String" /> <asp:Parameter Name="dept" Type="String" /> <asp:Parameter Name="subject" Type="String" /> <asp:Parameter Name="courseCode" Type="String" /> <asp:Parameter Name="quizNum" Type="String" /> <asp:Parameter Name="examDate" Type="String" /> <asp:Parameter Name="questionNum" Type="Int32" /> <asp:Parameter Name="question" Type="String" /> <asp:Parameter Name="answer" Type="String" /> <asp:Parameter Name="marks" Type="Decimal" /> <asp:Parameter Name="gainMark" Type="Decimal" /> <asp:Parameter Name="Id" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource>


visit here...

Full-featured Editable GridView Control[^]



or



How to create Editable Gridview in ASP.net[^]
visit here...
Full-featured Editable GridView Control[^]

or

How to create Editable Gridview in ASP.net[^]


这篇关于如何制作可编辑的gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆