mvc example asp.net button gridview boundfield rowcommand

asp.net - example - obtener valor de cadena o almacenar en la base de datos?



checkbox in mvc 4 razor example (0)

esta es mi página viewcreditrequest html:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CssClass="table table-hover table-striped" OnRowCommand="GridView1_RowCommand" onselectedindexchanged="GridView1_SelectedIndexChanged"> <Columns> <asp:BoundField DataField="Username" HeaderText="Username" SortExpression="Username" /> <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" /> <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" /> <asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" /> <asp:BoundField DataField="EmailAddress" HeaderText="EmailAddress" SortExpression="EmailAddress" /> <asp:BoundField DataField="CompanyAddress" HeaderText="CompanyAddress" SortExpression="CompanyAddress" /> <asp:BoundField DataField="IncomeRange" HeaderText="IncomeRange" SortExpression="IncomeRange" /> <asp:BoundField DataField="CreditRequest" HeaderText="CreditRequest" SortExpression="CreditRequest" /> <asp:BoundField DataField="ContactNumber" HeaderText="ContactNumber" SortExpression="ContactNumber" /> <asp:TemplateField> <ItemTemplate> <asp:Button ID="Button1" runat="server" Text="Approve" CommandName="Approve" CommandArgument=''<%# Eval("CreditRequest") %>'' /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>

y código detrás:

protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["IslandGasAdminFM"] != null) { bindgrid(); Label1.Text = "- Finance Manager"; } else { Response.Write("<script>alert(''Finance Manager credentials needed''); window.location.href=''LogIn.aspx'';</script>"); } } } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { System.Diagnostics.Debugger.Break(); if (e.CommandName == "Approve") { string creditRequest = e.CommandArgument as string; } } public void bindgrid() { SqlConnection conn = new SqlConnection("Data Source = ''PAULO''; Initial Catalog=ShoppingCartDB;Integrated Security =True"); SqlCommand cmd = new SqlCommand("select * from CreditRequests ", conn); SqlDataAdapter da = new SqlDataAdapter("", conn); da.SelectCommand = new SqlCommand("select * from CreditRequests", conn); DataSet ds = new DataSet(); da.Fill(ds, "data"); GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataBind(); }

Lo que quiero que suceda aquí es obtener el valor de "solicitud de crédito" en el límite. El bindgrid () funciona bien, también he agregado

EnableViewState="false"

a mi vista de cuadrícula Cuando hago clic en el botón, ahora asigna el valor de la solicitud de crédito a la solicitud de crédito de cadena. alguna idea sobre cómo puedo hacerlo visible o incluso almacenarlo en la base de datos?