I think the problem is with your connection string. Follow the link find your desired one. http://www.connectionstrings.com/[^] Enjoy :)

No, only 2nd time :sigh: thatraja **My Tip/Tricks My Dad had a Heart Attack on this day so don't... **

Here is an excellent link with tips for Excel Automation from .NET. But my suggestion is not to use Excel Automation. For detailed explanation check Excel Interop issues. Try to find some 3rd party library that best suites your needs. I use GemBox.Spreadsheet library for reading and writing Excel files for some time now and it is great. It is very fast and easy to use.

check your quotes. :) Luc Pattyn I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages Local announcement (Antwerp region): Lange Wapper? Neen!

Why do you require FTP location to point your database. FTP is a protocol used to pass commands which can download or upload some files to a specific location. There will not be any direct connection to an FTP file. You only can buffer a portion of a file using FTP file commands. So in your case there is no way to handle ftp data source. Try downloading the file ConReg.mdb to your current location or use Unc path to point the mdb file. :) :) Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

hello App_Code.compiled App_Code.dll App_Web_oyclc8-d.dll These are files in my bin folder and i think so if i delete these folders the application would not work.. i tried deleting these files in my remote computer and then run my default.aspx page in browser but it the same error continue...

That makes no sense, it's your app, if the user can delete a column you must have written code to do so. In there you must identify the column index, deal with it. Never underestimate the power of human stupidity RAH

Change your code to something like this: Dim Tot As Integer = 0 For i As Integer = 0 To Me.lstview2.Items.Count - 1 Tot += CInt(Me.lstview2.Items(i).SubItems(1).Text) Next Me.Label1.Text = Tot you may have to change then 1 in 'SubItems(1)' to the column where your numbers are stored. Tosch

hello Dim Tot as integer = 0 For i as integer = 0 to listview1.selecteditems.count -1 Tot += cint(me.listview1.selecteditems(i).subitem(1).text) Next me.label1.text = Tot The code u suggested just gives me the one by one value of items present in listview eg :i placed this code on listview double click event so it just give me value 1 when i double click on selected row and then 2 and goes on. but i want the total of the items present in row and display it in label for eg:suppose there are two listviews both are having columns as Rupees but the first one is having Rs in it like(100,200,300 etc..) what i want is when i double click on any of row of first listview it adds the items preset in the selected row one by one and displays it in label like (100+200+300) which gives result as 600 in label simply saying i want total of text present in the listview so please suggest if some have any idea. Thank You. :) :) :)

Did you try that What CG has already Suggested ? You have installed IIS before or After Installing .NET Framework ? It seems, your IIS is not registred with ASP.NET . Run the following command : C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i [ Note : I assumed the your framework has installed the following location ] Then Try. This will resolve your issue. cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net View My Recent Article

I am guessing you did this in the past via some code you found online and have no idea how it worked. The Excel stuff is not built in, you need to download the toolkit for it from MS. Also, you need Excel to be installed. You will create an Excel sheet on the server and users will download it ? Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

nazimghori wrote: I having one windows application to be developed in VB.Net 2005 Why? use 2008 and target the .net 2.5 framework if you can't use the newer ones nazimghori wrote: the reports requirement is in MS word so please :confused: so you just have to create word docs? nazimghori wrote: I am having my database in Ms Access 2003 Again why? there is a free sql server version, much more stable, faster,... Unless you really have no other choice I wouldn't go for access (there are cases where its usefull but not many) nazimghori wrote: memo field which has one image Memo ??? surly it should be OLE-object field. + Storing an image in db is very space consuming. Better would be to store the path to the image in the db and the image on the hard disk just as any normal file. nazimghori wrote: I want to load that image from database to word file. Amazing isn't it what google can do for you[^]

What i meant by referring to c and assembler is that they are also not supported, could nto be, it's just language, not a product, like VB6, but compilers for them which people use are in most cases 10 years old, and they still do the job. So, VB6, or basic language in its pre-OO age is still working and is funcitonal (well, maybe win7 does not support it). So, it is no more outdated than any other. But all of this are "complete", it's in stable state, and nothing changes. Now, in .Net we have something predefined which can change at any time, while in old VB6 you did have commands, and that is about it, something which did never change, just new ware added up over years. While .Net brings a lot of classes with each release of new framework version. I use .Net, and sure it's 10 times easier to write code in it, for a "real" project would not go to VB6, since its all much easier to be made in VB.Net. Why did i mention VB6 in first place? Well, back then VB programmers did have it's language, IDE and good support. VB.Net? It's got nothing to do with VB, really nothing, it was MS evil plan to make C++ and VB programmers think same way, and so we do, anyone who can work in VB.Net can work in C#, and vice versa. So, what happend is not that VB evolved, he is gone. Why did i say it's nice to see someone still using VB6? Well, if anyone wants to use, go for it, vb6 is not bad, never was, and it's last real basic :rolleyes: And those that did not work in VB6 might think that it sucked, but, my opinion is that it was maybe to simple for those that used C++ or something similiar. You could do all what one could do in C++, or C, except that it depended on runtime (but so did VC++). Oh, that is a long post. What i want to say is, if someone wants to use VB6, don't tell him not to. I'm sure he does know that VB6 runtimes will not come with never versions of windows. Btw, embeded systems? os? This is already possible using .Net (not all classes suported yet) :omg:

Well, the save fails because you haven't provided a file name. You gave it the anme of a folder, but no filename... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

nazimghori wrote: format of my date is dd/MMM/yyyy The format of your sql or the format of your datetimepicker? nazimghori wrote: If optn1.Checked = True Or optn3.Checked = True Then You dont need to compare a booleanvalue with true or false Just do it like this: If optn1.Checked Or optn3.Checked Then Or even better: If optn1.Checked OrElse optn3.Checked Then nazimghori wrote: sqlstr="select * from des_mast" sqlstr = sqlstr & "where pickup_date between '" & Me.dtp1.Value & "' and '" & Me.dtp2.Value & "'" After concatenating this, i dont think youll get a space between des_mast and where, youll get des_mastwhere Also, have you tryed using # for the date values: between #12/12/2009# and #12/12/2009# If you still cant get it to work, you can test manually the query in sql server managment studio Alexei Rodriguez

Change this SQL statement to a parameterized query, then you won't have to worry about the format of the date values coming from the controls. It'll be handled for you and will also prevent some injection attacks in your code. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

nazimghori wrote: now i want to set the width of particular cell this works properly Columns("A:E").ColumnWidth = 20 nazimghori wrote: now i want right and left justification of cell like cell "D" If you want it like a particular cell try this... Range("F4").Select Selection.Copy Range("H4").Select Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False ------------------------------------ "Possessions make you poor, wealth is measurable only in experience." Sun Tzu 621BC

Hello, do you use your database in your form? You won't be able to copy a open database. Regards: Didi

..it should read somthiing like: Sub fill(ByVal tbcon As TabControl) Dim cnt As Control For Each cnt In tbcon.Controls If TypeOf cnt Is ComboBox Then Select Case **CType(cnt, ComboBox).Tag** Case 0 cnt.Items.Add("NP") cnt.Items.Add("ND") cnt.Items.Add("FP") cnt.Items.Add("FD") End Select End If Next End Sub Otherways the compiler doesn't know 'Tag' Regards: Didi

So you mean each time the button is clicked the value of TextBox2 needs to be increased by one? Here you go: (NOTE: Make sure the user only inserts a numeric value in TextBox1, if not, an exception will appear. Also, in the Designer set the Text Property of TextBox2 to "1") Private Sub Button1_Click(..) Handles Button1.Click Dim dec as Decimal = TextBox2.Text dec+=1 TextBox2.Text = dec End Sub Motivation is the key to software development. modified on Saturday, May 9, 2009 10:43 AM