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
elsit jose
NA
7
2.7k
I getting output of table as two table in a line.
Mar 25 2015 4:32 AM
namespace DataAccessLayer
{
public class clsDL
{
string conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
public object ExecuteSqlString(string sqlstring)
{
SqlConnection objsqlconn = new SqlConnection(conn);
objsqlconn.Open();
DataSet ds = new DataSet();
SqlCommand objcmd = new SqlCommand(sqlstring, objsqlconn);
SqlDataAdapter objAdp = new SqlDataAdapter(objcmd);
objAdp.Fill(ds);
return ds;
}
public object LoadCustomerDB()
{DataSet ds = new DataSet();
string sql = "SELECT * from tbl_Customer order by CustID";
ds = (DataSet)ExecuteSqlString(sql);
return ds;
}
}
}
this is my data layer..
protected void Page_Load(object sender, EventArgs e)
{
objLogic = new clsBL();
GridView1.DataSource = objLogic.LoadCustomer();
GridView1.DataBind();
}
this is mu default aspx page
namespace BussinessLayer
{
public class clsBL
{
public clsDL objDataLayer = new clsDL();
public object LoadCustomer()
{
return objDataLayer.LoadCustomerDB();
}
}
this is my business layer
how should i get my single data
Reply
Answers (
5
)
Crystal Reports :: Missing Some Table Fields In Field Explor
Drad and drop in asp.net using J-Query