Click here to Skip to main content
15,915,739 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Image transparent in Asp.Net Pin
i gr811-Feb-10 1:35
i gr811-Feb-10 1:35 
GeneralRe: Image transparent in Asp.Net Pin
koncuk11-Feb-10 1:38
koncuk11-Feb-10 1:38 
GeneralRe: Image transparent in Asp.Net Pin
Anurag Gandhi11-Feb-10 1:53
professionalAnurag Gandhi11-Feb-10 1:53 
QuestionGrid View DataBindings... Pin
Sasmi_Office10-Feb-10 23:58
Sasmi_Office10-Feb-10 23:58 
AnswerRe: Grid View DataBindings... Pin
Gaurav Dudeja India11-Feb-10 0:04
Gaurav Dudeja India11-Feb-10 0:04 
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 

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.