Hi, Can you please tell me whether the dataview is updateable at the server side and if yes then kindly write a simple code for an example. Thanks & regards, ...more >>

I was using Spread for awhile and then haven't played with it for several months, so I've somewhat lost focus on the data updating ... Anyway, what I'm trying to do is save many rows from one page of the Spread back to the database. Is there a better method than looping through through the row...more >>

Hi, Is there a way to increase the timeout period to Sql Server? Occasionally my app has to run a long update and it gets timed out. thanks! -thinh ...more >>

I start with an empty dataset I then add several rows to it I then update the SQL table with the dataset update method The table's primary key is an identiy field so the id's are generated by SQL how do I get the id's that were generated when the records were inserted? Can I get them loade...more >>

I got this error using an Oracle stored procedure ("multiple instances of named argument in list"). This is not a question posting, but more to let people know a possible cause of it. I got this error because I was sending in the wrong database type for one of my parameters. Apparently, the ...more >>

Hello, Does anyone know how to find the index of a row in a data table in a dataset? The Find Method returns a data row, but to remove/delete a row from a data table you have to supply the row index and I am not sure how to find that. There does not appear to be an indexof or getindex prop...more >>

Hi guys, In vb.net, i use OracleDataAdapter to execute following query and fill into a DataSet. The problem is it returns no row but actually it should have some rows. If you run this query in sql plus or similiar tool, it works fine. This problem happens only when the first table has rows th...more >>

I am attempting, for the first time, to use SQLCommand in asp.net . My ultimate goal is to utilize a stored proc. When I use the following code to begin, I get several error messages. I hope someone can explain these to me and let me know what I need to do to correctly implement the SQLCommand i...more >>

Hi Guys, Iam trying set a version number to a database table. The main reason is if i add a new column later on i will be able to make sure that table schema need to be updated. I have tried updating the version column in the sysobjects for that table. but couldn't do that. Is it a good ...more >>

I wrote the following method to test connecting to an Oracle database: public static string HelloMyOracleDataWorld() { string ret = ""; string connectString = "Integrated Security=false;PWD=password;UID=user;SERVER=server"; OracleConnection connection = new OracleConnec...more >>

I'm currently obtaining the column names of my table (in an access database file stored locally). However, upon receiving the list, all of the column names have been sorted and are not in their original order. I was wondering if this was a result of the method (and in that case if it's preve...more >>

Dear all, I have read in many places that datasset are great for retriving data that needs to be updated afterwards as they are working as discinnected mode. But then an other topic comes is the fact that they are expensive in memory... So now my question is that: if you have a huge amoun...more >>

Hi All In our project, I have a globally transacted connection. Is this a "proper" way of doing things. All movement through this connection is transacted and the connection is opened and closed as required. Can anyone think of any pitfalls, pros, cons of this approach? Regards Ray B...more >>

I'm trying to select data with an OleDbCommand on a parameterized query When the parameter's value is set to DBNull.Value, no rows are returne even if one exists. I'm using an Orable 9i database. Here is a complete setup to reproduce the situation, you just need you own connection parameters....more >>

How do you fill a strongly typed dataset using the new version of DAAB? I have seen examples written using DAAB v 2.0 but in that version, there's an object SQLHelper with a method FillDataset(....). This SQLHelper object does not exist in the current version. Any help (and example code) w...more >>

Hi, I am creating DataSet and many DataTables and populating value to those tables and finally writing the values as XML. I want to add attribute to my DataSet. How can I do this? DataSet objDataSet = new DataSet("Test"); objDataSet.WriteXml(@"C:\Test.xml"); Output: <?xml version="1.0" ...more >>

When the header text of DataGrid is Right aligned ,then the last few pixels of the header text is clipped off.I tried padding the text with a space or two but this seems to be trimmed before the text is rendered. This problem is detected in windows XP.But when the same code is run on Window...more >>

Hi I am having problems opening a connection to an Oracle Database using Visual Studio.NET 2003. I can create the connection fine using the new connection wizard and can browse the database using Server Explorer, the problem appears when I try to open the connection when I run the project. ...more >>

Hi, everybody! (sorry for double posting as news.microsoft.com) I sure hope somebody has already stumbled upon a similar problem and found a solution. Basically I'm having a problem with establishing a transaction between my app server and a sql server, both on different boxes. When I try...more >>

I am getting an error: Server Error in '/' Application. An Ole Db Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB. My Function is this: Public Function GetDataSource(ByBal sql As String) As DataView Dim ds as DataSet Dim cnn as OleDbConnection...more >>

Hi all, I hope this is a suitable group for this question. Feel free to push me off to the correct one if not. :) Basically i have been developing windows applications using Visual Foxpro for about 5 years for a small software house and we will be shortly moving to a .net (C#) solution....more >>

Hi, I have a stored procedure with a query SELECT DR_EmployeeView.emp_id, DR_EmployeeView.emp_sme_id_1 as [emp_sme_id], DR_EmployeeView.emp_sme_id_2 as [emp_sme_id] FROM DR_EmployeeView I need my xml looks like this (with 2 same elements, emp_sme_id): <nc_employee> <emp_id>00000026...more >>

Hi friends Can anybody tell me where to use datagrid and where to use datalist. Or explain Different between DataGrid and DataList. Regards, Alex ...more >>

The question is should I use the connection pooling. Here are the details. I am developing ASP.NET application it is running for some time already while we keep adding some features. Recently noticed that some pages return error - the amount of connection exceeded the maximum amount. I starte...more >>

hi, I'm using c#, asp.net 2003 and sql server 2000 to develop a portal application. my web.config file looks as follows <configuration> <configSections> <sectionGroup name="system.web"> <section name="dsnstore" type="System.Configuration.NameValueSectionHandler,System,Versio...more >>

Hi, I'm calling table.Rows.Remove(row) to remove a row from a data table. But, DataSet.HasChanges() still returns true. Is there any way to make the row go away completely? (Without calling AcceptChanges on the dataset or data table. I want to avoid that for the reasons noted here: ...more >>

I have big application that uses first version of DAB. It could be just regular performance problem though. I just noticed that I have major problem with connection pooling. My connection string saved in web.config file so it should be the same for all the connections. I use a lot of SqlDat...more >>

Something that has bothered me for awhile: whether or not to allow users to delete what I will a "top-level" data element, for example, a name from a list of companies. Early in an enterprise's operation of a particular system, deleting a company name from a list would not be problematic, but ...more >>

Can someone please tell me what is wrong with this code. I know that the line indicated with and arrow is wrong somehow, but I am not sure about the query either. I am just trying to have the txtBox return the number of rows that has [Code Number] = 2 By the way this is an Access Database ...more >>

Hello, Can someone pls. offer some advice? I'm using .Net 1.1, OracleDataAdapter, OracleCommandBuilder. I fill the dataset (with a Select), return the adapter, later, call Update on the adapter, and close the transaction (with the connection). Calling Update returns 10...that 10 rows we...more >>

Hi, I have come across a bug that I have found no documentation or discussion about. It's just like that one time I had a bird poop on my head; it was not good luck either. I'm using an OracleDataAdapter and an OracleCommandBuilder for automatic command building to build insert, update and ...more >>

Hi all, I use a typed dataset in my applicaiton. There are three levels defined in the .xsd, first level is member, which has child element named plan, which has child element named fund. The structure looks like: <xs:element name="mem"> <xs:complexType> <xs:sequence> <xs:...more >>

Hi, I wanted to find out how one can get the query (the actual SQL statement) in a TVF that is calling the said TVF? Example: select * from SOME_TVF() where blah... SOME_TVF() { // Something like...... string query = GetCallingQuery() //now query = "select * from SOME_TVF(...more >>

Hi there I try to update a dataset through an oracle stored procedure. This works fine but as the stored procedure changes some fields on the row, the dataset shows afterwards some wrong column values. How is it possible to refresh the dataset after an update stored procedure? Could someon...more >>

hi all, I wanted to know if there's any way I can influence how the output of the xml would be using WriteXml. for eg, if my dataset has a table called tblMyTable, then in the output XML i want <MyTable> instead of <tblMyTable> TIA, Mounil. ...more >>

I read the following about SQL Server Developer edition: "SQL Server 2000 Developer Edition is a more restricted version of SQL Server 2000 Enterprise Edition that lets you perform development and testing prior to deploying the Enterprise Edition." What exactly are the limits? Does it jus...more >>

I created an sp in northwind in SQL server 2000, CREATE proc [dbo].[up_getCount] @Count int output as select @Count=count(*) from northwind.dbo.customers And ran the following C# code: using (SqlConnection conn = new SqlConnection("Server=localhost;Integrated Security=true")) ...more >>

I know this may be a sql thing but I would expect someone to have dealt with this. I have some update stored procedures with many steps. normally, my stored procedures "set nocount off". so the rowsAffected = ExecuteNonQuery doesn't return anything but 0. So I turn it on (nocount off),...more >>

Dear All I have a 5 user vb.net app that is trying to display in a grid what i reads from an MS Access table. The access database lives on a win200 network share. The grid is updated by a subroutine called by a timer which was intended to fire every few seconds. Now the app works fine on o...more >>

There appears to be a rather fundamental bug in DataViews. The DataRowView keeps track of the corresponding DataRow by two mechanisms - an index, and a reference. Sometimes it accesses the row by one means, sometimes the other. If you delete a row from a view, the index for other DataRowView...more >>

Hi, I am using Visual Studio 2003 and using OracleDataAdapter to connect to the database. When I specify to an SQL which has a sub query, it's failing with he following error, ; Syntax Error: Expecting identifier or quoted identifier. in System.Data.OracleClient When I looked at the M...more >>

Hello! I am trying various ways of preventing the injection. I tried this: "select count(*) from table where userid like @userid" and SqlParameter param0 = new SqlParameter("@userid", SqlDbType.NVarChar,50 ); param0.Value = Session["userid"]; myCommand.Parameters.Add( param0 ); That jus...more >>

This is my first attempt to develop a form in .net to insert and update data in a database based upon user input. I'm pretty familiar with ASP, yet I'm finding some of the differences frustrating. Page One allows a user to enter a record number and view details to make sure the correct record wa...more >>

SQL Server provides a CHECK constraint to insure the data in a column falls within a specified set of values. From SQL Server Books Online: CHECK Is a constraint that enforces domain integrity by limiting the possible values that can be entered into a column or columns. How i...more >>

Good Monday Morning: I am at a dead stop and I am hoping some other developers out there can help me out. I have built a dataset that first contains a table populated from SQL Server then I am adding another table that is built from the same Query and data from active directory. I have bu...more >>

We're having some problems with our 3-tier application. On one ASP.Net page, we're reading data from one database, and inserts the data into another database. After the insert statement has run, we select the same data, and create and object that is used in the business layer. If we use the sa...more >>

Excerpt from Code: dim ds as new dataset ds= execute("Stored_Proc") dim name as string= ds.tables(0).datasetname execute is a function that executes the stored procedure Stored_Proc. Suppose execute returns an empty dataset, what kind of exception is raised? ...more >>

I am using windows forms that have 5 textbox's they are bound as follows: drvDetail = (DataRowView) cm.Current; vueDetail = drvDetail.DataView; this.BindingContext[vueDetail].Position = cm.Position; txtSON.DataBindings.Add("Text", vueDetail, "service-order-number"); txtTaskID.DataBindings...more >>

I would be grateful for suggestions for tiny footprint ADO.NET compatible database alternatives to Access MDB files, supporting XCOPY installation. We have very simple query needs and no need for JOIN support. Our basic need is to quickly select from a table containing ~200,000 rows all rows wher...more >>

I'm going to bother you on one more question. Tell me if I'm out of line. This one ha 441 views without an answer. I might mention that these datagridviews are totally unbound. The column headers I created in the column collection. Can't set value of datagridview cell The documentatio...more >>

Sorry for asking here, but there's been hundreds of views of my question in the vs 2005 forums, but not a single answer. Can't synchronize individual controls and a datagridview to the same row. It was easy to do in vs studio 2003. When I changed to row in the controls, the row would ch...more >>

I'm using typed datasets with bound VS2003 Winform controls. In my code to add a new record, I get the following error: "Databinding could not find a row in the list that is suitable for all bindings." At this point, my database table is emtpy. Simple Code: Me.BindingContext(objDocRvwCa...more >>

Whenever I want to use a Typed Data Set I find myself writing A LOT of code which I think shouln't be necessary. For example, if I wanted to get a DataTable of the Customers table I would have to write all this: --------------- Dim myCnn As New Data.SqlClient.SqlConnection("TheConnectionStri...more >>

Hi group, I have an app with a table gateway-style data access layer that does atomic crud operations on individual tables. but sometimes i want to do two inserts/updates/etc. on multiple tables as a transaction. I could write custom data access methods to handle these special cases, but I'd...more >>

Hi, I have a very strange error. string strFilter = "some filter expression"; drFoundRows = m_dsQuote.Tables["Some Table Name"].Select(strFilter); if(1 != drFoundRows.Length) { return; } drFoundRows[0]["Some Column"] = 1; I got the following error when I assign drFoundRows[0]["...more >>

I have been playing around with 2.0 and I'm trying clarify a few things about generics and data access. I was hoping to be able to do something like this with nullable types: int? foo = null; DataRow dr = ...; dr["Column1"] = foo; However, this does not work if the DataType value is set ...more >>

Hello, I am using an OleDbData Adapter to query a visual fox pro back end. When I build the query graphically everything goes fine until I try to generate a dataset. That throws an unspecified error and will not allow me to add a dataset to the project. Any ideas on what to check to r...more >>

This has probably been asked before, but I didn't get the memo, so I'm wondering how to find out how many connections in the "pool" are being held open by SQL Server 2000. ...more >>

Hi, I have a DataSet, which contains several DataTables. I want to put a new DataTable in it (tblFileSettings) just before I write this DataSet to an XML-file. But what I want is that this new DataTable tblFileSettings is the first DataTable in the XML-file. So If uses open the XML file, th...more >>

Hi all I'm new to C# and ADO.Net. I've managed to insert, update and delete records from a database but I need to know how to show these changes immediately. For example : If I delete a record from the database, that deleted record will remain in my forms textboxes until I restart the prog...more >>

eg: I want to get all the content in SqlDbType , and save this to a array ... any help ? -- FireCrow Studio Kylin Garden QQ:462042991 MSN:GaoTianpu@hotmail.com ICQ:156134382 ...more >>