Hello, I want to set the schema of a DataTable. It should have the same structure than my Datatable in SQL Server. The last column is a Timestamp called Stempel. Timestamp is treaten an a Byte-Array. What can I do to set the Type for this column? Dim myDataTable As DataTable = New DataTable...more >>

I am trying to develop a program that would work with any database using ADO.NET. I am having a hard time because of the differences in SQL syntax between databases. One example is when I try to specify the column name, some databases require that I put the name between square brackets, others...more >>

when i release my program with master-detail form, i want to remove the (+) indicator from master datagrid. how to do that? ...more >>

I have a dataset containing an already-populated single datatable which I which to perform an operation on. The structure of the table is below: Specifically, I want to get the most recent message for every unique {Group, User, Subject} subject to TimeStamp being less than an AsOfDate that...more >>

Hi all, Ok I have a sub that creates a Datatable loads some values then I bind it to a DataGrid to show the user. I later need to add values to the third Column in that datagrid? Ok I tried a Global datatable but at the line where Datagrid.Datadource = Datatable it takes like 3 - 5...more >>

I have a stored procedure. I calls some other procedures and then returns a single result. However, the other stored procs are returning rows that i don't need. How do I clear the results so that the other value returned is the one at the end of my proc? thanks, steven ...more >>

Hi All We have a big application server build using Delphi 7. Then, our idea is to build a web tier (client) using ASP.NET / Web Forms. My idea: generate manually a ADO.NET DataSet (XML) in Delphi 7, based in Delphi DataSets. How Can I do this? Thanks Guinther ...more >>

Hi all, i have a problem with a transaction.i will tray to explain my problem. i have a Dataset that i have fill using 2 DataAdapter with a simple query ( all tables with an autonumber). i have made code for the dataadapter rowupdate to get the @@identity of my table. everything works fine. ...more >>

I am creating a page that will use a DataGrid. It will display a list of people. Each row will have an Edit button that will take the user to another page where they can edit that particular record. Each row will also have a Delete button that will delete the record. Should I use a DataSet as...more >>

I'm trying to connect to Oracle database in the asp.net app. But keep getting the error: "ORA-12154: TNS: could not resolve service name at System.Data.OracleClient.DBProjectPool.GetObject(Boolean&isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledconnection .. " ...more >>

i need to build program that can connect to large DB or small one, according user needs. but i whant that my program retrive data from tow resource in same code of sql select. i whant to manage data in memory, and save it like xml or somthing else. but i need to use with sql selelect. the d...more >>

When updating an Oracle Varchar2 column with an empty string "" using the OracleCommandBuilder generated UpdateCommand the follwing error is thrown: "Parameter 'p1': No size set for variable length data type: String." Is this a bug in the OracleCommandBuilder? Is there an elegant workaround? ...more >>

nested table for what? how it's work. i try to raed in msdn, and i make simple parent child table: table aa table bb i drop bb table into aa table, i make simple form with tow datagrid, the first one bind to aa and second to bb table. i run the program, and i not see any liked between tow ta...more >>

Hi, In my application I am manually adding a datarow (with user data not from db) in a typed dataset. At that time the datarow row state is "Added" which is correct. The problem I am running into is when I modify that row later in the application the row state is still "Added" and not "Modif...more >>

Hi All, I am exporting data from a dataset to an excel spreadsheet via OLEDB. Everything works fine but one part. All my cells have a single quote in the beginning of each piece of data. I realize this is how Excel maintains the data as text; but I am wondering how I can prevent this from hap...more >>

I have a access query with 3 tables with left joins and some criteria conditions. Viewing the query in access 4 records are returned which is correct. If I use a .NET OLEdbAdapter to read the query I get only the first record in the .NET application. Many onther queries and tables work fine. It app...more >>

Hi I have a question on how the datareader work underneath when retrieving the records from the data source Does the DataReader fetch one row of data everytime I call the Read() method or all the rows for the query is available in memory before I call Read() method ?....more >>

Hello, I'm a =2Enet (CF) newbie, and I have the followong problem: I try to create an application in =2ENET CF using data stored in= XML/XSD files for an iPAQ=2E When I load an XSD file into a dataset i want to create an epmty= table which structure was described in the xsd file=2E The o...more >>

Hi , Is there any difference between Integrated Security=True and Integrated Security=SSPI? The docs seem to indicate they are the same but i have seen different behaviour when connecting to sql server using each in the connection string. All info welcome. Regards John...more >>

why need uniq key on master in relation? (it seem like stupid thing. again and again microsoft going revese) take look in access, when you need to write Master-detail, make subform, and link it parant-child, and not need any key on master! take look in VB6 with DataEnvironment, make it eas...more >>

In Java I would open a connection to the database on each page and close it before leaving the page for connection pooling purposes. Do I do the same with ASP.Net? ...more >>