Is there any way to find which filed is the unique ID field in a table by using some type of SQL... i.e:
select * from Test_Db..syscolumns c
join Test_Db..sysobjects o on c.id = o.id
where o.name = 'table_Test'
The above example will find all column names for a given table.
I m looking...
I have a page that connects to SQL server 2000 and executes a very large query, that returns a small amount of records. The query takes about 2 minutes to execute in query analyser but the ASP.NET page expires before i get any results on screen.
The full message i get is:
"Timeout expired. The...
This worked for anyone interested after 8 hours hammering my brain.
Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
Dim ctr As Integer
Dim i As Integer
Dim drpbox As New DropDownList...
I have a static multiselect list-box tbl1 which contains values.
i m selecting several values i.e value1 and value2 and after clicking a button i want based on these selected values to create Dynamically (2) drop down boxes and append to them the values of my previous selection.
So for...
Note Unlike the Connection object in the other .NET Framework data providers (SQL Server, OLE DB, and ODBC), OracleConnection does not support a ConnectionTimeout property. Setting a connection timeout using a property or in the connection string has no effect and value returned is always...
anyway i fixed that: see code below: unless somone has a quicker work arround without using the relationships add thing:
Dim Dataset1 As New DataSet
Dim Dataset2 As New DataSet
Dim Datatable As New DataTable("MyDataTable")
Dim DataColumn0 As New...
Thanks cappmgr, although the article u are giving me suggest using: Imports Oracle.DataAccess.Client while i am using: System.Data.OracleClient. And thus the property Connection Timeout=60; is not supported, im getting: Keyword not supported: 'connection timeout'.
So i assume i have to download...
does anybody know how to set the timeout command when connection from ASP.NET to otacle? using
Dim oracleConn As OracleConnection = New OracleConnection
oracleConn.ConnectionString = "user id=xxx;data source=xxx;password=xxx;"
i tired connect timeout=9999 and connection timeout=9999 but both...
I am new to asp.net although i had a good experience working with ASP.
I m connecting to 2 different databases, i.e Database A and Database B. Then Selecting fields from Database1.TableA trying to JOIN to Database2.TableB. I then bind to Datagrid.
I used the folowing code which works fine but...
The problem is that I am not using any custom query for this. I am talking about the MS Access default Search facility (i.e Ctrl+F). The common office popup window that is used for all office apps for either Find or Replace. Is there any way to make this work fast instead of having to create a...
I m using MS Access 2003 and using the upsizing wizard i have migrated my database to SQL server 2000. Every time I use the MS Access's default search to search the recordsets of my database for a particular value on a large (10.000 recs) table, the search facility becomes very slow. I have...
Hello everybody,
I am using Windows XP Pro SP1 with IIS 5.1, is there any way to allow a non-admin user using his accound (non-admin) log on to my machine and administer IIS i.e start/stop IIS server e.t.c lets say im the admin user and he isnt, and that we both exist on the same machine.
In...
I finally found some script and simply modifided it to fit the purpose. Thanks stefanwagner for you help. The following code accepts the text file plus two numbers on command line.
usage:
java SelectLines my.txt 2 4
Output
line 2 of file
line 3 of file
line 4 of file
import java.io.*...
Can you help please?
I have a text file ".txt" and i want to specify lines to read from it in command line.
i.e
my.txt contains
Line 1 of text
Line 2 of text
Line 3 of text
Line 4 of text
Line 5 of text
Line 6 of text
Input
Java LineReader 3,5
or
Java LineReader 3 5
Output
Line...
I do like answering my own questions is always enjoyable. Well first the reference to my previous post for incompatibilities in "special functions (dates, chars)" is wrong hehehe this never happened... sory for this
and seccond i found the following links addressing all my questions...
Hi everyone, could you please give me any possible links to a document/s (or anything) that shows or discusses or lists the basic (or detailed) differences of Access 2000 and Access 2002 (sp2).
My attempt to answer this question was simply to go through some existing databases from others, and...
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.