antony victor

How to populate dropdownlist and add values to database.

Jun 24 2013 5:50 AM

I have a category page wherein i am adding a textbox data as categoryname and an image as categoryimage to database and also binding to gridview in same page.

Now I have another page Subcategory

I want to pull the data from category page ie categoryname into dropdownlist and also add another textbox and image under it.

In category table ID ImageName Imagepath .

could anyone help me with connections in subcategory page as well as sqldatabase design as how to link the two tables.

I have pasted the category and subcategory table

CATEGORY TABLE

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

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

<title>Save Images In Folder and Display Images in Gridview from folder</title>

.Gridview

{

font-family:Verdana;

font-size:10pt;

font-weight:normal;

color:black;

}

</style>

function Confirmationbox() {

var result = confirm('Are you sure you want to delete selected Category(s)?');

if (result) {

return true;

}

else {

return false;

}

</script>

</head>

<body>

<div>

<asp:Label ID="Label1" runat="server" Text="Category Name" Width="100px" Height="16px"

style="margin-top: 0px"></asp:Label>

<asp:TextBox ID="TextBox1" runat="server" Width="180px" style="margin-top: 0px"

Height="23px"></asp:TextBox>

<br/>

<br />

<asp:Label ID="Label3" runat="server" Text="Upload Image" Width="100px" Height="16px"

style="margin-top: 0px"></asp:Label>

<asp:FileUpload ID="fileuploadimages" runat="server" />

<br />

<asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" />

</div>

<div>

<br />

<asp:GridView runat="server" DataKeyNames="ID" ID="gvImages" AutoGenerateColumns="False"

DataSourceID="sqldataImages" CssClass="Gridview"

HeaderStyle-BackColor="#61A6F8"

onselectedindexchanged="gvImages_SelectedIndexChanged" >

<asp:BoundField DataField="ID" HeaderText="ID" />

<asp:BoundField DataField="ImageName" HeaderText="CategoryName" />

<asp:ImageField HeaderText="Image" DataImageUrlField="ImagePath" />

<asp:TemplateField>

<asp:CheckBox ID="chkdelete" runat="server" />

</ItemTemplate>

</asp:TemplateField>

<%-- <asp:TemplateField HeaderText="Select">

<asp:LinkButton ID="LinkButton1"

CommandArgument='<%# Eval("ID") %>'

CommandName="Delete" runat="server">

Delete</asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>--%>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="sqldataImages" runat="server" ConnectionString="<%$ConnectionStrings:dbconnection %>"

SelectCommand="select * from Category1"

DeleteCommand="delete from Category1 where ID=@ID" >

<asp:Parameter Name="ID" Type="Int32" />

</DeleteParameters>

</asp:SqlDataSource>

</div>

<asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" />

</form>

</body>

</html>

.CS file

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.IO;

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;

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

{

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

protected void Page_Load(object sender, EventArgs e)

{

btnDelete.Attributes.Add("onclick", "javascript:return Confirmationbox()");

//if (!IsPostBack)

//{

//}

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

//Get Filename from fileupload control

//string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);

string filename = TextBox1.Text;

//Save images into Images folder

fileuploadimages.SaveAs(Server.MapPath("Images/" + filename));

//Getting dbconnection from web.config connectionstring

//Open the database connection

con.Open();

//Query to insert images path and name into database

SqlCommand cmd = new SqlCommand("Insert into Category1(ImageName,ImagePath) values(@ImageName,@ImagePath)", con);

//Passing parameters to query

cmd.Parameters.AddWithValue("@ImageName", filename);

cmd.Parameters.AddWithValue("@ImagePath", "Images/" + filename);

cmd.ExecuteNonQuery();

//Close dbconnection

con.Close();

Response.Redirect("~/Default.aspx");

}

//protected void gvImages_RowDeleting(object sender, GridViewDeleteEventArgs e)

//{

// int id = Convert.ToInt32(Gd_GalleryDetails.DataKeys[e.RowIndex].Value);

// ad.deletegalleryimage(id);

// msg.Show("Image deleted from gallery");

// fillgrid();

//private void BindData(string Query)

//{

// con.Open();

// using (SqlCommand comm = new SqlCommand(Query +

// "; select * from Category1 ", con))

// {

// SqlDataAdapter da = new SqlDataAdapter(con);

// DataSet ds = new DataSet();

// da.Fill(ds);

// gvImages.DataSource = ds;

// gvImages.DataBind();

// }

//}

// protected void gvImages_RowDeleting(object sender, GridViewDeleteEventArgs e)

//{

// string EmployeeID = gvImages.DataKeys[e.RowIndex].Value.ToString();

// string Query = "delete Category1 where Category1.Category1ID =" +Category1ID;

// BindData(Query);

//}

//protected void gvImages_RowDataBound(object sender,

// GridViewRowEventArgs e)

//{

// if (e.Row.RowType == DataControlRowType.DataRow)

// {

// LinkButton l = (LinkButton)e.Row.FindControl("LinkButton1");

// l.Attributes.Add("onclick", "javascript:return " +

// "confirm('Are you sure you want to delete this record " +

// DataBinder.Eval(e.Row.DataItem, "CategoryID") + "')");

// }

//}

//protected void gvImages_RowCommand(object sender,

// GridViewCommandEventArgs e)

//{

// if (e.CommandName == "Delete")

// {

// // get the categoryID of the clicked row

// int ID = Convert.ToInt32(e.CommandArgument);

// // Delete the record

// DeleteRecordByID(ID);

// // Implement this on your own :)

// }

//}

//protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

//{

// int ID = (int)gvImages.DataKeys[e.RowIndex].Value;

// DeleteRecordByID(ID);

//}

protected void gvImages_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void btnDelete_Click(object sender, EventArgs e)

{

//Loop through all the rows in gridview

foreach (GridViewRow gvrow in gvImages.Rows)

{

//Finiding checkbox control in gridview for particular row

CheckBox chkdelete = (CheckBox)gvrow.FindControl("chkdelete");

//Condition to check checkbox selected or not

if (chkdelete.Checked)

{

//Getting UserId of particular row using datakey value

int UID = Convert.ToInt32(gvImages.DataKeys[gvrow.RowIndex].Value);

sqldataImages.DeleteParameters["ID"].DefaultValue = UID.ToString();

sqldataImages.Delete();

}

SUBCATEGORY PAGE

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

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

</head>

<body>

<div>

<asp:Label ID="Label1" runat="server" Text="CategoryName" Width ="150px"></asp:Label>

 <asp:DropDownList ID="DropDownList1" runat="server" Height="36px" Width="150px">

</asp:DropDownList>

<br />

</div>

<asp:Label ID="Label2" runat="server" Text="SubcategoryName"></asp:Label>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<br />

Image                            

<asp:FileUpload ID="FileUpload1" runat="server" />

<br />

<asp:Label ID="Label3" runat="server" Text="Description"></asp:Label>

<asp:TextBox ID="TextBox2" runat="server" style="margin-left: 0px"

Width="159px"></asp:TextBox>

<br />

<asp:Button ID="Button1" runat="server" Text="Add" Width="100px"

onclick="Button1_Click"/>

</form>

</body>

</html>

Answers (18)

ReportViewer - Add Header Dynamically

save .ppt file in sql server