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!

Register Log in
  • 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!

Search results for query: *

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

    set selected item in dropdownlist within datagrid edit template

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

    DataSet Problem

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

    DataSet Problem

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

    Concatenate data from different rows

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

    Concatenate data from different rows

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

Part and Inventory Search

Back
Top