Database

sql_con = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;");

if (File.Exists("" + info + ".db"))
           {
               sql_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=False;Compress=True;");
               sql_con.Open();
               sql_cmd = sql_con.CreateCommand();
               sql_cmd.CommandText = "drop table par ;";
               sql_cmd.ExecuteNonQuery();
           }
           else
           {
               sql_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=True;Compress=True;");

           }

          //  FileStream fileStream = new FileStream(@" " + info + ".db", FileMode.Create);


           sql_con.Open();
           sql_cmd = sql_con.CreateCommand();
           sql_cmd.CommandText = "create table par (Date nvarchar(20), Time nvarchar(10), Linein NVARCHAR(20), Lineout NVARCHAR(20), Number NVARCHAR(20), Status nvarchar(10),Duration int(20), Cost nvarchar(20), Detail nvarchar(10), Network nvarchar(10));";
           sql_cmd.ExecuteNonQuery();

Create PROCEDURE [dbo].[SelectName]<br />
	@table_name sysname,<br />
	@sName nvarchar(50)<br />
AS<br />
<br />
exec ( ' SELECT * FROM ' + @table_name + ' WHERE Name =' +  @sName  )

<br />
@table_name = 'emp'<br />
@sName = 'NameTest'<br />

<br />
Invalid column name  'NameTest'<br />