Click here to Skip to main content
15,887,027 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Grid View DataBindings... Pin
Sasmi_Office11-Feb-10 1:53
Sasmi_Office11-Feb-10 1:53 
AnswerRe: Grid View DataBindings... Pin
R22k11-Feb-10 0:06
R22k11-Feb-10 0:06 
AnswerRe: Grid View DataBindings... Pin
Dinesh Mani11-Feb-10 0:13
Dinesh Mani11-Feb-10 0:13 
GeneralRe: Grid View DataBindings... Pin
Sasmi_Office11-Feb-10 1:54
Sasmi_Office11-Feb-10 1:54 
AnswerRe: Grid View DataBindings... Pin
Dinesh Mani11-Feb-10 2:19
Dinesh Mani11-Feb-10 2:19 
GeneralRe: Grid View DataBindings... Pin
Sasmi_Office11-Feb-10 2:41
Sasmi_Office11-Feb-10 2:41 
GeneralRe: Grid View DataBindings... Pin
PunkIsNotDead11-Feb-10 6:15
PunkIsNotDead11-Feb-10 6:15 
QuestionNotifications require SQL Server 9.0 or later Pin
sekannak10-Feb-10 22:52
sekannak10-Feb-10 22:52 
Hi,
I am trying to use the Sqlcachedependency in my application but am getting error...

step1) Enabled notification service of the database
step2) enabled notification service of the Table
step3) coding in asp.net2.0

protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
DataTable tbl1 = new DataTable();
tbl1 = (DataTable) Cache.Get("tbl");
if (tbl1 == null)
{
tbl1 = fnloadgrid();
lbl.Text = System.DateTime.Now.ToString();
}
grd.DataSource = tbl1.DefaultView;
grd.DataBind();
}
}

public DataTable fnloadgrid()
{
if (Con.State == ConnectionState.Closed)
{
Con.ConnectionString = Constr.ConnectionString;
Con.Open();
Cmd.Connection = Con;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_Select";
Cmd.Parameters.Add("@Tabid", SqlDbType.Int).Value = 1;
SqlCacheDependency Depend = new SqlCacheDependency(Cmd);
Da.SelectCommand = Cmd;
Da.Fill(Ds, "tbl");

tbl = Ds.Tables[0];
Cache.Insert("tbl", tbl, Depend);
}

return tbl;
}

note: while filling am getting error like as follows,

Notifications require SQL Server 9.0 or later.

so what is this Error ..can u clear me plz.......?

Regards,
kannak.......
kannak

AnswerRe: Notifications require SQL Server 9.0 or later Pin
Eddy Vluggen11-Feb-10 0:56
professionalEddy Vluggen11-Feb-10 0:56 
QuestionHow to access Network File In IIS? Pin
Dotnetkanna10-Feb-10 22:30
Dotnetkanna10-Feb-10 22:30 
AnswerRe: How to access Network File In IIS? Pin
Rhys Jacob10-Feb-10 23:25
Rhys Jacob10-Feb-10 23:25 
GeneralRe: How to access Network File In IIS? Pin
Dotnetkanna10-Feb-10 23:42
Dotnetkanna10-Feb-10 23:42 
GeneralRe: How to access Network File In IIS? Pin
Rhys Jacob11-Feb-10 0:02
Rhys Jacob11-Feb-10 0:02 
Questionsession is cleared Pin
R22k10-Feb-10 21:27
R22k10-Feb-10 21:27 
AnswerRe: session is cleared Pin
JustWorking10-Feb-10 21:46
JustWorking10-Feb-10 21:46 
GeneralRe: session is cleared Pin
R22k10-Feb-10 21:54
R22k10-Feb-10 21:54 
AnswerRe: session is cleared Pin
joelle@scope10-Feb-10 22:38
joelle@scope10-Feb-10 22:38 
GeneralRe: session is cleared Pin
R22k10-Feb-10 23:54
R22k10-Feb-10 23:54 
GeneralRe: session is cleared Pin
joelle@scope10-Feb-10 23:57
joelle@scope10-Feb-10 23:57 
GeneralRe: session is cleared Pin
R22k10-Feb-10 23:59
R22k10-Feb-10 23:59 
QuestionHow to open excel in asp.net??? Pin
JC.KaNNaN10-Feb-10 21:07
JC.KaNNaN10-Feb-10 21:07 
AnswerRe: How to open excel in asp.net??? Pin
saini arun10-Feb-10 21:49
saini arun10-Feb-10 21:49 
QuestionI want to add, edit and delete data from table using gridview in Asp.net? Pin
mdrizwan_110-Feb-10 20:03
mdrizwan_110-Feb-10 20:03 
AnswerRe: I want to add, edit and delete data from table using gridview in Asp.net? Pin
i gr810-Feb-10 20:26
i gr810-Feb-10 20:26 
GeneralRe: I want to add, edit and delete data from table using gridview in Asp.net? Pin
mdrizwan_111-Feb-10 4:05
mdrizwan_111-Feb-10 4:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.