phyo minhan
I want to know that C# have a grid view?or not if yes then the use of it to join the database.
By phyo minhan in C# on Jun 13 2012
  • Satyapriya Nayak
    Jun, 2012 26

    In windows application it is called as datagridview ,but in web application we call it as gridview.GridView Insert update delete search,<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> Untitled Page




    using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page {string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;//SqlConnection conn = new SqlConnection(connStr);SqlDataAdapter ad = new SqlDataAdapter();SqlCommand cmd = new SqlCommand();DataTable dataTable;SqlDataAdapter sqlda;DataSet ds;string str;protected void Page_Load(object sender, EventArgs e){Session["sortBy"] = null;if (!IsPostBack){FillVendorGrid();}}private void FillVendorGrid(){SqlConnection conn = new SqlConnection(connStr);dataTable = new DataTable();cmd.Connection = conn;cmd.CommandText = "SELECT * FROM Vendor";ad = new SqlDataAdapter(cmd);ad.Fill(dataTable);ResultGridView.DataSource = dataTable;ResultGridView.DataBind();}protected void ResultGridView_RowEditing(object sender, GridViewEditEventArgs e){ResultGridView.EditIndex = e.NewEditIndex;FillVendorGrid();}protected void ResultGridView_PageIndexChanging(object sender, GridViewPageEventArgs e){ResultGridView.PageIndex = e.NewPageIndex;FillVendorGrid();}protected void ResultGridView_RowDeleting(object sender, GridViewDeleteEventArgs e){SqlConnection conn = new SqlConnection(connStr);cmd.Connection = conn;cmd.CommandText = "DELETE FROM Vendor WHERE VendorId='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";conn.Open();cmd.ExecuteNonQuery();conn.Close();FillVendorGrid();}protected void ResultGridView_RowUpdating(object sender, GridViewUpdateEventArgs e){TextBox txtFName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtFName");TextBox txtLName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtLName");TextBox txtCity = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtCity");TextBox txtState = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtState");TextBox txtCountry = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtCountry");TextBox txtDescription = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtDescription");SqlConnection conn = new SqlConnection(connStr);cmd.Connection = conn;cmd.CommandText = "UPDATE Vendor SET VendorFName ='" + txtFName.Text + "',VendorLName ='" + txtLName.Text + "',VendorCity ='" + txtCity.Text + "',VendorState ='" + txtState.Text + "',VendorCountry ='" + txtCountry.Text + "',VendorDescription ='" + txtDescription.Text + "' WHERE VendorId='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";conn.Open();cmd.ExecuteNonQuery();ResultGridView.EditIndex = -1;FillVendorGrid();conn.Close();}protected void ResultGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){ResultGridView.EditIndex = -1;FillVendorGrid();}protected void ResultGridView_RowCommand(object sender, GridViewCommandEventArgs e){if (e.CommandName.Equals("AddNew")){TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl("txtFName1");TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl("txtLName1");TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl("txtCity1");TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl("txtState1");TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl("txtCountry1");TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl("txtDescription1");SqlConnection conn = new SqlConnection(connStr);cmd.Connection = conn;cmd.CommandText = "INSERT INTO Vendor(VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription) Values('" + txtFName.Text + "', '" + txtLName.Text + "', '" + txtCity.Text + "', '" + txtState.Text + "', '" + txtCountry.Text + "' , '" + txtDescription.Text + "')";conn.Open();cmd.ExecuteNonQuery();FillVendorGrid();conn.Close();}}protected void btn_search_Click(object sender, EventArgs e){SqlConnection conn = new SqlConnection(connStr);conn.Open();str = "select * from Vendor where VendorFName like '" + TextBox1.Text + "%'";cmd = new SqlCommand(str, conn);sqlda = new SqlDataAdapter(cmd);ds = new DataSet();sqlda.Fill(ds, "Vendor");conn.Close();ResultGridView.DataSource = ds;ResultGridView.DataMember = "Vendor";ResultGridView.DataBind();}protected void ResultGridView_Sorting(object sender, GridViewSortEventArgs e){Session["sortBy"] = e.SortExpression;FillVendorGrid();} }

    • 0
  • S G
    Jun, 2012 26

    Yes there is datagrid view in the c#. U can use database in that for all the operation like insert,delete, update and anything.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS