..............................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">
<asp:Button ID="Button1" runat="server" Text="submit" OnClick="Button1_Click" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit"
OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting">
<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:Image ID="Image1" runat="server" Width="40px" Height="40px" ImageUrl='<%#DataBinder.Eval(Container,"DataItem.image_path") %>' />
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:CommandField ShowEditButton="True" HeaderText="Edit" />
<asp:CommandField HeaderText="Delete" ShowDeleteButton="True" />
............................................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............................
