using System;
using System.Data;
using System.Data.SqlClient;
namespace rajshekar.include
{
public class database
{
private static database NewDataBase;
private string connectionString =
"Connection String";
//Return Total Number of Record in strsql Query
public int ReturnRecordCount(string
strsql)
{
SqlDataAdapter DataAdapter = new SqlDataAdapter(strsql,connectionString);
DataSet DataSet1 = new DataSet();
DataAdapter.Fill(DataSet1,"AnyName");
DataTable dataTable = DataSet1.Tables[0];
return dataTable.Rows.Count;
}
//This
Function is used for inserting Data in database through Strsql
Query
//It
return 1 if query executed successfully otherwise return 0.
public int InsertRow(string
mySQLQuery)
{
//
If the connection string is null, use a default.
try
{
SqlConnection myConnection = new SqlConnection(connectionString);
string myInsertQuery = mySQLQuery;
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
catch
{
return 0;
}
return 1;
}
//This
function is used for returning executed query data via data table.
public DataTable ReturnRecordset(string strsql)
{
SqlDataAdapter DataAdapter = new SqlDataAdapter(strsql,connectionString);
DataSet DataSet1 = new DataSet();
DataAdapter.Fill(DataSet1,"Login");
DataTable dataTable = DataSet1.Tables[0];
return dataTable;
}
//Constructor of database
public database()
{
//
only self instantiate
}
//This
is used for creating an instance of class database
public static database NewDataBase1
{
get
{
if(DBStore == null)
NewDataBase = new database();
return NewDataBase;
}
}
//this
is used for returning of setting connectionString
value
public string ConnectionString
{
get
{
return connectionString;
}
set
{
connectionString = value;
}
}
}
}
