ASP.NET

Tirthadip8-Jul-07 23:25

Tirthadip

8-Jul-07 23:25

execute SQL statement.....and fill a DataSet with your information

if you use ACCESS as a database and VB.NET as your language then follow...

Dim mySql AS String="SELECT * FROM myTable"<br />
<br />
//Suppose you have a DataAdaptor(da) And DataSet(ds)<br />
Dim ds As DataSet<br />
Dim da As OleDbDataAdapter<br />
 <br />
da = New OleDbDataAdapter(mySql, myConnection)<br />
ds = New DataSet<br />
da.Fill(ds)<br />
<br />
//set DatSource of your datagrid to the dataset<br />
DataGrid1.DataSource=ds

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

$h@ma!|@8-Jul-07 23:40

8-Jul-07 23:40

well! isnt there any need to use data reader??
well my code is

//connection as conn

strQuery = " SELECT * FROM table";
SqlCommand com1 = new SqlCommand(strQuery, conn);

DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter();

SqlDataReader dr = com1.ExecuteReader();

if (dr.Read())
{

da.Fill(ds,"table");

}

its not working i mean data is not displaying in the grid..and the exception that is shown is

"The SelectCommand property has not been initialized before calling 'Fill'."

$h@ma!|@

Tirthadip9-Jul-07 0:00

Tirthadip

9-Jul-07 0:00

why are u using datareader and dataset simultaneously???
follow this...

'1. Create a connection<br />
    Dim myConnection as New SqlConnection(<br />
          ConfigurationSettings.AppSettings("connectionString"))<br />
<br />
    '2. Create the command object, passing in the SQL string<br />
    Const strSQL as String = "SELECT * FROM myTable"<br />
    Dim myCommand as New SqlCommand(strSQL, myConnection)<br />
<br />
    'Set the datagrid's datasource to the datareader and databind<br />
    myConnection.Open()<br />
    DataGrid1.DataSource = myCommand.ExecuteReader(<br />
                              CommandBehavior.CloseConnection)<br />
    DataGrid1.DataBind()

but keep in mind

A datareader is a read-only object. If you need to edit and update changes you need to use a dataset.

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

$h@ma!|@9-Jul-07 0:15

9-Jul-07 0:15

hmmmm but as i told i m working in windows application and it doesnt support databind option
is there any replacement or any directives/namespaces to include?
and what if i want to update records using dataset?

$h@ma!|@

$h@ma!|@9-Jul-07 0:54

9-Jul-07 0:54

waiting for ur answer Confused | :confused:

$h@ma!|@

Tirthadip9-Jul-07 1:05

Tirthadip

9-Jul-07 1:05

sorry shamaila I have forgotten that yours a windows application...
then you have to make a datatable with that datareader and bind it to the datagrid....

i dont see any other option for you..

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

valerian.precop9-Jul-07 1:35

valerian.precop

9-Jul-07 1:35

Here is a databind for a grid view in windows application:

//...
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string strQuery = "SELECT * FROM tableTest";
SqlCommand com1 = new SqlCommand(strQuery, conn);

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(com1);
da.Fill(ds, "table");

dataGridView1.DataSource = ds;
dataGridView1.DataMember = "table";
//...

I hope it works...it worked when I've tested it Smile | :)

$h@ma!|@9-Jul-07 22:54

9-Jul-07 22:54

thx alot it really worked Big Grin | :-D

so nice of u...and m feeling sorry as i found ur reply too late

$h@ma!|@

Include tag

Vineed8-Jul-07 22:59

8-Jul-07 22:59

I am having an ASP.Net application with aspCompat set to True. I am having a page that includes another aspx file. The application is to be hosted on the Internet with 'Enable Parent Paths disabled' i.e I cannot use '..' for referring to my root folder.

The folder structure of the application is as

RootFolder
MasterPages (Folder)
indexPage.aspx
includes (Folder)
pageInfo.aspx

I am constantly getting errors on the include tags the aspx page is having. I have used almost all combinations of include tags like

But all of these are giving me an 'include file not found error'. I have checked all the settings in IIS and I simply cannot understand what is the cause of this problem

I anyone knows what is the mistake I am making please let me know.

Regards

Vineed

N a v a n e e t h8-Jul-07 23:26

N a v a n e e t h

8-Jul-07 23:26

Vineed wrote:

I feel this is correct. But an ascx (web user controls) will be an alternative rather than including files like classic ASP style. Regarding this problem, check in IIS that all these subfolders are configured as virtual directories ? If yes remove that. Making subfolders as virtual directories and accessing files inside that from another virtual directory may cause these type of errors.

My Website | Ask smart questions

Vineed9-Jul-07 1:14

9-Jul-07 1:14

Hi navaneeth

I have checked that the sub folders are not declared as Virtual Directory, Also I am not currently interested in converting the include page into ascx as we are on a deadline and need to deliver the project in a few days time. So Can you provide me with a fast patch that can work for the time being.

Thanks for your time

Vineed

N a v a n e e t h9-Jul-07 19:02

N a v a n e e t h

9-Jul-07 19:02

Vineed wrote:
Also I am not currently interested in converting the include page into ascx

Converting include files into ascx will take only few second and I think that is better than searching for solving the current problem. More over, that won't slow you from finishing your project before deadline.

If you are planning for ascx, What you can do is, create webusercontrol. Copy all your HTML from your current include file to there. Register user control tag in your webform. That's it you are done,..

My Website | Ask smart questions

Vineed9-Jul-07 20:04

9-Jul-07 20:04

Hi Navaneeth,

Thanks for your time. I think your suggestion is good enough to be implemented.

Thanks again...

Vineed

Paddy Boyd8-Jul-07 23:28

Paddy Boyd

8-Jul-07 23:28

What type of page are you trying to include your .net pages into?

I'm not sure that you can include .aspx pages in a .asp page?

Vineed9-Jul-07 1:16

How to finde scroll bar position in javascript

9-Jul-07 1:16

Hi,

Both of these pages are .aspx pages. Actually this thing works well when the 'Enable Parent Path' of IIS is enabled.

Thanks for your time

Regards

Vineed

Piyush Vardhan Singh8-Jul-07 22:57

Piyush Vardhan Singh

8-Jul-07 22:57

How to find scroll bar position in javascript and how to lode that position after postback or page lode
help me

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Re: How to finde scroll bar position in javascript

Michael Sync8-Jul-07 23:55

Michael Sync

8-Jul-07 23:55

Please Check-out this.
Maintain Scroll Position of DIV using JavaScript - ASP.NET 2.0

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: How to finde scroll bar position in javascript

Michael Sync8-Jul-07 23:56

Michael Sync

8-Jul-07 23:56

and you can also try "SmartNavigation" turn on.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: How to finde scroll bar position in javascript

Parwej Ahamad9-Jul-07 1:01

Parwej Ahamad

9-Jul-07 1:01

Dear, Why you want to get the scroll bar position..............

Parwej Ahamad
g_parwez@rediffmail.com

GroupBy in datatable??

playout8-Jul-07 22:52

playout

8-Jul-07 22:52

Hi,

Is there a way to use groupBy in a datatable? I need to group some vaules in a column. I cannot use a sql query, as I am munipulating the data in the datatable for a gridview. I know there are no function/class available in asp.net, but maybe someone knows where to find something on the net, or had the same problem as me.

VenkataRamana.Gali8-Jul-07 23:11

VenkataRamana.Gali

8-Jul-07 23:11

Hi,

Yes, we can use aggrigate functions for DataTable. Here is the sample code. You can use group by also.

<br />
    DataTable table = dataSet.Tables["Orders"];<br />
<br />
     object sumObject;<br />
    sumObject = table.Compute("Sum(Total)", "EmpID = 5");<br />

enjoy...

regards
GV Ramana

playout8-Jul-07 23:19

playout

8-Jul-07 23:19

Thanks Ramana.

Now if I want to group on a string, how would I do that?

My columns in datatable are F2 and F3. I want to group by F2, where F3 is the primary key.

Imran Khan Pathan8-Jul-07 23:19

Imran Khan Pathan

8-Jul-07 23:19

Try this code

DataRow[] dr=DataTable.Select("gruopBy ColumnName");

Home this will help u?

Best regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES