how to store an image and textbox in sqlserver ?

antony victor

I have a category module in which i have a text box and image and I have a gridview on the same page

I want to save textbox and image values on sql server and as well display it on gridview.

I want to store the image in varchar format in database and not as image datatype.

apart from handler , is there any method?

Can anyone help me with the ado connections and design table in sqlserver .

Below is my category page

<%--

--%>

Category Name:	ontextchanged="TextBox1_TextChanged"> ControlToValidate="TextBox1" ErrorMessage="Ad Name 1 required" ValidationGroup="v1">*
Add Image1:
Description 1:	ValidationGroup="v1" ontextchanged="TextBox3_TextChanged"> (only 50 characters allowed) ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3" ErrorMessage="Description 1 required" ValidationGroup="v1">*
	ValidationGroup="v1" /> ValidationGroup="v1" />
	ShowMessageBox="True" ShowSummary="False" ValidationGroup="v1" />

AutoGenerateColumns="false" BorderColor="#FF6600"

BorderWidth="1px" CellPadding="10" CellSpacing="4"

GridLines="None" HorizontalAlign="Center"

onpageindexchanging="GridView1_PageIndexChanging" PageSize="10"

onrowdeleting="GridView1_RowDeleting" AllowPaging="True"

onselectedindexchanged="GridView1_SelectedIndexChanged">

Width="200">

<%--

Width="200">

--%>

<%-- --%>

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Accepted answer
check this link:

http://www.aspdotnet-suresh.com/2011/03/how-to-save-images-into-folder-and.html

if any problem rply.
antony victor13y ago
got it sir, Thanks for the reply..
Sanjeeb Lenka13y ago
Hi Antony,
Better to store image path in database and image in server. if you store image in database directly it take lot space in database and fetching the image required extra code. For better performance store the path in database.
antony victor13y ago
Dear Sanjeeb sir,first of all i would thank you for the help, n i have a doubt, is there any chance of storing the image directly and not the imagepath..
Bcoz , i have to extend the functionality, i meant i have to create a subcategory in the nextpage and i have to pull the category name in dropdown list and add the same textbox and another image , under category .... And i have to display both category , subcategory in gridview....

can the above thing be done by storing the imagepath ?