update my dynamic grid

Question

0.00/5 (No votes)

See more:

Hi,
How to update my dynamic grid control values when i click the submit button. it should read all the grid control values in the loop and update in the table when i click statement..
pls. see my code below. (ASPX page)
-------------------------------

<asp:GridView ID="GridView1" runat="server" align="center" AllowPaging="True" DataKeyNames
="Priority"
AutoGenerateColumns="False" class="tabulardata" DataSourceID="SqlDataSource1"
HorizontalAlign="Center" Width="100%" OnRowCommand="GridView1_RowCommand"
OnRowDataBound="GridView1_RowDataBound">
<columns>
>
<asp:TemplateField HeaderText="Sl.No" ItemStyle-HorizontalAlign="Center" ItemStyle-Width
="2%">
<itemtemplate>
>
<asp:Label ID="Sno" runat="server">br mode="hold" />
>
</itemtemplate>br mode="hold" />
>
<itemstyle horizontalalign="Center">
/>
br mode="hold" />
>
<asp:BoundField HeaderText="Project Number" Visible="true" DataField="Priority"
ItemStyle-HorizontalAlign="center" ReadOnly="true" SortExpression="Priority">
<itemstyle horizontalalign="Center" mode="hold" />
="3%"/>
br mode="hold" />
>
<asp:BoundField HeaderText="Current Designation" Visible="true" DataField="Designation"
ItemStyle-HorizontalAlign="center" ReadOnly="true" SortExpression
="Designation">
<itemstyle horizontalalign="Center" mode="hold" />
="25%"/>
br mode="hold" />
>
<asp:TemplateField HeaderText="Professional Role">
<itemtemplate>
>
<asp:DropDownList runat="server" ID="ddlProfRole" width="87%" DataValueField="ProfRoleCode" DataSourceID="SqlDataSource2" DataTextField="ProfRoleDescription">
<asp:ListItem Text="Select" Value="-1">br mode="hold" />
>
</itemtemplate>br mode="hold" />
>
<itemstyle horizontalalign="Center" mode="hold" />
="25%"/>
br mode="hold" />
>
</itemstyle></columns>br mode="hold" />
>
<alternatingrowstyle backcolor="#FFF5F5">
/>
br mode="hold" />
></alternatingrowstyle>

ASPX.VB Code
----------------

VB

Protected Sub ImgbtnSave_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles
ImgbtnSave.Click
'update weeklyload table Values for the PojectNumber
Conn.Open()
StrQry =""
StrQry ="update mppProfRoleMapping set DesignCode='" & & "' where ProfRoleCode ='" & & "'"

Cmd.Connection = Conn
Cmd.CommandText = StrQry
Cmd.ExecuteNonQuery()
Cmd.Dispose()
Conn.Close()
End Sub

please. help

Regards,
Ganesh.S

Posted 4-Jul-11 3:42am

gani7787

Updated 4-Jul-11 6:59am

thatraja

v2

Add a Solution

Comments

thatraja 4-Jul-11 13:01pm

Your code's format was terrible, But hope I have fixed at least better than previous one.
Please always format the code which is easy to read.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

srs84 · Answer 1 · 2011-07-06T22:30:00

Hi, u can use the following code....

VB

Protected Sub ImgbtnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles ImgbtnSave.Click
      'update weeklyload table Values for the PojectNumber
      Conn.Open()
      StrQry = ""
      For i As Integer = 0 To GridView1.Rows.Count - 1
          StrQry = "update mppProfRoleMapping set DesignCode='" & CType(GridView1.Rows(i).FindControl("Sno"), Label).Text & "' where ProfRoleCode ='" & CType(GridView1.Rows(i).FindControl("ddlProfRole"), DropDownList).SelectedValue & "'"
      Next

      Cmd.Connection = Conn
      Cmd.CommandText = StrQry
      Cmd.ExecuteNonQuery()
      Cmd.Dispose()
      Conn.Close()
  End Sub