maxpayn2
دوشنبه 12 بهمن 1388, 13:18 عصر
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" OnRowCommand="GridView1_RowCommand"
DataSourceID="SqlDataSource1" Width="400px"
onselectedindexchanged="GridView1_SelectedIndexChanged">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btndelete" runat="server" Text="حذف" CommandArgument='<%#Eval("user_id")%>' CommandName="Delete" CausesValidation="false" />
</ItemTemplate>
<ItemStyle Font-Names="Tahoma" Width="50" HorizontalAlign="Center" />
<HeaderStyle Font-Names="Tahoma" Width="50" HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btnselect" runat="server" Text="انتخاب" CommandArgument='<%#Eval("user_id")%>' CommandName="Select" CausesValidation="false" />
</ItemTemplate>
<ItemStyle Font-Names="Tahoma" Width="50" HorizontalAlign="Center" />
<HeaderStyle Font-Names="Tahoma" Width="50" HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="نام کاربر">
<ItemTemplate>
<%#Eval("user_name")%>
</ItemTemplate>
<ItemStyle Font-Names="Tahoma" />
<HeaderStyle Font-Names="Tahoma" />
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
<asp:Label ID="Label4" runat="server" Text="در حال حاضر کاربری برای ویرایش موجود نیست"></asp:Label>
</EmptyDataTemplate>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:tconetConnectionString %>"
DeleteCommand="delete_user"
DeleteCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
</asp:SqlDataSource>
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (role == true)
{
Session["id"] = Convert.ToInt32(e.CommandArgument.ToString());
}
if (e.CommandName == "Delete")
{
Session["command"] = "delete";
}
if (e.CommandName == "Select")
{
Session["command"] = "select";
}
if (Session["command"].ToString() == "delete")
{
if (role == true)
{
SqlConnection cnn2 = new SqlConnection();
try
{
cnn2.ConnectionString = "Data Source=.;Database=mydb;Integrated Security=SSPI";
cnn2.Open();
SqlCommand cmd2 = new SqlCommand("delete_user", cnn2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@id", Convert.ToInt32(Session["id"].ToString()));
cmd2.ExecuteNonQuery();
cnn2.Close();
GridView1.DataBind();
}
catch (Exception ex)
{
Server.Transfer("~/ExceptionReport.aspx?id=" + ex.Message.ToString() + "&urle=" + Request.Url.ToString());
}
finally
{
cnn2.Close();
}
}
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
if (Session["command"].ToString() == "select")
{
if (role == true)
{
SqlConnection cnn1 = new SqlConnection();
try
{
try
{
cnn1.ConnectionString = "Data Source=.;Database=mydb;Integrated Security=SSPI";
cnn1.Open();
SqlCommand cmd1 = new SqlCommand("select_users", cnn1);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@id", Convert.ToInt32(Session["id"].ToString()));
SqlDataReader dr1 = cmd1.ExecuteReader();
userNameTextBox.Text = "";
passwordTextBox.Text = "";
passwordConfTextBox.Text = "";
if (dr1.Read())
{
userNameTextBox.Text = dr1[1].ToString();
departmentDropDownList.SelectedValue = dr1[3].ToString();
roleDropDownList.SelectedValue = dr1[4].ToString();
}
cnn1.Close();
}
finally
{
cnn1.Close();
}
}
catch (Exception ex)
{
Server.Transfer("~/ExceptionReport.aspx?id=" + ex.Message.ToString() + "&urle=" + Request.Url.ToString());
}
finally
{
cnn1.Close();
}
}
}
}
این کد رو 2 سال پیش نوشتم ، شاید مبتدی به نظر برسه