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

Subscribe to: Post Comments (Atom)

Cookies login

  Match login id and password using cookies under 1 minutes if user not input valid I'd pass in 1 min then cookies expired and go to hom...

  • GRIDVIEW ON ROW DATA BOUND EVENT
     Database Create  Student : roll , name , city , cost  Fix 6 Value  in Database Record  ====================================================...
  • Store Procedure Notes
      Store   Procedure   CREATE PROCEDURE mytest2 AS BEGIN     SELECT         name ,         city     FROM         student...
  • Checkbox List
     protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)     {         int i;         for (i = 0; i < CheckBoxL...