When the sql contains the single quotes then they have to be properly escaped otherwise it will give errors just pass the field value which you want to check and the following function will return you the properly escaped string. eg. o’brien will be returned as o”brien and this will not cause your sql to […]
A Combo box has two properties 1.One which displays the items in the combo box called the DISPLAY MEMBER 2. Another one which stores the underlying ID for the Item which is being Displayed. eg your table may have EmployeeId and EmployeeName. You would like to display the EmployeeName in the ComboBox and […]
How to execute a Backend Procedure in SQL Server using VB.NET Here is a function which allows you to execute a SQL Server Procedure in VB.NET Function ExecuteProcedure_DeleteRecord() as boolean Dim cn As New SqlConnection Dim cmd As New SqlCommand Dim sql As String sql = “cs_Post_Delete” cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.AddWithValue(“@SectionID”, “200”) ‘ string then […]
Saving Changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
In SQL Server if you attempt to modify a table structure through the Table Designer you would encounter this error. There is a simple fix for it. Step 1 Go to Tools > Options Step 2 Go to Designer > Table and Database Designers and Untick the option Step 3: […]