Re: binding data to datagrid - ASP.NET Discussion Boards

Re: java script error

Sonia Gupta9-Jul-07 0:31

Sonia Gupta

9-Jul-07 0:31

i am using 2005 .

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Re: java script error

Piyush Vardhan Singh9-Jul-07 0:48

Piyush Vardhan Singh

9-Jul-07 0:48

jase lika hun wase likhna ok

function validation()
{
if(document.form1.TextBox1.value=="")
{
alert("please fill it");
}
else
{
alert(document.Form1.TextBox1.value);
}
}

page lode pe

Button1.Attributes.Add("onclick", "return validation();")

(case sensitive ka dikat tha dear)

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Re: java script error

Piyush Vardhan Singh9-Jul-07 0:59

Piyush Vardhan Singh

9-Jul-07 0:59

have u done

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Re: java script error

Imran Khan Pathan9-Jul-07 0:17

Imran Khan Pathan

9-Jul-07 0:17

HI.

U can use
Button.Attributes.Add("onClick","function();");
but out of Ispostback

U can also call javascript function by onclientClick event in source code

If u call by Onclientclick plz remove code from codebehind file.
Best Regard
Pathan

GOD HELP THOSE WHO HELP THEMSELVES

binding data to datagrid

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

$h@ma!|@

8-Jul-07 23:07

in windows apllication, i want to select table's data and show it in datagrid
but i dont undertand how will i bind the data
is there any way to use datagrd view manager or something like this????
m confused!!! Frown | :(

$h@ma!|@

Re: binding data to datagrid

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

Re: binding data to datagrid

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

$h@ma!|@

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!|@

Re: binding data to datagrid

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

Re: binding data to datagrid

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

$h@ma!|@

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!|@

Re: binding data to datagrid

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

$h@ma!|@

9-Jul-07 0:54

waiting for ur answer Confused | :confused:

$h@ma!|@

Re: binding data to datagrid

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

Re: binding data to datagrid

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 | :)

Re: binding data to datagrid

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

$h@ma!|@

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

Vineed

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

Re: Include tag

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

Re: Include tag

Vineed9-Jul-07 1:14

Vineed

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

Re: Include tag

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

Re: Include tag

Vineed9-Jul-07 20:04

Vineed

9-Jul-07 20:04

Hi Navaneeth,

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

Thanks again...

Vineed

Re: Include tag

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?

Re: Include tag

Vineed9-Jul-07 1:16

Vineed

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

How to finde scroll bar position in javascript

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.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.