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: