无法使用jquery ajax ASP.NET webforms从数据库加载数据 [英] Can't load data from database using jquery ajax ASP.NET webforms
问题描述
我要从数据库加载推文但它不起作用请检查我在哪里做错了
这是我要加载推文的div
< div id = load_tweets >
< / div > ;
这是就绪功能中的setinterval方法
setInterval( function (){
$(' #load_tweets')。load( CS。 aspx / fetch)。fadeIn( slow);
}, 1000 );
和这是fetch [webMethod]
[System.Web.Services.WebMethod]
public static DataTable fetch()
{
SqlConnection con = new SqlConnection( data source = dbcomments; initial catalog = CommentSystemUsingAjax; integrated security = true 跨度>);
SqlDataAdapter da = new SqlDataAdapter( select *来自tbl_tweet的订单,来自tweet_id desc,con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
我也尝试过这种方式
[System.Web.Services.WebMethod]
public static string fetch( string tweet)
{
SqlConnection con = new SqlConnection( data source = dbcomments ; initial catalog = CommentSystemUsingAjax; integrated security = true);
SqlDataAdapter da = new SqlDataAdapter( select *来自tbl_tweet的订单,来自tweet_id desc,con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0 )
{
tweet = dt.Rows [ 0 ] [ tweet]。ToString();
}
返回推文;
}
请帮帮我 < br $> b $ b
我尝试过:
< script type =text / javascript>
$(凭证).ready(function(){
$('#btn_tweet')。click(function(){
$ .ajax({
类型:POST,
url:CS.aspx / Hello,
数据:'{tweet:'+ $( #<%= tweet.ClientID%>)[0] .value +'}',
contentType:application / json; charset = utf-8,>
dataType:json,
成功:函数(数据){
$('#tweet')。 val();
alert(ok);
}
});
setInterval(function(){
$('#load_tweets')。load (/CS.aspx.aspx/fetch\").fadeIn(\"slow);
},1000);
});
(' #load_tweets')。load( CS.aspx / fetch)。fadeIn( slow);
}, 1000 );
和这是fetch [webMethod]
[System.Web.Services.WebMethod]
public static DataTable fetch()
{
SqlConnection con = new SqlConnection( data source = dbcomments; initial catalog = CommentSystemUsingAjax; integrated security = true 跨度>);
SqlDataAdapter da = new SqlDataAdapter( select *来自tbl_tweet的订单,来自tweet_id desc,con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
我也尝试过这种方式
[System.Web.Services.WebMethod]
public static string fetch( string tweet)
{
SqlConnection con = new SqlConnection( data source = dbcomments ; initial catalog = CommentSystemUsingAjax; integrated security = true);
SqlDataAdapter da = new SqlDataAdapter( select *来自tbl_tweet的订单,来自tweet_id desc,con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0 )
{
tweet = dt.Rows [ 0 ] [ tweet]。ToString();
}
返回推文;
}
请帮帮我 < br $> b $ b
我尝试过:
< script type =text / javascript>
(document).ready(function(){
('#btn_tweet')。click(function(){
I'm gonna load tweet from database but it doesn't work please check where i'm doing mistake
This is the div where i want to load tweets
<div id="load_tweets">
</div>
This is the setinterval method inside ready function
setInterval(function () {
$('#load_tweets').load("CS.aspx/fetch").fadeIn("slow");
},1000);
And This is fetch [webMethod]
[System.Web.Services.WebMethod]
public static DataTable fetch()
{
SqlConnection con = new SqlConnection("data source=dbcomments;initial catalog=CommentSystemUsingAjax;integrated security=true");
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_tweet order by tweet_id desc", con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
And i also tried this way
[System.Web.Services.WebMethod]
public static string fetch(string tweet)
{
SqlConnection con = new SqlConnection("data source=dbcomments;initial catalog=CommentSystemUsingAjax;integrated security=true");
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_tweet order by tweet_id desc", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
tweet = dt.Rows[0]["tweet"].ToString();
}
return tweet;
}
Please help me
What I have tried:
<script type="text/javascript">
$(document).ready(function () {
$('#btn_tweet').click(function () {
$.ajax({
type: "POST",
url: "CS.aspx/Hello",
data: '{tweet: "' + $("#<%=tweet.ClientID%>")[0].value + '" }',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
$('#tweet').val("");
alert("ok");
}
});
setInterval(function () {
$('#load_tweets').load("/CS.aspx.aspx/fetch").fadeIn("slow");
}, 1000);
});
('#load_tweets').load("CS.aspx/fetch").fadeIn("slow"); },1000);
And This is fetch [webMethod]
[System.Web.Services.WebMethod] public static DataTable fetch() { SqlConnection con = new SqlConnection("data source=dbcomments;initial catalog=CommentSystemUsingAjax;integrated security=true"); SqlDataAdapter da = new SqlDataAdapter("select * from tbl_tweet order by tweet_id desc", con); DataTable dt = new DataTable(); da.Fill(dt); return dt; }
And i also tried this way
[System.Web.Services.WebMethod] public static string fetch(string tweet) { SqlConnection con = new SqlConnection("data source=dbcomments;initial catalog=CommentSystemUsingAjax;integrated security=true"); SqlDataAdapter da = new SqlDataAdapter("select * from tbl_tweet order by tweet_id desc", con); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { tweet = dt.Rows[0]["tweet"].ToString(); } return tweet; }
Please help me
What I have tried:
<script type="text/javascript">
(document).ready(function () {
('#btn_tweet').click(function () {
这篇关于无法使用jquery ajax ASP.NET webforms从数据库加载数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!