Hello Friends,
i am writing a program where in i am trying to display dataset in 3 ways on the web page.
1) using a datalist.
2)using a variable.
3)using a datagrid.


the code is as follows:

private void Page_Load(object sender, System.EventArgs e)
{
    if(this.IsPostBack==false)
    {
     try
     {
    SqlConnection myconn= new SqlConnection(strconn);
    string mySql="select insertdata.fname, insertdata.lname,
        insertdata.************, insertdata.position from insertdata";

    DataSet Ds= new DataSet();
    SqlDataAdapter Adinsert=new SqlDataAdapter(mySql, myconn);
    Adinsert.Fill(Ds, "insertdata");

    //The next 2 lines assign the data in the dataset to Datalist
    datalist.DataSource=Ds.Tables["insertdata"].DefaultView;
    datalist.DataBind();

    //These lines assign the data to a variable and again
        //assign it to the text property of literal control
    foreach(DataRow dr in Ds.Tables)
    {
        sEmp += "<b>" + dr["firstname"] + " " + dr["lastname"]
            + "</b> - " + dr["************"] + "" + dr["position"] + "<br>" ;
    }
    Literalprg.Text = sEmp;


    //then, here we assign the data to a DataGrid,
        //much like the way we did in the example for the DataList dginsertdata.Datasource=Ds.Tables
           ["insertdata"].DefaultView ;

    dginsertdata.DataBind();

        } //try

    catch(SqlException ex)
    {
        lblexec.Text =ex.Message;
    }

    catch(Exception ex)
    {
        lblexec.Text =ex.Message;
    }
  } //if
} //pageload



now, i am getting error at 2 places right now :
1) in the foreach loop ====> Specified cast is not valid
2) the following line where i am using datagrid :
dginsertdata.Datasource=Ds.Tables["insertdata"].DefaultView ;
 and the error is ===>
'System.Web.UI.WebControls.DataGrid' does not contain a definition for 'Datasource'

cud anyone plz help me out.

thanx and regards,
muskaan. :)

Hi,

'dginsertdata.Datasource' should be 'dginsertdata.DataSource'

Prashant

HI,

I think you got It, 'S' should be caps

Prashant

hi,

Sorry I missed the first one

foreach(DataRow dr in Ds.Tables)

should be

"foreach(DataRow dr in Ds.Tables[0].Rows)"

Thanks a lot prashant.
now i the program is displaying dataset using datagrid and variable.
but not displaying dataset using datalist.
i dont know whts the prb.
cud u plz help me out.

thanks and regards,
muskaan.

hi,

The datalist does not has a an autogenerate freature as the datagrid, so you must create the nessary templates/columns...
Check whether you have done this.

Prashant

hi prashant,
thanx but cud u plz tell me how do i create it?

muskaan.

hi,

See the example in MSDN

you can get mmore info from
http://msdn.microsoft.com/library/de...ClassTopic.asp

Thanks Prashant.
i'll do that.
and incase of any prb, i'll let u know.

Regards,
Muskaan. :)

Hi Prashant,
i am sorry to trouble to u again.
But am not getting how to use the datalist.
DO i have to drag and drop the controls over it?
Or do i have do that thru coding?
or thru the HTML code?

Plz explain with a small example.

Thanks and regards,
Muskaan.