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="1.00" encoding="..."?>
<QML version="1.0" timestamp="...">
<HEADER>
<FROM>
<IDENTITY>...
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...
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...
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...
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...
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...
This is more a 'complaint' than a question, but if anyone has a work around it, please be free to share it.
This is about those VB.NET DataGrids that do everything except the essencial. My project uses a lot of parent/child relationships, like order and order lines kind.
So far (using the order...
Does any one have a script (or some other way) to script the data of the database?
I'll explain better: The enterprise manager scripts the database schema (creates the database, the tables, views, and all the other objects).
I need a way to quickly script the data, in the format:
INSERT INTO...
I know this can be done, but I can't figer out how.
How can I build a web control that uses more than html components on it? If you look at .NET components, you can find several components that have their only style, not depending on the html controls. For instance, the RTF control shows a sort...
I have an old ocx that I'd like to use on ASP.NET. It is working perfectly on VB6 and on HTML (using client script), but I need it to interact with ASP.NET, in order to save and set data, or retrieve properties' values.
Is this possible? Can I use an OCX in any way? That would solve a whole lot...
Is there a way to write script to the body tag, onclick event? I can write a startup script, or add script to all my controls, but I can't figure out a way to write it to the <body> tag.
I believe I've seen it somewhere... NetAngel
Is it possible to know the position the user clicked? I'm using flowlayout. I want the coordinates of the click, or at the very worse the coordinates of the clicked control.
NetAngel
I don't know if this is a html or asp.net, or even an iexplorer bug, but there's something I'd like to know how to solve.
Why are the DropDownLists (combos) always on top? I've just developed a web user control that is composed by a datagrid inside a table, and both inside a panel.
I have my...
This is another DataGrid question: How can I get and set the value of a Button Column (Select)?
I usually use '>' or '->' as the select row string, but now I must change it by code (depending on user preferences).
Is this possible? Can I set it in run time?
NetAngel
A few days ago I saw a great idea in this forum that I can't find now.
Someone was calling a function or method that would interact with some control of the calling page. Inside the method the control was used without sending a reference to the calling page.
Right now I'm using it like...
New hot stuff to solve on my hands:
How can I catch a window closing on server side code?
I'll explain better. My app alows login/logout facility. I'm already saving the login info (user, date, time, ip). Now I need a full record of logout too. I have a logout link, but most people just close...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.