I just finished an application that turns an Excel sheet ( a table of data) into a Sql server (MDF and LDF) file. My goal was to use it on the pocketpc2003 to search through the data. How can I open such file? In de help files they talk of a database file with the extention SDF. My file has M...more >>

I have written a little procedure which opens and displays the contents of an excel spreadsheet. Everything works just fine when my column headings are on the first row. But what if the data I want to extract is on the 15th row or the 64th row. How do I control where the selections starts...more >>

If my table contains 10 row, with 3 matching the first select, will all 10 again be evaluated on the next select? Here's what I mean: irows = dshistd.Tables(0).Select("bipad = '1234'") If, later, I do this irows = dshistd.Tables(0).Select("bipad = '5678'") will I get those that match out...more >>

I have a ASP listbox that I am trying to populate with two fields, one for display (Category) and one to store (ID) as the selected item. I can successfully populate and view the list. How ever after specifying the field to hold the selected value with the Databindings property, the error belo...more >>

How does one display a parent field in the Child's dataGrid? My database has two Tables, Skill, and Category. The Skill.CategoryID column in the Skill table relates to the Category.ID field in the Category Table. The relation was autogenerated from an XSD: relationCategorySkill =...more >>

Hello, frineds The code below works fine on the single table. How can I save data with this technique but on mult tables ? Let say I ahve a view with three table join i present in a grid After doing some updates and deletes I wouild like to save data which may impact all three tables For now...more >>

Hi group, I'm getting datas form a differentserver as Html code. I need ti write the datas in a database. code: Dim InsertCmd As String = "insert into table(cell1) values(@value1) Dim MyCommand As SqlCommand MyCommand = New SqlCommand(InsertCmd, MyConnection) M...more >>

hi i'm trying to connect to an http access database how can this be done? i always get 'invalid file name' for my connection string thanks...more >>

I have tried everything to make .NET return memory to the OS. I use Dispose and GC.Collect() as much as possible. I understand that if the memory is available then why not take it and keep it. However, I noticed that memory is only returned to the OS when the machine is desperate for RAM, but at ...more >>

hi string accessCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xyz.mdb"; using ( OleDbConnection oleCon = new OleDbConnection( accessCon ) ) { try { oleCon.Open(); } catch( System.Exception excep ) { // log the exception message } } I have impersonate set to "true...more >>

It appears that the rowchanged event is not fired by the fill method, but it is fired by the update method. If this is correct, what event is fired by the fill method? Thanks for any help Bernie Yaeger ...more >>

In one form I have not trouble hooking up to a datatable rowchanged event, so that I can display fill method progress in a progressbar. But in another - everything appears the same - I get 'object reference not set to an instance of an object' (dt is the offending object) from this code: Me.Sql...more >>

Hi, I am new to ADO.NET and ADO in general. I have successfully created my first application to access an Access database using a Dataset and Grid control. If I understand, a Dataset is a snapshot of the data contained in the database. From the Dataset, the user modify it and then update it...more >>

I'm looking for your advice and maybe help with this issue. So, this is my saga. 1). I got to create a grid, which would look preety much like an Excel spread sheet. I did it and that's schematically how it looks (Forget about id for now. It's Current over New Status): ...more >>

I have tables in my SQL 2000 database that have all fields as decimal. Most of them have a precision of 18 with a scale of 3. If I look into my dataset before doing a dataadapter Update, I can see that I have values such as 15.56, 0.67 etc. Values such as 15.56 get saved as 16. Values such ...more >>

I insert a single row into a Database, this row has a "Date" column in short format with value "29/11/2003". The problem is that when I bind a TextBox to the Date column and then fill the DataSet, the TextBox shows "29/11/2003 12:00 a.m" How can I show "just" the date? Any Example? ...more >>

I am getting confused. Is a dataset intended to be used as a recordset (ie: ADO.Recordset) or a database? I have 8 tables (varys from 100 to 10000 records in each table) which are shared among many forms. Is the best design to create a single dataset containing all the tables, populate all t...more >>

Can anyone recommend a good book on using remoting to build multi-tier distributed apps with ADO.NET? Thanks. -- Bill...more >>

Is there a native .NET provider for Jet (mdb, access, whatever it is called today). It seems that accessing it through OLEDB Jet Provider is kind of inefficient. Thanks. ...more >>

Hey, I have a problem with a drop-down list. When I load the web form, the dropdown list display's a set of all the employee's that is in the database. If I set a breakpoint in the code and click the Login Button, the selected text that appears is always the first one in the dataset. Does an...more >>

Hello. I would like to know if is a way how can I do in VB.NET somethink such as "COMPACT DATABASE" - this function is in MS Acsses. Thanks for asnwers. ...more >>

After creating shares on a Windows 2003 server. Our Mac 10.2 users can move files to the server however our Mac 9.1 users are unable. After connecting to the server and then trying to open the share the lock icon appears and we are unable to move data to the share. On the server the file permissi...more >>

Hi, I found a strange problem with .Net datatable and dataview. I would appreciate if anybody caould explain it to me. I have a datatable that users update (adding, updating or deleting). The problem usually occurs when the users add or delete rows in the datatable. The datatable st...more >>

Hi, Can someone point me out where I can find a sample or workthrough to access an Access database using ADO.NET and C#? Thanks ...more >>

I'm a newbie to ado.net. my requirement is as follows I have a datatable with me and I have to write a function which takes in a row number and column name and finds whether in the given row no, the column value has been modified or not. For eg my original table is au_lname au_fname...more >>

I'm having problems with this method. I've a dataset with 2 tables it in, called "A" and "B". I call the method to update one table ("A"), after which when I use Dataset.Haschanges() I how get nothing returned, where I would of expected the table ("B"). I've tried Update(DataSet, TableName...more >>

Hi, what is wrong on this code i really don't understand, why this is not running. <%@ Page Language="VB" %> <script runat="server"> Sub Page_Load(sender As Object, e As EventArgs) Dim merchant AS string merchant= Request.Form("merchant") End Sub </scri...more >>

This is a simple question without, I'm afraid, a simple answer: I am loading a datatable with a fill method in a load event of a window. I know how to hook up to the rowchanged event so that I can track the activity of the fill method, but how can I display it? If the form hasn't loaded yet, I ...more >>

Hi. From what I have read about connection pooling, different connections are stored in different pools. If the same application uses two different connections like these: data source=localhost;initial catalog=pubs;integrated security=sspi;max pool size=100 data source=localhost;initial ca...more >>

Hello everyone! I am using a StoredProcedure with Microsoft Access. COMMAND.Connection = CON; COMMAND.CommandText="[new Entry]"; COMMAND.CommandType = System.Data.CommandType.StoredProcedure; COMMAND.Parameters.Add("@Field1",OleDbType.Guid).Value = new System.Guid(Cookie1.Value); COMMAND....more >>

I have a dude, what occurs if I build a Site with System.Data.ODBC included in Framework 1.1 and my web server only have Framework 1.0?...more >>

I have written an application which calculates several parameters and passes these to a object array, and now I want to display these graphically. I plan on using the graphic capabilities of Crystal Reports, and so have to get my object array to populate into a dataset which will serve as...more >>

Hi! I Have de following problem... I must call a web service, which returns a xml string, that i must to process it and create a DataSet, using the readXml function: myDataSet.ReadXml(strReader, XmlReadMode.InferSchema). the xml have the following format: <Results> <Document relevance...more >>

Hi, is there a problem if I declare parameters in stored procedures without precision? For example: "pFirstName nvarchar" instead of "pFirstName nvarchar(40)" or numeric instead of numeric(2,2). This parameters access columns declared with precision in my database tables. Has anyone tried ...more >>

Hi, I am having a lot of problem retrieving data from a stored proc into a typed dataset. Here is what I have done: I have a stored proc 'sp_test' which accepts 2 parameters & executes another proc inside of sp_test... the code is like this If rtrim(parm1) = ' ' begin exec s...more >>

I'm still having trouble hooking up the datatable rowchanged event to track progress of the fill method. The code below errors out on 'can't find table 0', but no matter what I do I can't seem to get it to work. Dim dahistd As New SqlDataAdapter("select bipad, issuecode, draw, net from histd ...more >>

Hi! My DataAdapter should Update a Typed Dataset that also has Expression Columns. Whenever I've some expression columns my Update doesn't work. I've played around for hours but can't find a solution. please help! Benedikt ...more >>

Hi, I'm making a stored procedure code generator in VB.NET. I need to generate the parameters variables, for example, to generate: @LastName nvarchar(20) , @FirstName nvarchar(10) , @Title nvarchar(30) Is there an automatic way to map the types recieved from the FillSchema to SQLServer Types...more >>

I already try something like that: SELECT INFORMATION_SCHEMA.ROUTINES.SPECIFIC_NAME, COUNT(INFORMATION_SCHEMA.PARAMETERS.PARAMETER_NAME) AS Expr1 FROM INFORMATION_SCHEMA.ROUTINES INNER JOIN INFORMATION_SCHEMA.PARAMETERS ON INFORMATION_SCHEMA.ROUTINES.SPECIFIC_NAME...more >>

I have an Access database with a public function in a standard module. The function works fine when I try to use it from Access, but when I try to use in from ADO.NET I get an error message that says the function is undefined. Can the access function be used in queries submitted via AD...more >>

Dears, I'm trying to get a return value of a stored procedure in VB.NET. The follwoing code is not being recognized. prspGetCompra = spGetCompra.Parameters.Add("@iHOSPEDE", sqlDBType.Int32) The .NET sent me the message : "Name 'sqlDBType' is not declared" I have declares the namespace ...more >>

Does someone have an example of accessing an Excel spreadsheet using ASO.Net? Thanks in advance for your assistance!...more >>

I cannot use neither UPDATE nor INSERT commands in ASP.NET (on Windows 2003 !!!!) application which use FoxPro database. When I try update table, then I get error: "Cannot update the cursor. Table <table> since it is read- only" But it isn't true. Win32 application successfuly wrote i...more >>

I'm having a strange problem/bug that I hope you can help me with. (Cross-posting since I'm not sure where exactly this issue belongs) First a little background: - Visual Studio 2003 (Framework version 1.1) and Windows XP on Client PC - Windows 2000 Server with SQL Server 2003 - Solution with...more >>

hai I am developing ASP.NET application in c#, when i am trying to execute the datareader to read the values from the table i am getting this error: ExecuteReader requires an open and available Connection. The connection's current state is Close Mine is a sqlserver 2000, and my connection string...more >>

in my DB program I use DataView intensively. there is a screen where the user could pick a record and do some more work on it on another screen. due to some data consistency between the multiple screen, I cannot pass a DataRecord to this second screen but I need to pass it a DataView. How c...more >>

Hi, I am prety new to ADO.NET and have been playing around with some Web Service examples, and as a result had some problems which I separated out into first a Windows app, and then a Web App. I use Windows NT authentication so in the windows app this connection string worked "workstation ...more >>

Hi, I am working with a dataset and want to update a row and then call the appropriate adapter.update method to update the source table. This is how I am updating the row: row = dataSet.Tables["tablename"].Rows.Find(rowId); row["col1"] = newValue1; row["col2"] = newValue2; This chang...more >>

Hi All, I have a DataTier in a remoting object which at the moment caches a simple db. Clients request filtered data which is returned to them in a new dataset which they display in a grid...all ok. If I update one field of one row (never a primary key field) I do something like: BindingM...more >>

What event is treggered when Row is inserted into table? Ondra. ...more >>