ASP.NET

how to save images in sqlserver again retrive from sqlserver using asp.net control

31-Mar-09 19:30

.NET in general uses exceptions, so I say stay consistent.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Ch.Gayatri Subudhi31-Mar-09 19:06

Ch.Gayatri Subudhi

31-Mar-09 19:06

Hi I am trying to store the images using asp.net browser control ie, fileupload. .Its with store the images in to the databse where i used as sqlserver as backend. It store but, after that i am trying to retrive those images through listview from backend. But here i am getting no error but no images are there in images.I need the names of the images in the listview from backend while clicking a particular image it should be enlarge in image control.Thanks in advance.Please help me.

In default.aspx.cs page:
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DigitalSignageConnectionString2"].ConnectionString.ToString());
protected void Page_Load(object sender, EventArgs e)
{
}
protected void BthSnd_Click(object sender, EventArgs e)
{
con.open();
SqlCommand mycommand = new SqlCommand("INSERT INTO Image_DiSig([image], [text],[path],[image1]) VALUES (@image, @text,@imgpath) ", con);
string apppath = Request.PhysicalApplicationPath;
FileUpload1.SaveAs(apppath + "images\\" + FileUpload1.FileName);
string imgpath = apppath + "images\\" + FileUpload1.FileName;
FileStream fs = File.OpenRead(imgpath);
byte[] imagedata = new byte[fs.Length];
mycommand.Parameters.AddWithValue("@image", imagedata);
mycommand.Parameters.AddWithValue("@text", TextBox1.Text);
mycommand.Parameters.AddWithValue("@imgpath", apppath);
mycommand.ExecuteNonQuery();
con.Close();
}

public string FormatURL2(object strArgument) //used to get that image bytes(while tracing its picking that bytes but not converting into image)
{
return ("Default2.aspx?id=" + strArgument);
}

protected void LinkButton1_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("select * from Image_DiSig",con);
DataSet ds = new DataSet();
da.Fill(ds);
ListView1.DataSource = ds;
ListView1.DataBind();
}

protected void ListView1_SelectedIndexChanged(object sender, EventArgs e)
{

Image1.ImageUrl = ListView1.SelectedValue.ToString();
}

in default.aspx source page:

<asp:ListView ID="ListView1" runat="server"
onselectedindexchanged="ListView1_SelectedIndexChanged" SelectedIndex="0" >
<LayoutTemplate>
<div style="border:dotted 1px black;">
<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
</div>
</LayoutTemplate>
<ItemTemplate>
<img alt="name" align="middle" height="50px" width="100px" name="Image1" src='<%# FormatURL2(DataBinder.Eval(Container.DataItem, "id")) %>' />
</ItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:DigitalSignageConnectionString2 %>"
SelectCommand="SELECT * FROM [Image_DiSig]"></asp:SqlDataSource>

in default2.aspx.cs:

public partial class Default2 : System.Web.UI.Page
{
SqlCommand cmdd = new SqlCommand();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DigitalSignageConnectionString2"].ConnectionString.ToString());

protected void Page_Load(object sender, EventArgs e)
{
string strImageID = Request.QueryString["id"];
try
{
conn.Open();
SqlDataReader dr = null;
cmdd = new SqlCommand("select image from Image_DiSig where id=" + strImageID,conn);
dr = cmdd.ExecuteReader();

while (dr.Read())
{

if (dr["image"].ToString() == "")
{
Response.Write("no image");
}
else
{
byte[] img = (byte[])(dr["image"]);
Response.BinaryWrite(img);
}
}
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
finally
{
conn.Close();
}
}
}

With Regards
Ch.Gayatri Subudhi

Re: how to save images in sqlserver again retrive from sqlserver using asp.net control

Christian Graus31-Mar-09 19:14

Re: how to save images in sqlserver again retrive from sqlserver using asp.net control

31-Mar-09 19:14

If nothing gets returned you need to debug your SQL. Otherwise, you may just need to write a MIME type. Spend some time in the debugger, and get back to us when you can tell us what is specifically happening.

Ch.Gayatri Subudhi31-Mar-09 19:45

Ch.Gayatri Subudhi

31-Mar-09 19:45

Sir,
No error coming while debugging then why its not converting from byte to image formate i wrote the code for that but no output is coming.

With Regards
Ch.Gayatri Subudhi

Error for file upload

saravanan0531-Mar-09 18:10

saravanan05

31-Mar-09 18:10

hi friend

i upload the file below error occured...

Access to the path 'D:\aesweb\WebSite\Images\banner_bulb.gif' is denied.

regards
saravanan

Known Is Drop.Unknown Is Ocean

Re: Error for file upload

Christian Graus31-Mar-09 18:18

Re: Error for file upload

31-Mar-09 18:18

Apparently, you don't have access to that file. Perhaps you might consider telling us what code causes this error, and when it happens. Saying 'I upload the file' doesn't tell us much. Did you try to upload a new file to your images folder and then access it ? How did you try to access it ?

Rajeesh MP31-Mar-09 18:18

Rajeesh MP

31-Mar-09 18:18

if you r using Ajax u need to give trigger tag for that upload control.
otherwise change that file('D:\aesweb\WebSite\Images\banner_bulb.gif) property readonly false.

Re: Error for file upload

Abhijit Jana31-Mar-09 18:50

Abhijit Jana

31-Mar-09 18:50

saravanan05 wrote:
i upload the file below error occured...

Access to the path 'D:\aesweb\WebSite\Images\banner_bulb.gif' is denied.

It may be cause of user does not have the write permission on that folder.
Possible Solution :
1. Give the write access to that folder.
2. [If you have deployed it in IIS] Create a separate application pool, change its identity of local system, assign that application to your virtual directory.

Your problem will be resolved.

cheers,
Abhijit
CodeProject MVP

ASP.net with vb: Insert data into specific cell in excel file

nicholasng31-Mar-09 13:47

nicholasng

31-Mar-09 13:47

hi,

i intend to insert some variable which got string of data into specific cell in an existing excel file in localhost, eg: variable1 insert to cell E,3, variable2 insert to cell G,6.....

my scenario is the existing excel file is a preformatted and i dont know how to insert certain data into specific cell in the excel file...

anyone can giv some recommend solution? Pls help.

Re: ASP.net with vb: Insert data into specific cell in excel file

Christian Graus31-Mar-09 15:01

Re: ASP.net with vb: Insert data into specific cell in excel file

31-Mar-09 15:01

This has nothing to do with ASP.NET, even though you're doing it within the context of an ASP.NET site. You're modifying a local Excel file, you'd do better to ask in the right forum for the language you're using.

Rajeesh MP31-Mar-09 18:16

Rajeesh MP

31-Mar-09 18:16

How you r Exporting that Excel File...?

Re: ASP.net with vb: Insert data into specific cell in excel file

nicholasng1-Apr-09 2:36

nicholasng

1-Apr-09 2:36

oops, forgot to tell that the program is an offline system which use asp.net with vb.... there is juz 1 user for that program, and the excel file is place in localhost.

thanks for help, any others recommend solution?

Type or namespace not found for user control.

Brady Kelly31-Mar-09 9:53

Brady Kelly

31-Mar-09 9:53

Tonight I copied an ASP 2.0 web site onto a client's machine, and lo! It did not work. It works perfectly on mine, under built in debugger and under IIS 7, and two weeks ago, it worked perfectly on his machine under IIS 6.

The only changes I have made are upgrading telerik RadGrid etc. to Q1 2009, and some refactoring. The application fails on two entry point web forms. Both have a RadGrid, which uses a User Control for its editing pop-up. Both forms fail to compile, with a 'Type or namespace JobEditControl not found" error, on a line like this:

var editControl = e.Item.FindControl(GridEditFormItem.EditFormUserControlID) as JobEditControl;

The control is not referenced in the markup, as it never appears on there, and as I understand it, it should be compiled into the same default namespace as the page is compiled into when first hot.

The machine is still serving user controls properly, i.e. the .ascx handler appears healthy, and a quick test page containing a quick test control I added worked fine.

Another developer was busy on the machine before me, also installing an ASP.NET application, but I can't think of anything he would have changed. Even being my competition...

Passing data through hyperlink

yorockk31-Mar-09 9:28

31-Mar-09 9:28

i have some hyperlinks on a form.I have set the navigate url of all the hyperlinks to a single destination page("display.aspx")i.e.clicking on ne of the hyperlinks would take you to the same page "display.aspx"..
but based on which hyperlink i hav selected, accordingly values from database will be retrieved and will displayed in "display.aspx"..
for eg:
suppose i hav 3 hyperlinks say :
1)programmer
2)business analyst
3)software engineer

and if i click on programmer then accordingly query will be executed in the page load event of "display.aspx" and info abt programmer will be retrieved from database and displayed in a gridview.
plzz suggest some solution..

Yusuf31-Mar-09 12:23

Yusuf

31-Mar-09 12:23

what you need is query string

display.aspx?user=programmer<br />
display.aspx?user=analyst<br />
display.aspx?user=engineer

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

zy5187593931-Mar-09 17:43

zy51875939

31-Mar-09 17:43

You can use the hyperlink's command event to get the command arguments from which hyperlink you clicked.

yorockk31-Mar-09 18:49

31-Mar-09 18:49

hi yusuf thanx for the answer,but can u elaborate it a bit more..
where to write these querystring,in which event of hyperlink?

vinodkrebc31-Mar-09 18:32

vinodkrebc

31-Mar-09 18:32

You have to just pass the selected values through
query string

Click Here

Vinod Kr.

yorockk31-Mar-09 20:43

31-Mar-09 20:43

hey vinodkrebc,
plzz paste the link...

vinodkrebc1-Apr-09 0:53

vinodkrebc

1-Apr-09 0:53

Click Here

you can write any page instead of default.aspx and the data member instead of Id from datasource

yorockk3-Apr-09 3:22