fakhravari
یک شنبه 11 دی 1390, 12:49 عصر
با سلام
دوستان اینم کدش
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1" ShowHeader="False">
<Columns>
<asp:TemplateField>
<ItemTemplate>
Name : <asp:Label ID="Label2" runat="server" Text='<%# Eval("name") %>'></asp:Label><br />
<asp:TextBox runat="server" ID="TextBox1" Text='<%# Eval("nu") %>'></asp:TextBox><br />
ID : <asp:Label ID="Label3" runat="server" Text='<%# Eval("id") %>'></asp:Label><br />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected string SqlEdit = "update Table1 set nu=@nu where id=@id";
public string lasteror;
public void Edit(int nu, int id)
{
try
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrin gs["DatabaseConnectionString1"].ConnectionString);
con1.Open();
SqlCommand cmd1 = new SqlCommand(SqlEdit, con1);
cmd1.CommandType = CommandType.Text;
cmd1.Parameters.Add("@nu", SqlDbType.Int).Value = nu;
cmd1.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd1.ExecuteNonQuery();
con1.Close();
this.lasteror = "اطلاعات ثبت شد";
}
catch
{
this.lasteror = "اشکال در ثبت اطلاعات";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
TextBox textnum = row.FindControl("TextBox1") as TextBox;
Label txtid = row.FindControl("Label3") as Label;
if (textnum != null || txtid != null )
{
int valuenu = Int32.Parse(textnum.Text);
int valueid = Int32.Parse(txtid.Text);
Edit(valuenu, valueid);
}
}
}