Hi, I have an application, that needs to import excel spreadsheets into a database. I am using an OleDBDataAdapter to load (fill) the data into a Dataset. Occasionally, person sending us the file, will put the data starting in column B, not column A. This fails our checks on column cou...more >>

Today I tested with the TextReader, and XmlReader, I found that the Stream.Position can not be used to tell XML node position between each Read methods, since the readers will read some amount of chars and then cache the them. Then we have got to write our own XML parsing and indexing codes, whi...more >>

Sorry about the previous post. No "id" attribute is needed actually... "W. Jordan" <wmjordan@163.com> wrote in message news:%230fvOF2nIHA.2160@TK2MSFTNGP06.phx.gbl... > Hey there, > You should do something to prevent this exception. You should do > replaces to the fragment to add an "id" at...more >>

Hey there, I did not test with the problem. I know what you are talking about. First, in order to browse and seek through the document, you should use XmlReader.Read () and Stream.Position to go through the document, and record start tag offsets of every critical elements. And use the offset ...more >>

I've got to ask, why in the world would you want to use DAO and the Data Control?! To me that just sounds like throwing out my calculator and using an abacus. "Scotty" <matthieu.sarthou@googlemail.com> wrote in message news:cbb0be9e-75e9-436d-b3d9-748f95762065@s50g2000hsb.googlegroups.co...more >>

On Apr 1, 2:37=A0am, Charles Calvert <cb...@yahoo.com> wrote: > On Sun, 23 Mar 2008 19:37:17 -0700 (PDT),rbrowning1958 > <RBrowning1...@gmail.com> wrote in > <8b215e6b-020c-4ce3-bff2-473784a8b...@s50g2000hsb.googlegroups.com>: > > >VS2005 - SQL Server 2005. > > >Running an SP from the server ...more >>

Hello Have a huge XML file with multitudes of "LogEntry" nodes / text lines. A small sample of this xml/text content is below. The file could be anywhere between 200 to 2000 MB. My questions comes in two parts. (A) I would like a solution (or ideas for it), in C#, -- to randomly access ...more >>

-- Internet - Take Advantage of Multiple Windows When Surfing SUMMARY: Stop jumping back and forth between index pages by using several browser windows. Why use one web browser window when you can have multiple? If you have an adequate amount of memory, open up several web browsers t...more >>

On Wed, 27 Feb 2008 11:58:04 -0800, Dustin Pedroia <DustinPedroia@discussions.microsoft.com> wrote in <D9905F4D-9DF5-4FAD-88DD-1790C6B6DCCF@microsoft.com>: >while using an Access 2007 .accdb file I can access the dao. object very >easily. >the following code in VBA works well : [snip code...more >>

On Sun, 23 Mar 2008 19:37:17 -0700 (PDT), rbrowning1958 <RBrowning1958@gmail.com> wrote in <8b215e6b-020c-4ce3-bff2-473784a8bd67@s50g2000hsb.googlegroups.com>: >VS2005 - SQL Server 2005. > >Running an SP from the server explorer window. The SP accepts two >parameters: > > @s varchar(128) ...more >>

On Mar 24, 1:37=A0pm, rbrowning1958 <RBrowning1...@gmail.com> wrote: > Hello, > > VS2005 - SQL Server 2005. > > Running an SP from the server explorer window. The SP accepts two > parameters: > > =A0 =A0 =A0 =A0 =A0@s varchar(128) =3D NULL, > =A0 =A0 =A0 =A0 =A0@b bit =3D 0 > > I cannot s...more >>

Hello, VS2005 - SQL Server 2005. Running an SP from the server explorer window. The SP accepts two parameters: @s varchar(128) = NULL, @b bit = 0 I cannot seem to set the bit value. I receive the error "Input parameter cannot be converted". Ideas anyone? Can run it from SQL Serve...more >>

Hi, I am trying to use in a Dotnet project a control featured in VB6: data control. Here is what it looks like in vb6: [URL=http://imageshack.us][IMG]http://img525.imageshack.us/img525/3605/ image1ib8.jpg[/IMG][/URL] http://img525.imageshack.us/img525/3605/image1ib8.jpg And in the for...more >>

Hi, I've no idea if you still have this problem, but I just had it myself. The only way I managed to fix it, was to create the SQLDataSource Object outside of the <Accordion> tags. Hope that helps. "mansoor ali" wrote: > > > Hi i am using accordion control in which i took 4 acco...more >>

while using an Access 2007 .accdb file I can access the dao. object very easily. the following code in VBA works well : Function getrecordcount(strTableName As String) As Long Dim dbCurrent As DAO.Database Set db = CurrentDb Dim rstRecords As DAO.Recordset Dim rstRecords2 As ...more >>

I have a table adapter with the following query SELECT viewCoreCheckIn.TonerTypeKey, viewCoreCheckIn.PartNumber, viewCoreCheckIn.MinCheckInQty, viewCoreCheckIn.MaxCheckInQty, viewCoreCheckIn.StagingCurrentQty, viewCoreCheckIn.PreInventoryQty, COAL...more >>

Hi How do I create an own short cuts? E.g. A short cut for my email adress. Frida...more >>

I was successfully calling a TableAdapter.Fill command in code which was tied to an SQL stored procedure. I altered the stored procedure in SQL Server to include two additional parameters and it stopped working in code. The stored procedure works when previewing it in the dataset designer. ...more >>

I get the following errors when attempting to install Visual Studio 2005 SE. [02/16/08,12:31:36] Microsoft .NET Framework 2.0: [2] Error code 1603 for this component means "Fatal error during installation. " [02/16/08,12:31:36] Microsoft .NET Framework 2.0: [2] Setup Failed on component Mic...more >>

I'm binding the dataView to a dataset (~400000 rows) and sorting it by a key (long type). I'm retrieving values from the DataView with FindRows(object key) which returns DataRowView[]. The problem is that rarely on Stress modes I get the following error: Source: mscorlib Message: Index...more >>

VS 2005 Add Project Add Data Set Add Table Adapter Use Microsoft .Net Data Provider for Oracle Connection Here i cant able to choose my oracle stored procedures, I can only able to see their oracle package names and body names. I can able to connect to oracle successfully, and i could able...more >>

VS 2008 Add Project Add Data Set Add Table Adapter Use Microsoft .Net Data Provider for Oracle Connection Select * From Table1 Change Command type - StoredProcedure - MesageBox "Property value is not valid CommandType.StoredProcedure is not valid for .NET Framework Data Provider for Oracl...more >>

Hi i am using accordion control in which i took 4 accordion panes.I tried to bind gridview in 1st and 3 rd pane with Object data source..The control is not able to find the appropriate method.I am getting an exception.. Kindly help me.. its urgent. *** Sent via Developersdex http://www.d...more >>

If there is a better place to post this please let me know. I have a GridView whose Data is bound to an ObjectDataSource ( BLL - DAL ). When I click Edit on a Row in that GridView I want one of my edit template fields to fill a DropDownList based on a value from another column on that same row...more >>

I riepilogate with corrections and updates: I've an Ajax Accordion that gets data from a database, in its content there is a Repeater that gets data from another table, depending which header is selected in the accordion. in the Repeater I've a checkbox (one for eache repeated field) checked...more >>

Hello Everyone, I am using a asp.net gridview control to allow users to edit a table on an SQL 2000 server. Most of it functions fine. However one field is an ntext type field to allow for a very long description/writeup. The gridview control in edit mode dosn't seem to like handling a l...more >>

On my machine I am developing a .NET site. When I execute it, everything runs perfectly. When I publish it (to my machine in a folder so IIS can access it), I get a SQL error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" I know what the error...more >>

While trying to configure a data set, I encountered an exception "while attempting to set the data source generator property". I looked at the previous page and the connection string appeared to be correct. Then I clicked next and in the "Choose Your Dataset Objects" the database I'm con...more >>

George Been there and done that. The positive side = "job security". Also you might want to post in another group as this one looks dead. I accidentally posted a question here yesteday, as opposed to the General group, and just happened to see your post. -- kevin... "George H" ...more >>

Kevin, Thanks for the response. Unfortunately you are dead-on. However, I've been thrown into this situation and am trying to triage the issues as tiem allows. My main concern right now is that there is no transactions use din thsi code, so when this 3000 line processing fails it leaves the da...more >>