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

ADVANCE 2025

 HTML TABLE SCROLL BAR  <style>      .table-container {             width: 100%;             overflow-x: auto; /* Enables horizontal s...