Search results for query: *

That's the last extreme solution I see to solve this problem. I have two reasons to say this: About adding a user column: 1. I can't add the column, because of the database structure. If I added a column, that would kill all my primary and foreign keys. In my sample I used only 1 table, but...

Sorry, I forgot to mention that relink the tables at run time is not an option, because the Access mde is shared by all the users. It is placed on a network share and everyone uses the same file. so, I can't relink it. NetAngel

My Oracle database engine has several tables, owned by different users. I need to link a table in an Access database to those tables, but, depending on the user. This is easier to explain with a sample: Tables in Oracle: ----------------- user1.Table1 user2.Table1 user3.Table1 Table in Access...

I need to develop an asp.net(vb) intreface for a document storage software. The documents are stored on a database (SQLServer, Sybase or Oracle) in bolb fields. My web application needs to get the document from the database, open it on the client correct app (xls-excel, doc-word, bmp-paint...

I have a parent-child relation. I need to show it in a datagrid, but I must filter the parent rows. I have a typed dataset, with the two tables and a relaction between them. I must fill that dataset, but I can only import the filtered parent rows (the parent tables has about 100.000 records and...

I spent the last few days trying to load data into a XML file with a nested structure. My XML file is something like: <?xml version=&quot;1.00&quot; encoding=&quot;...&quot;?> <QML version=&quot;1.0&quot; timestamp=&quot;...&quot;> <HEADER> <FROM> <IDENTITY>...

As I said before, I already have the xml file into a datatable. The datatable has 3 columns: 'brand', 'number' and 'description'. The 3 columns are automaticly recognized as char(50). I need to save them into a database table with the same 3 columns, but with different data types...

I'm doing an interface between my supplier database and my company's. My supplier already has an interface (webservice) that waits for a request of information in a xml package and sends the requested info in a xml package. All I need to do is insert the returned xml file into my database. Is...

Is there a way of doing it without the cursor? I must set it directly into a table, so, it should be a select statment. I'd like to avoid saving that data in the table for the obvious reason: dificulty in mantaining correct data (all it takes is an update on a father node and all the child will...

I have a table with a sort of father-son relation TABLE1 ----------- IDObject IDObjectFather Description Is it possible to list all data, adding a colunm with the level of the current object (number of 'fathers' and 'father or fathers')? IE: 1, NULL, A 2 , NULL, B 3, 1, C 4, 1, D 5, 3, E 6...

Is it possible to save a document (doc, jpg, xls, ...) to the server disk? I need to open a document (any kind, as long as the user has a proper application to read or edit it), and let the user read or edit it. Afterwards, when the user closes it, I need to save it on the database or server...

As I said in my previous message, I found the 'select' method. I allows, not only to filter data, but also to order it, without going back to the database. The only use the dataview may have is to control the original, updated and deleted records. NetAngel

Thanks, but I've worked arround without dataviews. I had never seen the 'select' method of the datatable, and it was exactly what I needed. In my oppinion, dataviews are useless, unless you want to bind something to them. To work with data using code, the best way is to use datatables. I've...

My app uses a datatable to send some session data between pages. This data table has info about several variables that are present in all pages, and I need them to be persistent when the user returns to the page. Datatable structure: Page Val1 Val2 Val3 1 a a a 1 b...

Try using this: Dim strSql As String Dim strConn As String = ConfigurationSettings.AppSettings(&quot;ConnectstrW&quot;) Dim conn As New SQLConnection(strConn) strSql = &quot;select org_nm from grant_info where org_nm like '&quot; + org_nm_tb.Text + &quot;%'...

I always use the ItemDataBound event. If MyGrid.EditItemIndex <> -1 And MyGrid.EditItemIndex = e.Item.ItemIndex Then With CType(e.Item.Cells(3).FindControl(&quot;MyCbo&quot;), DropDownList) .Items.FindByValue(MyValue).Selected = True End With End If MyValue has the current item's...

The incoming data is perfect. I can load it to a datagrid and I have no duplicated rows or key values, nor null. I believe this is a data set generation bug. NetAngel

I'm having a strange problem with auto generated datasets. I'm using a Sybase database. I have a design time dataadapter, with a simple select statment, and then I generate the dataset. All goes Ok. When I run my app, I get a 'Failed to enable constraints' error, on the...

The main reason I want it in a single select statment is because it has to work under sql server 7/2000, sybase 5/8 and oracle 8/9. This is why I don't want cursors. But if anyone has an magical idea to solve it with more than a select, and if it works on all engines, I'd love to hear it...

I need to concatenate data (strings) from <> rows. My table looks something like: 1 'X' 1 'YR' 2 'FI' 2 'E' 2 'AAA' And I need a select statment that returns 1 'X YR' 2 'FI E AAA'. I don't know how many rows each number has, and I don't know the size of the original string. I...