public class DataClass
{
public DataClass()
{
}
/// <summary>
/// return rows depend on position
/// if you need 10th to 20th you need to pass start=10 and end=20
/// </summary>
/// <param name="start">database start position of one row</param>
/// <param name="next">database end position of one row</param>
/// <returns></returns>
public string GetAjaxContent(int start, int end)
{
string result = string.Empty;
//adding sp params with values in Dictionary entry.
Dictionary<string, object> keyValPair = new Dictionary<string, object>();
keyValPair.Add("@start", start);
keyValPair.Add("@next", end);
DBHelper DBHelper = new DBHelper();
//passing the Stored Procedure name and keyvalue pair
DataTable dataTable = DBHelper.GetTable("spuserdata", keyValPair);
if (dataTable.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
result += string.Format(@"<tr>
<td>
<table>
<tr>
<td style='width:50px;'>{0}</td><td style='width:400px;'>{1}</td><td style='width:150px;'>{2}</td>
</tr>
</table>
</td>
</tr>", dataTable.Rows[i][0].ToString(), dataTable.Rows[i][1].ToString(), dataTable.Rows[i][2].ToString());
}
}
//this string is going to append on Datalist on client.
return result;
}
/// <summary>
/// function to bind data on page load
/// </summary>
/// <returns></returns>
public DataTable FirstTenRecords()
{
Dictionary<string, object> keyValPair = new Dictionary<string, object>();
keyValPair.Add("@start", 0);
keyValPair.Add("@next", 10);
DBHelper DBHelper = new DBHelper();
DataTable dataTable = DBHelper.GetTable("spuserdata", keyValPair);
return dataTable;
}
}
/// <summary>
/// return sqlconnection string formweb.config file
/// </summary>
public class Provider
{
public static SqlConnection GetConnection()
{
// return new SqlConnection(ConfigurationManager.AppSettings["conn"]);
return new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
}
}
/// <summary>
/// Data layer
/// </summary>
public class DBHelper
{
public DBHelper()
{
}
public DataTable GetTable(string spuserdata, Dictionary<string, object> SPParamWithValues)
{
string id = System.Web.HttpContext.Current.Session.SessionID;
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand("con");
SqlDataAdapter adapter = new SqlDataAdapter();
cmd.Connection = conn;
DataTable table = new DataTable();
// conn = Provider.GetConnection();
using(var con =Provider.GetConnection() )
using (var comd = new SqlCommand(spuserdata, conn)) using (var da = new SqlDataAdapter(comd))
{
comd.CommandType = CommandType.StoredProcedure;
foreach(var keyValue in SPParamWithValues)
{
comd.Parameters.Add(keyValue.Key, SqlDbType.Int).Value = keyValue.Value;
}
da.Fill(table);
}
return table;--connection string is not intilaized
}
Hai all,when i'm trying to develop the unlimited scrolling in datalist i have an error like connection string not intialized i checked and rechecked but i didn't get the solution i spend lots of time on this but i dont understand why this happens.can any one help me
Thanks and Regards
