Robby

Peter, why not pass the value of sName into ReturnGroup()

It happened when I moved the Excel file to another part of the HDD. For some reason it makes a copy of it in a local section of VS. I'll get you the path tonight so you can try it.

Right on Nerseus, I forgot to consider the DataSet aspect, that's much easier, thanks.

Hmm, I had the same thing happen today, I was using an Excel object. I don't know what it could be in your case.

You will need to track the changes yourself. When the user enters a cell in the Datagrid, keep all the info for that row in a variable or array, then if they actualy make a change, you can write to a Log file or table. If you are using text boxes, the just hold the Before data in a varible as they get focus.

You can put ... mailto:you@somewhere.com

Are you trying to add a Web Form to a Windows solution?

If you Insert 1000 IDs, that means that there will be 1000 rows with no data in any of the columns except for the ID field.

Here are few ideas... http://www.xtremedotnettalk.com/showthread.php?s=&threadid=69919

You can let Access AutoIncrement the ID for you.

I watch TechTV all the time especially Screen Savers.

Right click on references in the Solution explorer, select Add refererences, in the COM tab select the object. If it's not in the list, you can browse for it once you Register it on the PC. (But I think that once it's registered it will appear in the dialog on its' own.)

Yeah, use the Readline method in StreamReader.

"I understand that the namespace System.Data.SqlClient offers increased performance when using SqlServer 2000" Yes it does. How significant? Apperantly enough. If you use System.Data.OLEDB, you would only need to change the connection string for SQL Server. You could easily make two seperate classes, one OLEDB and one SQLClient, (this gets you the best of both worlds.)

The code looks fine, are you sure about the contents of your Connection String?

Daspoo, he already said that IIS is running.

Can you explain further, I didn't quite understand.

You can use the NavigateTo method of the Dataset to bypass the link to a table. I didn't not see your code as it is not formatted properly in that text file, you can just simply the code as part of your post in this thread.

Try this... dtpFrom is a DateTimePicker cboDoctor is a Combo ArchivedByCriteria is a Crystal Report ReportViewer is the form which contains a CrystalViewer CrystalReportViewer1 is the viewer on the ReportViewer form Try Dim rpt As New ArchivedByCriteria() Dim frm As New ReportViewer() rpt.RecordSelectionFormula = " {Archived.Completed} = 'Yes' AND {Archived.Doctor} = '" & cboDoctor.Text & "' AND {Archived.Dates} >= Date('" & dtpFrom.Value.ToShortDateString & "') AND {Archived.Dates} <= Date('" & dtpTo.Value.ToShortDateString & "') " With frm .Text = "Archived Appointments by Criteria" .CrystalReportViewer1.ReportSource = rpt .ShowDialog(Me) End With Catch ex As Exception MessageBox.Show(ex.ToString) End Try

I'm posting the following on behalf of a colleague.... I am trying to decide which data format to work with from ASP.Net. Currently my Business layer assemblies communicate in XML. An XML request is formulated within the UI code and sent to the BusinessServices layer, which in turn processes the XML and returns an XML reply. This method was chosen for a number of reasons: 1) complete decoupling between the UI and Business Service layer 2) Before .Net and the advent of WebServices, it was a way for external clients integrate portions of the applications via this XML API Question 1 --------------- Now that clients can communicate with my application via web services, should I continue to communicate with XML in both directions or does this add overhead in my Business services layer? Having to validate the XML and decode it. Question 2 --------------- Formulating XML, sending it to the Business layer and then decoding the reply adds some overhead to my UI layer. Should I continue in this manner or pass dataset's (or arrays or whatever) back from the Business Services layer and work with that? Thanks for reading DS. :)

Can you explain further

Download it here ... http://www.microsoft.com/downloads/details.aspx?FamilyId=D7158DEE-A83F-4E21-B05A-009D06457787&displaylang=en

You said ... the endusers to be able to click a button and create his/her own queries using a windows form. " Will you provide Field names (in a ComboBox) and a textbox where they can enter a value, or something like that? I may have miss-understood, can you explain.

You can add a Where clause to you sql... "Select * from Student Where Student = 'Smith'"

You have too many digits im all your values (fff8f9d9).