Thursday, August 17, 2023

SQL REPLACE FUNCTION IN A CODE

 string update1 = "update picdb  set pic=Replace(pic,'" + Label3.Text + "' , '" + newpic1.Text + "') 


    where pic like '%" + Label3.Text + "%'  and  id='" + rowid.Text + "'"; 

    

     cm = new SqlCommand(update1, cn);

     

      cm.ExecuteNonQuery();

       

No comments:

Post a Comment

GRIDVIEW ON ROW DATA BOUND EVENT

 Database Create  Student : roll , name , city , cost  Fix 6 Value  in Database Record  ====================================================...