Sri Lanka .NET Forum
a mission and a vision with .NET

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • SQL Injection (When it comes to Stored Procedures)

    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...
    Posted to SQL Server (Forum) by Valluvan on 11-12-2009
  • Re: Count years by adding integers - SQL Date ?

    Hi amila, Simply use t-sql DATEADD function. http://msdn.microsoft.com/en-us/library/ms186819.aspx Cheers!
    Posted to SQL Server (Forum) by nilhan on 06-19-2009
  • ODBC Connection For C# Developers

    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
    Posted to SQL Server (Forum) by Aromatic Place on 06-15-2009
  • Re: Default escape character in MySQL

    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...
    Posted to SQL Server (Forum) by nilhan on 06-06-2009
  • Re: Searching strings in regardless of the language

    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....?
    Posted to ASP.NET, AJAX, Silverlight (Forum) by SAP on 02-16-2009
  • Re: How to do Transaction Lock

    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...
    Posted to SQL Server (Forum) by SAP on 01-08-2009
  • Re: connecting sql db

    please go through the picture in the first post. getting error 32 and 40.
    Posted to .NET Overall (Forum) by ijas1981 on 10-13-2008
  • Re: connecting sql db

    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...
    Posted to .NET Overall (Forum) by ijas1981 on 10-13-2008
  • connecting sql db

    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.
    Posted to .NET Overall (Forum) by ijas1981 on 10-11-2008
  • Re: select command code 2

    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="...
    Posted to .NET Overall (Forum) by Hasraj on 10-07-2008
Page 1 of 3 (25 items) 1 2 3 Next >
This space is available for you to advertise. Please contact admin@dotnetforum.lk for more details on how to advertise on the .NET Forum.
Copyright © Sri Lanka .NET Forum. All Rights Reserved. Terms of Use | Privacy Policy