public class Dal
{
public SqlConnection connection()
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Database=Manager_db; Integrated Security=true;");
return conn;
}
}
in another class i have the method to select colums from my database:
public SqlDataReader fillrecentchanges()
{
SqlConnection conn = databaseobj.connection();
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT TOP 3 FROM Manager_tb", conn);
SqlDataReader rdr = cmd.ExecuteReader();
return rdr;
}
How do i list the 3 first entry in a webform under each other without columnames?
// Jesper
Jignesh TrivediPosted Feb 7, 2013, 1:21 AM
hi,
you may also use Data Adapter and Data set to retreive data from database.
like....
DataSet dataSet = new DataSet();
SqlConnection con = new SqlConnection("connection string");
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("SELECT TOP 3 FROM Manager_tb", con);
adp.Fill(dataSet);
now you may bind this dataset to dropdown or grid or other control that support databing.
hope this will help you.
Satyapriya NayakPosted Feb 6, 2013, 9:35 AM
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Sum
{
public partial class WebForm1 : System.Web.UI.Page
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand com;
string str;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindgrid();
}
}
private void bindgrid()
{
SqlConnection con = new SqlConnection(connStr);
con.Open();
str = "SELECT TOP 3* FROM Manager_tb";
com = new SqlCommand(str, con);
SqlDataReader reader;
reader = com.ExecuteReader();
GridView1.DataMember = "Manager_tb";
GridView1.DataSource = reader;
GridView1.DataBind();
con.Close();
}
}
}