ASP.NET

18-Jun-07 1:22

Hi,

I created a datatable(provided schema). Now i would retrieve some rows from database and store it in a dataset. Now the rows in the dataset should be added to the data table. I have used:

foreach(DataRow dr in DataSet.Tables[0])
{
datatable1.ImportRow(dr);
}

However when iam trying to bind this data table to datagird that is throwing an error: DataBinder.Eval: DataRow property ........

Any ideas are immensely respected.

Gautham

RepliCrux18-Jun-07 1:31

18-Jun-07 1:31

Gautham,

You don't need to import rows in this case. All you need to do is assign the table:

DataTable dataTable1 = DataSet.Tables[0];

This will work for sure.

gauthee18-Jun-07 1:46

18-Jun-07 1:46

Thanks for the reply!

However, there would be chances where my datatable might have few rows initially, now the rows from the databse should be added to existing rows of the datatable.

That was the reason i have used import row

Gautham

RepliCrux18-Jun-07 1:52

18-Jun-07 1:52

If you are using DataSet to get the data from the database you might as well want to make the datasource as:

private void BindData()
{
dataGrid1.DataDource = DataSet.Tables[0];
dataGrid1.DataBind();
}

This way when new rows are added, as soon as the dataset it updated, just call the BindData() method and the grid will refresh.

gauthee18-Jun-07 1:58

18-Jun-07 1:58

Hi,

Let me enunciate a bit further that would be useful in identifying my concern.

Now the user, would enter few details on a web page and would click 'Add', the details would be orderno, date, etc etc.

The moment he clicks the add we have to display few details in a grid according to the orderno entered, this order info is being retrieved from the database.

So if the user is clicking add button 10 times 10 records should be displayed in the datagrid and all 10 times i would go the databse and get the order info.

This is the reason i created a datatable and bound it with a datagrid. when ever a new order is being added that info should be added to the datatable and finally show in a datagrid!

Hoping i was clear!

Gautham

Chetan Ranpariya18-Jun-07 2:49

Chetan Ranpariya

18-Jun-07 2:49

HI,

Your code should look like as following.

foreach ( DataRow row in dst.Tables[0].Rows )
{
dt.ImportRow( row );
}

Try this.

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

gauthee18-Jun-07 3:17

18-Jun-07 3:17

Chetan,

Actually i did the same thing but the following error is being thrown:

DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name OrderId

Gautham

Control 'RequiredFieldValidator1' of type 'RequiredFieldValidator' must be placed inside a form tag with runat=server.

Chetan Ranpariya18-Jun-07 3:20

Chetan Ranpariya

18-Jun-07 3:20

Hi,

This is not the code error. It happens because u might have given wrong column name or both of your tables dont have the same columnnames and same number of columns and the same order of columns.

Check for that once.

Thanks and Regards,
Chetan Ranpariya

Hemant Garg18-Jun-07 1:11

Re: Control 'RequiredFieldValidator1' of type 'RequiredFieldValidator' must be placed inside a form tag with runat=server.

18-Jun-07 1:11

Hello to every one,
What this error means and how to solve this error...

"Control 'RequiredFieldValidator1' of type 'RequiredFieldValidator' must be placed inside a form tag with runat=server. "

Sylvester george18-Jun-07 1:15

Sylvester george

18-Jun-07 1:15

that means you need to add this attribute (runat=server) in your control.

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: Control 'RequiredFieldValidator1' of type 'RequiredFieldValidator' must be placed inside a form tag with runat=server.

RepliCrux18-Jun-07 1:16

Re: Control 'RequiredFieldValidator1' of type 'RequiredFieldValidator' must be placed inside a form tag with runat=server.

18-Jun-07 1:16

Go to the "Source" of your aspx file and add 'runat = "server"' tag to the RequiredFieldValidator. That should fix the problem.

manojch218-Jun-07 1:16

manojch2

18-Jun-07 1:16

The form tag missing from your code.
the RequiredFieldValidator must be inside the form tag
Like

Place your Html and valdation related code here

manojchilhate

Re: Control 'RequiredFieldValidator1' of type 'RequiredFieldValidator' must be placed inside a form tag with runat=server.

Hemant Garg18-Jun-07 2:22

Ordering an asp.net Listbox

18-Jun-07 2:22

Thank you

Senseicads18-Jun-07 0:44

Senseicads

18-Jun-07 0:44

hi
Looking for a bit of help. I have an asp.net listbox. I am wanting to manually be able to order the box by clicking a button. got everything set up but I keep getting an error saying that I can't have multiple selections on the list box when it is set as a single selection. I don't really know where I am going wrong so if anyone can help me I would most appreciate it. My code for the button click is as follows.

Protected Sub btOrderElementUp_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btOrderElementUp.Click<br />
        If ltbOrderByList.Items.Count() = 0 Or ltbOrderByList.Items.Count() = 1 Then<br />
            Exit Sub<br />
        End If<br />
<br />
        Dim liItem As ListItem<br />
        Dim intItemIndex As Integer<br />
<br />
        liItem = ltbOrderByList.SelectedItem<br />
        intItemIndex = ltbOrderByList.SelectedIndex<br />
        ltbOrderByList.Items.Insert(intItemIndex - 1, liItem)<br />
        ltbOrderByList.Items.RemoveAt(intItemIndex)<br />
        ltbOrderByList.ClearSelection()<br />
        ltbOrderByList.SelectedIndex = intItemIndex - 1<br />
        <br />
    End Sub

The last two lines are my attempt to manually set the selected item so multiple items definitly aren't selected. If there is an easier way of doing this I would also appreciate it if you could tell me too! Big Grin | :-D

Cheers

Ian

Re: Ordering an asp.net Listbox

Sylvester george18-Jun-07 1:02

Sylvester george

18-Jun-07 1:02

try this instead of

Senseicads wrote:
ltbOrderByList.ClearSelection()
ltbOrderByList.SelectedIndex = intItemIndex - 1

ltbOrderByList.Items[ltbOrderByList.SelectedIndex].Selected = false;
ltbOrderByList.SelectedIndex = intItemIndex - 1

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: Ordering an asp.net Listbox

Senseicads18-Jun-07 1:12

Senseicads

18-Jun-07 1:12

Thanks

I was able to just set the selected to true after my clearselection. Thanks for the help.

<br />
ltbOrderByList.ClearSelection()<br />
ltbOrderByList.Items(intItemIndex - 1).Selected = True

So is it not possible to use selectedIndex like I was attempting to then? The intellisense says that SelectedIndex is used to "get or set" the index of the selected item?

cheers

Ian

How to Declare a variable which is static and also global in vb

Hemant Garg18-Jun-07 0:42

Re: How to Declare a variable which is static and also global

18-Jun-07 0:42

Hello To Everyone,
i want to declare a static variable in Asp.net which sholud also be a global variable.
Fr eg. i declared
static name as string
but when i declare it general section it gives me an error.
if i use public then i 'm unable to make it static variable

-- modified at 6:51 Monday 18th June, 2007

RepliCrux18-Jun-07 0:50

Re: How to Declare a variable which is static and also global

18-Jun-07 0:50

Create a static class

static MyClass
{
public static string _MyString;
}

you can access the above using the following:

String s = MyClass._MyString;

Hemant Garg18-Jun-07 1:00

Re: How to Declare a variable which is static and also global in vb

18-Jun-07 1:00

hello,
thanx but i need to code in vb..
could u help me out

RepliCrux18-Jun-07 0:59

Re: How to Declare a variable which is static and also global in vb

18-Jun-07 0:59

In VB you can say "Shared" instead of "static".

Hemant Garg18-Jun-07 1:02