User78096478 posted
I'm trying to create a Search button that fills the text boxes on my webform with data from a SQL database. And I'd like an update button as well so that if any changes were made the records would be updated. Can someone please help? I've
found many resources online but I'm missing something. Right now, basically nothing happens when I try to search or update. I'm very new to asp.net and C#. Many thanks in advance.
asp form:
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
</head>
<body>
<form id="form1" runat="server">
<div class="content">
<h4>none</h4>
<table class="provide-text0">
<tr>
<td class="th-text"><b>Unit Type:</b>
</td>
<td class="auto-style2">
<asp:DropDownList ID="unittype" class="textboxnew" runat="server" OnSelectedIndexChanged="unittype_SelectedIndexChanged" DataSourceID="SqlDataSource1" DataTextField="type" DataValueField="type"></asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sqlServer %>" SelectCommand="SELECT [type] FROM [unit_type]"></asp:SqlDataSource>
<br />
</td>
</tr>
<tr>
<td class="th-text"><b>Status:</b>
</td>
<td class="auto-style2">
<asp:DropDownList ID="status" class="textboxnew" runat="server" OnSelectedIndexChanged="status_SelectedIndexChanged" DataSourceID="SqlDataSource2" DataTextField="status" DataValueField="status"></asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:sqlServer %>" SelectCommand="SELECT [status] FROM [status]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td class="th-text"><b>Serial Number :</b>
</td>
<td class="auto-style2">
<asp:TextBox ID="serialnumber" class="textboxnew" runat="server" OnTextChanged="serialnumber_TextChanged"></asp:TextBox>
<asp:RequiredFieldValidator runat="server" ID="Reqserialnumber" ForeColor="Red" ControlToValidate="serialnumber" ErrorMessage="*" />
</td>
</tr>
</table>
</div>
<div>
<p>
<asp:Button ID="SearchButton" runat="server" class="block" Text="Search" CausesValidation="False" BackColor="#3399FF" OnClick="SearchBtn_Click" />
</p>
<p>
<asp:Button ID="UpdateButton" runat="server" class="block" Text="Update" CausesValidation="False" BackColor="#3399FF" OnClick="UpdateBtn_Click" />
</p>
<p>
<asp:Button ID="BackButton" runat="server" class="block" Text="Back" CausesValidation="False" OnClick="BackBtn_Click" />
</p>
</div>
</form>
</body>
</html>
c#:
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace inventory
{
public partial class Search : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
PopulateFields();
}
}
private void PopulateFields()
{
using (SqlConnection con1 = new SqlConnection("Data Source=USER-PC;Initial Catalog=webservice_database;Integrated Security=True"))
{
DataTable dt = new DataTable();
con1.Open();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from inventory where serialnumber='" + Session["serialnumber"] + "'", con1);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
unittype.Text = (myReader["unittype"].ToString());
status.Text = (myReader["status"].ToString());
serialnumber.Text = (myReader["serialnumber"].ToString());
}
con1.Close();
}//end using
}
protected void unittype_TextChanged(object sender, EventArgs e)
{
}
protected void status_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void unittype_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void serialnumber_TextChanged(object sender, EventArgs e)
{
}
protected void intrinsicallysafecheck_TextChanged(object sender, EventArgs e)
{
}
protected void SubmitBtn_Click(object sender, EventArgs e)
{
}
protected void BackBtn_Click(object sender, EventArgs e)
{
Response.Redirect("start.aspx");
}
protected void UpdateBtn_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=USER-PC;Initial Catalog=webservice_database;Integrated Security=True");
SqlCommand cmd = new SqlCommand("UPDATE inventory SET unittype = @unittype, status = @status, serialnumber = @serialnumber where serialnumber='" + Session["serialnumber"] + "'", con);
con.Open();
cmd.Parameters.AddWithValue("@unittype", unittype.Text);
cmd.Parameters.AddWithValue("@status", status.Text);
cmd.Parameters.AddWithValue("@serialnumber", serialnumber.Text);
cmd.ExecuteNonQuery();
con.Close();
}
protected void SearchBtn_Click(object sender, EventArgs e)
{
}
}
}
