TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
aditya immadi
NA
205
71.6k
Conversion failed when converting the nvarchar value 'xty1kq
Sep 25 2013 3:36 PM
Hai Al,
when i'm developing unlimted scroll down ,i have facing the fallowing errrors.(i'm highlighting those)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace holdurl
{
public partial class home : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string id = System.Web.HttpContext.Current.Session.SessionID;
if (Session["id"] != null)
{
mydb db = new mydb();
//Fetch 14 records initially.
DataSet dsProducts = db.GetProducts();
//Bind data to gridview
dl.DataSource = dsProducts;
dl.DataBind();
}
}
protected void btnGetMoreRecords_Click(object sender, EventArgs e)
{
mydb db = new mydb();
//Fetch 5 records initially.
DataSet dsProducts = db.FetchNextProducts(Convert.ToInt32(hiddenLastProductID.Value), 5);
i think i'm missing something about this line ,i'm not able to solve it.
dl.DataSource = dsProducts;
dl.DataBind();
}
public class mydb
{
private SqlConnection con;
public mydb()
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
}
public DataSet GetProducts()
{
string id = System.Web.HttpContext.Current.Session.SessionID;
SqlCommand cmd = new SqlCommand("select top 5 decription,url from tb_userdata inner join tb_userlogin on tb_userdata.uidfromtb1=tb_userlogin.id where tb_userlogin.id=@id", con);
cmd.Parameters.AddWithValue("@id", id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
Conversion failed when converting the nvarchar value 'xty1kq00oktl2omikmznuqle' to data type int.
}
public DataSet FetchNextProducts(int id, int recordsCount)
{
// string id = System.Web.HttpContext.Current.Session.SessionID;
string query = string.Format("select top {0} * from tb_userdata inner join tb_userlogin on tb_userdata.uidfromtb1=tb_userlogin.id where tb_userlogin.id=@id ASC", id);
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", id);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
return ds;
}
public object id { get; set; }
}
protected void btngoto_Click(object sender, EventArgs e)
{
Response.Redirect("userdata1.aspx");
}
}
}
can any one help me out
Thanks and Regards
Reply
Answers (
1
)
updating mysql database in c#.net mvc4
Disable Background Controls in Multiple Frames When Alert.