Extract Data into Gridview with C#

1.Open visual studio and create a new website.

2.Drag some text boxes , labels , button and Add a data grid view on the page.

3.Use the code on Default.aspx page.

<asp:Label ID="Label1" runat="server" Width="60px" Text="Name"></asp:Label>
<asp:TextBox ID="TextBox1" CellPadding="4" CellSpacing="2" runat="server" AutoCompleteType="Disabled"></asp:TextBox>
 
 
<asp:Label ID="Label2" runat="server" Width="60px" Text="Address"></asp:Label>
<asp:TextBox ID="TextBox2" CellPadding="4" CellSpacing="2" runat="server" AutoCompleteType="Disabled"></asp:TextBox>
 
 
<asp:Label ID="Label3" runat="server" Width="60px" Text="Age"></asp:Label>
<asp:TextBox ID="TextBox3" CellPadding="4" CellSpacing="2" runat="server" AutoCompleteType="Disabled"></asp:TextBox>
 
 
<asp:Label ID="Label4" runat="server" Width="60px" Text="Phone_no"></asp:Label>
<asp:TextBox ID="TextBox4" CellPadding="4" CellSpacing="2" runat="server" AutoCompleteType="Disabled"
</asp:TextBox>
 
 
<asp:Button ID="Button1" runat="server" CellPadding="4" CellSpacing="2"
onclick="Button1_Click" Text="Insert"
style="height: 26px" />
<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Delete" />
 
 
 
<asp:GridView ID="GridView1" runat="server" BackColor="#CCCCCC"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4"
CellSpacing="2" ForeColor="Black">
<RowStyle BackColor="White" />
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>

4.Use the following code on default.aspx.cs page.

The below code is also include the database connectivity

public partial class _Default : System.Web.UI.Page
{
OleDbConnection con;
OleDbCommand cmd=new OleDbCommand();
OleDbCommand cmd1;
string str, str1;
DataSet ds = new DataSet();
OleDbDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
BindData();
con = new OleDbConnection("Provider =MSDAORA.1;User ID =system; Password =sys123;database=orcl");
con.Open ();
}
protected void Button1_Click(object sender, EventArgs e)
{
str = "insert into emp1 values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" +
TextBox4.Text + "')";
cmd = new OleDbCommand(str, con);
cmd.ExecuteNonQuery();
}
protected void Button2_Click(object sender, EventArgs e)
{
str1 = "Delete from emp1 where Name ='" + TextBox1.Text + "'";
cmd1 = new OleDbCommand(str1, con);
cmd1.ExecuteNonQuery();
}
private void BindData()
{
con = new OleDbConnection("Provider =MSDAORA.1;User ID =system; Password =sys123;database=orcl");
str = "Select * from emp1";
cmd.CommandText = str;
cmd.Connection = con;
da = new OleDbDataAdapter(cmd);
con.Open();
da.Fill(ds);
cmd.ExecuteNonQuery();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}

OUTPUT OF THE APPLICATION

Extract Data into Gridview with C#

Reactions

1 Comment