Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by netangel

  1. netangel

    Link an access table to multiple database tables

    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...
  2. netangel

    Link an access table to multiple database tables

    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
  3. netangel

    Link an access table to multiple database tables

    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...
  4. netangel

    Download file, edit it and upload it

    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...
  5. netangel

    ADO.NET: Fill filtered hierarchical dataset

    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...
  6. netangel

    XML Schema

    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>...
  7. netangel

    Create and read from xml file to database

    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...
  8. netangel

    Create and read from xml file to database

    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...
  9. netangel

    I have a table with a sort of fathe

    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...
  10. netangel

    I have a table with a sort of fathe

    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...
  11. netangel

    Is it possible to save a document (

    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...
  12. netangel

    ADO - DataViews

    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
  13. netangel

    ADO - DataViews

    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...
  14. netangel

    ADO - DataViews

    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...
  15. netangel

    Newbie databinding to dropdownlist question

    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;%'...

Part and Inventory Search

Back
Top