-
Hi all, I've tried SQL injection for a normal SQL query and it workd fine but when i tried to do the same with a Stored Procedure it's not working. The reason i found was i coundn't avoid single quoate. This is the procedure create procedure login @email varchar(50), @pwd varchar(30) as select...
-
Hi amila, Simply use t-sql DATEADD function. http://msdn.microsoft.com/en-us/library/ms186819.aspx Cheers!
-
This Link will help you.... http://www.freekingdom.yolasite.com/helping-hand.php If you get any help from that site please click one advertisement.. Thank You
-
Hi chikulanikader, Though I'm not much into MySql, I think the grave accent ( ` ) should work. Note that don't confuse this with the single quote ( ' ). Btw, you cannot use either / or \ charactors, as they are illegal in MySQL. Eg: create table `some table name` (col INT); Unfortunately...
-
hi Melick, Thank you very much, it worked for me. Now I have another problem, is there something special on INSERT statement when inserting these values, or same as varchar values....?
-
As I know; You don't have to lock tables manually, you just need to use a SqlTransaction in C# as below, SqlTransaction tran; SqlConnection con = new SqlConnection("<connectionString>"); SqlCommand com = new SqlCommand(con,""); try { tran = con.BeginTransaction(); com.Transaction...
-
please go through the picture in the first post. getting error 32 and 40.
-
please go through, i implemented some error handling to find out the occurence of error. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; // added by me using System.Data.SqlClient; namespace...
-
i was trying to connect sql db(for example master.mdf and sql express). could not get the connection suceeded. vs2005<---> sql express 2005 help me please.
-
Dear dishandpelpola Try to do this code, Dim da As New SqlDataAdapter Dim sc As New SqlCommand Dim dt As New DataTable Dim ds As New DataSet ''''''''''Dim con As New SqlConnection("Data Source=(local);Initial Catalog=<database Name>;User ID=;pwd="...