In the Coding, you have to replace Single Quotes with Double Single Quotes for that Sring and the resulting string only, should be stored in the DB
Example
Code:
strResult=Replace(txtName.Text, "'","''")
Regards
Vijay.R
strResult=Replace(txtName.Text, "'","''")
With MaskEdBox1 sTemp = .Mask .Mask = "" .Text = "" .Mask = sTemp End With
Dim Request As String, rsData As Recordset If Me.cmdUpdate.Caption = "&Save" Then Request = "INSERT INTO tblMasterData
td.locked, th.locked { position:relative; left:expression((this.parentElement.parentElement.parentElement.parentElement.scrollLeft-2)+'px'); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {
decimal value = Convert.ToDecimal(textBox3.Text); string sql = "Insert into YourTableNameHere values(Convert(money, '" + value + "')";
Select [asset], [desc] from tb_test GROUP BY asset
" where comment_code = " & Val(Sreasoncode)
" where comment_code = '" & Sreasoncode & "'"
Private Sub PONumber_AfterUpdate() Vendor = DLookup("[Vendor]", "tblContracts", "[PO Number] =" & PONumber) End Sub
if ((ddList.DataSource != null)) { //Your Code Here }
using System; public class Customer { private int m_id = -1; public int ID { get { return m_id; } set { m_id = value; }
'Add This Function to your Code Public Shared Sub ValidateKeys(ByVal strContent As String, ByVal e As System.Windows.Forms.KeyPressEventArgs, ByVal blnAlpha As Boolean, ByVal blnNumeric As Boolean, ByVal blnSpecial As Boolean, Optional ByVal strAllowableChars As String = "", Optional ByVal strDisAllowableChars As String = "", Optional ByVal blnToUpperCase
Leave a comment: