Search Result

Hi,

I use Visual studio datasets to create table adapters etc. for queries. This normally works fine for me with 'simple' queries (i.e. only 1 parameter of type string, int ...). However if I specify the following query in the dataset:

SELECT * from tblTable WHERE tblId IN (@idList)

the query editor accepts, but the generated code will create a function that just accepts a single integer. Changing the...

Problem: create a new winform app in C# VS2008.
Drop a PropertyGrid component, Drop a DataSet (untyped)
Set the PropertyGrid.Se lectedObject to the DataSet.
Run the application, and try to select the table editor.
Can not bring up the tables collection editor

Drop a DataGridView, set the PropertyGrid.Se lectedObject to the DataGridView.
Can not access the Columns collection.

A little...

I am preparing a crystal report for library system...
two tables..

1)BookIssueDeta il:

fields : grno ,bookno,issueda t

2)studentMaster

fileds: grno,stdename,( and lots more)..only these filed are req to display...



now i have made a dataset : "bookissuedatas et" which have two table which are assign above.

these is my code on print...

Exception Details: System.Argument Exception: DataTable already belongs to another DataSet.
Googling for this error shows several post of people trying to manipulate a table within a dataset. Others suggest using .clone() and .copy(). Neither results in a different error.

Within another class, I've gathered two tables of data for a nested repeater. To return a table, int, string or anything else in C#, one sets their local variable...

Hello everyone
I have an XML file which is a multitable nested xml file (.Tables.Count returned 12 tables). I would like to have all of the xml contents in one table or, if not, select different columns from these different tables (that are stored in XML) and put them in one table.
As I understood Datagridview only allows only one table at a time. Is there any way to create a new datatable by joining exsting tables from XML?
...

I have read the following topic:
sorting dataset
and I am facing the same issue.

I am designing a report. I have fill a dataset with the results from a query. From the results, I used to set the value from the items into an array and display on the aspx page in a table form. The reason why I don't use Datagrid or Gridview is because the table has to be design where the column headers has 2 or more rows and some columns...

Hi to everybody, I think I'm really confused with dataset and datagridview. If I modify cell values with a mouseclick, it works fine, but if I assign a value to a datagridview like this:

grd.CurrentCell .Value = myString

the cell value is changed but not the dataSet

to make the dataset changed, I have to assign the value directly to the dataset:

dS.Tables(0).Ro ws(row)(column) = myString...

I'll start this hopefully simple and add code where needed or requested.

Im using a combobox that bound to a DataSet. The Dataset retreives it's values from SQL.

I can retreive the values fine. However only displaying (1) Column. Which is fine.

Here's where it gets complicated for me. The dataset has 2 other columns that get filled. I need the resulting columns to be sent to text boxes when I select a value...

Using this code, the display member of the combo box is displaying the text "System.Data.Da taViewManagerLi stItemTypeDescr iptor". Huh???

The first block of code gets the data from the database, and works as far as I know. The second block of code sets the first value of the form, and does NOT work like I want it too. I commented out the line that sets the value member, because it gives an exception.

...

Hi all and thanks for looking.

I need to make the move from ASP to ASP.NET, and as my sister has aked me to knock up a website for her, I thought this could be a nice starter project to help me learn.

The site displays thumnails of images she will upload. Each file needs some information stored in a database about it. In classic asp I would have created a list of images and realated info within a database and driven the...