Complete tutorial on gridview in C#. ~ Code Kulshresth

Complete tutorial on gridview in C#.

..............................default.aspx............................
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td>
<asp:Label ID="lable1" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td>
Image id:
</td>
<td>
<asp:TextBox ID="txtImageId" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Image Name:
</td>
<td>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Upload Image:
</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" Text="submit" OnClick="Button1_Click" />
</td>
</tr>
<tr>
<td>
 
</td>
</tr>
<tr>
<td>
 
</td>
<td>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit"
OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting">
<Columns>
<asp:BoundField DataField="image_id" HeaderText="Image ID" ReadOnly="True" />
<asp:BoundField DataField="image_name" HeaderText="Image Name" />
<asp:BoundField DataField="image_path" HeaderText="Image Path" />

<asp:TemplateField HeaderText="image">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" Width="40px" Height="40px" ImageUrl='<%#DataBinder.Eval(Container,"DataItem.image_path") %>' />
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" />
</EditItemTemplate>
</asp:TemplateField>

<asp:CommandField ShowEditButton="True" HeaderText="Edit" />
<asp:CommandField HeaderText="Delete" ShowDeleteButton="True" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</form>
</body>
</html>

............................................end......................................

...........................default.aspx.cs..............................

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

public partial class Default3 : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());

SqlCommand cmd;

SqlDataAdapter da;

DataSet ds=new DataSet();

static int a = 0;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGrid();

}

protected void Button1_Click(object sender, EventArgs e)

{

string str = Server.MapPath(@"Image/");

FileUpload1.SaveAs(str + FileUpload1.FileName);

string s3 = FileUpload1.FileName;

int m = Convert.ToInt32(txtImageId.Text);

con.Open();

int n = add_catagory(m, txtName.Text, s3);

if (n == 1)

{

Response.Write("Record inserted sucessfully");

txtImageId.Text = "";

txtName.Text = "";

}

a = 0;

BindGrid();

}

public int add_catagory(int s1, string s2, string s3)

{

cmd = new SqlCommand("insert_catagory", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@imagid", SqlDbType.Int).Value = s1;

cmd.Parameters.AddWithValue("@image_name", SqlDbType.VarChar).Value = s2;

cmd.Parameters.AddWithValue("@imp_path", SqlDbType.VarChar).Value = s3;

int k = cmd.ExecuteNonQuery();

return k;

}

public void BindGrid()

{

da = new SqlDataAdapter("select * from image", con);

ds = new DataSet();

da.Fill(ds, "t1");

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

if (a == 0)

{

int n = ds.Tables[0].Rows.Count;

for (int i = 0; i < n; i++)

{

string file = ds.Tables[0].Rows[i][2].ToString();

string path = "Image/" + file;

Image im = (Image)GridView1.Rows[i].FindControl("Image1");

im.ImageUrl = path;

}

a = 1;

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

BindGrid();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

a = 0;

BindGrid();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int img_id = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[0].Text);

FileUpload fp = (FileUpload)GridView1.Rows[e.RowIndex].FindControl("FileUpload1");

TextBox img_name = (TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];

TextBox imp_path = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0];

string imagepath = fp.FileName;

string s1 = Convert.ToString(img_name.Text);

string s3 = "IMAGE/" + fp.FileName;

if (fp.FileName == "")

{

s3 = imagepath;

}

else

{

fp.SaveAs(Server.MapPath("Image/" + fp.FileName));

}

string s = "update image set image_name='" + s1 + "',image_path='" + imagepath + "' where image_id=" + img_id;

execcutecommand(s);

GridView1.EditIndex = -1;

a = 0;

BindGrid();

}

public void execcutecommand(string s)

{

cmd = new SqlCommand(s, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int id = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[0].Text);

string s = "delete from image where image_id =" + id;

execcutecommand(s);

a = 0;

BindGrid();

}

.......................................................end............................

Dotnet Tracking Team

Hi all friends, I think working with DotNet technologies is quite good. Some of them are sharing with you, which will help a lot to get a good job and to make the interview worthy. Best wishes.

Wednesday, 14 May 2014