sql - Updating and retrieving images (Asp.net c#) - 


protected void upimg_about_click(object sender, eventargs e) {                    con.open();     string sqlquery = " update [dbo].[tbldetails] set [image]=@image,[image2]=@image2 id=@id";     sqlcommand cmd2 = new sqlcommand(sqlquery, con);     cmd2.parameters.addwithvalue("@id", session["email"].tostring());      int img = image1.postedfile.contentlength;     int img2 = image2.postedfile.contentlength;      byte[] msdata = new byte[img];     byte[] msdata2 = new byte[img2];      image1.postedfile.inputstream.read(msdata, 0, img);     image2.postedfile.inputstream.read(msdata2, 0, img2);      cmd2.parameters.addwithvalue("@image", msdata);     cmd2.parameters.addwithvalue("@image2", msdata2);      if (con.state == connectionstate.closed)     {         con.open();     }     cmd2.executenonquery();      con.close();      data1.text="image updated successfully";     }

this code using update images in database.

the user when required can update images (eg: in firstpage.aspx) , can retrieve in next page (nextpage.aspx).

but problem is: suppose user wants update single image , he/she upload's image , clicks update button , when retrieving images in next page image updated visible 1 present in database not. not sure during updation other fileupload empty why happening? there other way it?

ps: have textboxes in firstpage.aspx in retrieving text he/she has put in database , hence when user wants make changes can done easily. 

textbox1.text = dr["name"].tostring(); textbox2.text = dr["address"].tostring();

so, possible retrieve image path user has submitted? or way in user can update single image , during retrieval both images can retrieved?

thank you! :)

break code can send 1 image @ time db. pass corresponding fileupload , sql column name function. conditionally send new file database depending on whether fileupload contains file. can check looking @ hasfile property.

protected void upimg_about_click(object sender, eventargs e) {                    // make sure @ least 1 file     if (!image1.hasfile && !image2.hasfile)     {         data1.text="no images uploaded";         return;     }      con.open();     uploadimage(image1, "[image]");     uploadimage(image2, "[image2]");     con.close();      data1.text = "image updated successfully";     }  void uploadimage(fileupload fileupload, string columnname) {     if (!fileupload.hasfile)     {         return;     }      string sqlquery = "update [dbo].[tbldetails] set " + columnname + "=@image id=@id";     sqlcommand cmd = new sqlcommand(sqlquery, con);     cmd.parameters.addwithvalue("@id", session["email"].tostring());      int img = fileupload.postedfile.contentlength;     byte[] msdata = new byte[img];     fileupload.postedfile.inputstream.read(msdata, 0, img);     cmd.parameters.addwithvalue("@image", msdata);      cmd.executenonquery(); }

Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more