Comments by Member 14534831 (Top 6 by date)

I was tried but failed to get data.

I am facing problem in another program will you give solution -

[Web Design]


Enter Student Name <asp:textbox id="txtName" runat="server"> Enter Student Number <asp:textbox id="txtNumber" runat="server"> Enter Student Percentage <asp:textbox id="txtPercentage" runat="server"> <asp:button id="btnSave" runat="server" text="Save" onclick="btnSave_Click">
<asp:dropdownlist id="ddlSNum" runat="server" autopostback="true" onselectedindexchanged="ddlSNum_SelectedIndexChanged">
<asp:listitem>---Select SNum ---

<asp:gridview id="gvTest" runat="server">

-----

[Source Code]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace Test
{
public partial class SystemTest1 : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(GetDBConnectionString());
cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = "Select S_Number from S_Test";
dr = cmd.ExecuteReader();
ddlSNum.DataSource = dr;
ddlSNum.DataTextField = "S_Number";
ddlSNum.DataValueField = "S_Number";
ddlSNum.DataBind();
ddlSNum.Items.Insert(0, "--- Select SNum ---");
con.Close();
}
private string GetDBConnectionString()
{
return ConfigurationManager.ConnectionStrings["SagarDBCS"].ConnectionString;
}


protected void btnSave_Click(object sender, EventArgs e)
{
cmd.CommandText = $"Insert into S_Test(S_Name,S_Number,S_Percentage) values('{txtName.Text}',{txtNumber.Text},{txtPercentage.Text})";
con.Open();
int count = cmd.ExecuteNonQuery();
if (count > 0)
Response.Write("Data Inserted Succesfully");
txtName.Text = txtNumber.Text = txtPercentage.Text = "";
con.Close();
}
private void DropDownData(int S_Number)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SagarDBCS"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("Select * from S_Test where S_Number=" + ddlSNum.SelectedValue, con))
{
con.Open();
dr = cmd.ExecuteReader();
if(dr.Read())
{
txtName.Text = dr["S_Name"].ToString();
txtNumber.Text = dr["S_Number"].ToString();
txtPercentage.Text = dr["S_Percentage"].ToString();
}
con.Close();
}
}
}

protected void ddlSNum_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownData(Convert.ToInt32(ddlSNum.SelectedValue));
gvTest.DataSource = dr;
gvTest.DataBind();
}
}
}