ASP.NET Discussion Boards

rachitdamani9-Apr-07 20:01

9-Apr-07 20:01

HI All,

I have a requirement where I need to select first N rows from DataView.

So how could i achieve this?

Thanks,
Rachit Damani.

Re: Selecting first N rows in DataView

enjoycrack9-Apr-07 20:09

enjoycrack

9-Apr-07 20:09

use SELECT TOP N...

<< >>

8x Solutions Ltd

Re: Selecting first N rows in DataView

rachitdamani9-Apr-07 20:16

rachitdamani

9-Apr-07 20:16

Thanks for your reply

but how i could use select query in dataview?

i don't need to select top N rows when i am fetching the data from the database but at some point of time i need to select top N rows from dataview which contains all the data.

so is it possible to use select query in dataview?

Thanks,
Rachit Damani.

Re: Selecting first N rows in DataView

enjoycrack9-Apr-07 20:24

enjoycrack

9-Apr-07 20:24

for this...you can loop thru the dataview to get the top n records
Or better: Add a column on the datatable, set it's autoincrement value, include it in
the rowfilter for the dataview

Hope you get the idea

<< >>

8x Solutions Ltd

Re: Selecting first N rows in DataView

rachitdamani9-Apr-07 20:26

rachitdamani

9-Apr-07 20:26

ya thanks,

now i have understood what i need to do

thanks a lot

Rachit Damani.

How to add an item to asp:listbox in clientside?

.NetRams9-Apr-07 19:35

.NetRams

9-Apr-07 19:35

Hi,
How could I add an item to asp:listbox in clientside using javascript.

Thanks in advance.

Be simple and Be sample.

Re: How to add an item to asp:listbox in clientside?

Mark Greenwood9-Apr-07 20:36

Mark Greenwood

9-Apr-07 20:36

<code>
<body>
<form id="form1" runat="server">

<asp:ListBox ID="ListBox1" runat="server"></asp:ListBox>
</form>
<script>
var listBox = document.getElementById( '<%= ListBox1.ClientID %>' );
alert(listBox.length);
listBox.options[0] = new Option("Hello");
alert(listBox.length);
</script>
</body>
</code>

Like this.......

Note that there is no ADD item as such that work cross browser, you have to get the number of items currently there and then add new ones by changing the index (the options[indexnumber] above).

Mark.

closing frameset

Sebastian T Xavier9-Apr-07 19:12

Sebastian T Xavier

9-Apr-07 19:12

Hi,

I have a frameset(in default.aspx) with two vertical panes. In the left pane i have added "default1.aspx" and in the right pane i have added "default2.aspx". It works fine with the following code..

<frameset cols="*,*" frameborder="NO" border="0" framespacing="0">

<frame src="default1.aspx" name="leftFrame" scrolling="no" style="border:1px solid #99ABBD" >

<frame src="default2.aspx" name="rightFrame" scrolling="no" style="border:1px solid #99ABBD" >

</frameset>

I was trying to close the window(frameset) with the following code

Window.close();

But it doesn't works, can anyone tell me how to close a window(with frameset) programatically.

Thanking you

Sebastian

Re: closing frameset

Mykola Tarasyuk9-Apr-07 22:41

Mykola Tarasyuk

9-Apr-07 22:41

Hi,
First of all, JavaScript is case sensitive, therefore - window.close();
Second, you can close only the window you opened from the code. Otherwise, you will be asked to confirm the action (IE) or will be ignored (FF 2.0). There is a trick to avoid the confimation in IE:

...
window.opener = self;
window.close();

but it seems to me that in IE 7.0 it does not work anymore (not sure).

If you are in a frame you can refer to the topmost window (the window that contains the frameset) via top property:
window.top.close();

.net roadmap

bigeyed9-Apr-07 19:02

bigeyed

9-Apr-07 19:02

i'm planning to make a .net roadmap for my new comming employees.
i know it's too broad to start and this is why i need help.
i wanna make a roadmap that can be used for people are frosh in this industry.
i havn't started yet, but probably it will have to contain what courses to take, what catagories should be educated, what concept to understand,,,etc.

does any one has any kind of resources, documents, or references??
please let me know...it will be helpful.
thanks.

ASP Count current use online

Socheat.Net9-Apr-07 17:20

Socheat.Net

9-Apr-07 17:20

I want to count current use online with asp, please help me.
Thanks

................

Re: ASP Count current use online

enjoycrack9-Apr-07 20:37

enjoycrack

9-Apr-07 20:37

just give my idea..as i am not familiar with asp
- store the counter in application variable
- increasing the counter when an user log into your site

<< >>

8x Solutions Ltd

Re: ASP Count current use online

PavanPareta9-Apr-07 21:11

PavanPareta

9-Apr-07 21:11

In Global.asax File.

void Application_Start(object sender, EventArgs e) 
    {
        Application["UserCount"] = Application["UserCount"] + 1;
    }

In home.aspx File.
page load event

Response.Write("Application["UserCount"]");

Pavan Pareta

Mask Control for ASP.NET

LarisaL9-Apr-07 17:16

LarisaL

9-Apr-07 17:16

I have problem with input data into ASP.NET application.
I found mask control only for Windows form but I did not find anything for ASP.Net.
Maybe somebody can help me.
Thank you.
LL

Re: Mask Control for ASP.NET

Kunal P9-Apr-07 18:32

Kunal P

9-Apr-07 18:32

try this... htis one masks the time..
Mask control

you may also use the AJAX ASP.net control toolkit...
hope it helps..

Kunal

how to retrieve multiple data from sql database and store in variables

neodeaths9-Apr-07 16:15

neodeaths

9-Apr-07 16:15

hi guys i would like to learn how to retrive data from sql database and stored in multiple variables.

so far i learned executescaler which retrieve the 1st row,1st col data and store it in the specified variable.

so how can i select multiple row,col and store them?

i understand some of the steps are :

SqlConnection conn = new SqlConnection((ConfigurationManager.ConnectionStrings["HASDBConnectionString1"]).ToString());

SqlCommand sc = new SqlCommand("SELECT Name,age,add FROM STUDENT", conn);

sc.ExecuteNonQuery();

................<== from here on in i dont know

please guild me in my learning tour thx

Re: how to retrieve multiple data from sql database and store in variables

Not Active9-Apr-07 16:55

Not Active

9-Apr-07 16:55

It would not be an ExecuteNonQuery, that is more for update or insert statements, a command that does not return data.

Try reseaching the ExecuteReader method

only two letters away from being an asset

need help: validation of date

neodeaths9-Apr-07 16:07

neodeaths

9-Apr-07 16:07

<asp:Label ID="Label2" runat="server"<br />
BorderStyle="None" Width="80px"<br />
Text="date:" /><br />
<asp:TextBox ID="txtdate" runat="server" /><br />
 <br />
<asp:RequiredFieldValidator<br />
ID="RequiredFieldValidator2" runat="server"<br />
ControlToValidate="txtdate"<br />
ErrorMessage="Required." /><br />
<br />