Hi, I have copied the data in a new dataset "ds1". Please tell me how to copy this "ds1" contents into Access Database. I am trying with following: Dim da2 As New OleDbDataAdapter Dim conn As OleDbConnection Dim cmd As OleDbCommand = New OleDbCommand() conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\alldata.mdb;") cmd = New OleDbCommand("SELECT * FROM Denver", con) da2 = New OleDbDataAdapter(cmd) da1.Fill(ds1, "Denver") But not able to populate the Access database. Can You guide me how to do this?? Thanks, R.S.

Sorry By mistake.... I made the statement "But not able to populate the excel sheet." What i was: "But Not able to populate the Access Database". Thanks R.S.

Here is another alternative - no better, no worse just different. "SELECT TOP 1 [Closing Date]) FROM client_details WHERE [Closing Date] <= '"+textbox.text+"' order by [Closing Date] DESC" As Luc suggested use parameterized queries - this is IMPORTANT. There are usually a number of ways to sole a problem, try both and look at the execution plans to decide the better solution. Then throw an index on the close date field and see the difference! Never underestimate the power of human stupidity RAH

The DataTable object has a .Select in which you can specify what would a WHERE portion of SQL and it will return an array of DataRows. This way you can pull a lot of data from a database just once, then filter it different ways quickly when you get it back. For your code above it would work something like this: For Each row As DataRow In myDataSet.Tables(0).Select("Name='" & search\_text & "'") 'Perform your matching found task Next

Thanks....Any sample example/link will be appriciated.

As far as I know, the Setup and Deployment project doesn't create patches. You can it it to upgrade a previous verison of the package, so long as you have the ProductCode that it used, then the current one will uninstall the old version and install the new one. I don't use the Setup and Deployment project, so I'm surely no authority on it. I use real setup and deployment tools, such as Wise Package Studio, InnoSetup, and InstallShield. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

jeshra279 wrote: I purchased a 3rd party web hosting plan Its not Free right..? So ask them .they can give better support then us..! When u Purchase from them, they will be support team from the site hosters..! LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

I have created a setup & deployment project and installed the exe on my client's machine. So there is no way to update that file on my client's machine. One way is to recreate the whole SEtup & deployement project with the updated file and re-install on my client's PC, but I dont want to un-install the current version; I just want by anyhow if I can update the application.

DevExpress[^] :) I are Troll :suss:

Use parameter field for your requirement, assign the parameter value in run time when you give the value by calender control

Your requirement isn't exactly clear. You say you're putting the .EXE file on the Desktop?? Easy. Go intop the project properties and, on the Application tab, there's a little place where you can change the icon used. It gets compiled into the .EXE and NOT done at installation time. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

You can check with crystal reports, from report field explorer, there is a field called Group Fields, there if you give your field as a group field, then your reports will be seperated by the same manner.:thumbsup: For Details, suppose your report like S.No..Name...............Category 1.....Mr.Dave Kresoik....MVP 2.....You................Learner 3.....Me.................Learner Now I added a Group By Field as Category, then PAGE-1 S.No..Name...............Category 1.....Mr.Dave Kresoik....MVP And PAGE-2 S.No..Name...............Category 1.....You................Learner 2.....Me.................Learner

What he is trying to say, that it is not necessary that you create a ASP.NET application. Your current win application needs to have one kind of communication with the centralized database. For this you could use a webservice installed on that centralized server that performs the communication between the outside world and the database. And your application needs to be modified so that it can consume this webservice. In other words consult, insert, update and delete. It's nice and clean but you should think of alternatives before starting of. Communication with a webserver can expose data, you can't loose the security behind this idea.

Instead of cmd = New SqlCommand("SELECT [Client ID] FROM client_details WHERE [Date of Joining] = '" + dateofj + "'GROUP BY [Client ID]", con) use: cmd = New SqlCommand("SELECT [Client ID] FROM client_details WHERE [Date of Joining] = @DateOfJ GROUP BY [Client ID]", con) cmd.Parameters.AddWithValue(@DateOfJ, YourDateValueHere)

1. Aren't your 4 PC's on a single network? If they are, all you need is to set up your server to allow remote connections. Then all your PCs should be able to connect to your database. If they are not on same network, but all are connected to internet, still you can connect to your database. Here[^] is a link to help you. 2. I don't think the code would change. 50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

... 50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

I have already inserted "EmpID" as 1,2,3,4,5,6,7,8,9,10,11,12. But when i see the column data of table, i found that the data is arranged like this: 1 10 11 12 3 4 5 6 7 8 9 Since, the data is already inserted in the above order, i found that in crystal report the same format is coming...but i want the order in exactly ascending order in report finally, if not possible in database. Can someone help me on this?

If you have a SQL Question Post here General Database http://www.codeproject.com/Forums/1725/General-Database.aspx[^] in the Query that you use to display the Grid with , add the Following line of SQl Order by ID ASC Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Select MAX(cast(EmpId as int)) from TblName OR Select top 1 EmpId from TblName order by EmpId desc :) Niladri Biswas

Please see my requirement below carefully: need immediate help. I have 2 forms, main Form1 and a loginform. When I start the application, first "Form1" is loaded and then with a button click, user can load "loginform" if required to enable/disable some features/controls on Form1. The sequence is like this: 1) Load main form Form1 2) click a button on Form1 3) Load the loginform. 4) enter user/pwd and click OK button 5) enable/disable "GroupBox" control on Form1 if login sucessful. For this, I made a click event for OK button in loginform, so once user clicks the OK button, I want to call one function which is defined in Form1 as a Public, which enables/disables the "GroupBox" control on Form1. The code structure is like this: in main Form1, i created a function like this: Class Form1() Public Function DoThis() ' Function to enable/disable GroupBox control ....some task... End Function End now in loginform, in the click event for OK button: Class loginform() Click_OK() { DoThis().... 'call function DoThis() of Form1 } End I am not able to call the DoThis() function in loginform. Please suggest me with a piece of code how to do this?? Please remember that Form1 is my main form which is loading first. If anyother way is there to make a password protected feature for GroupBox control in Form1, it will be highly appriciated. Hope my problem is clear..Thanks.