Pick up a book on beginning VB.NET. You're not going to find a single web page that describes all of the concepts you need in a step-by-step organized manner. You'll find all kinds of pages that describe single concepts and constructs, but inconsistently and without anything tying those concepts together. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

K so you did the check so now instead of txtqty.text>"2" use integer.parse(txtqty.text) > 2 Your code is comparing a string you can't use that for the > < operators

What's[^] so hard about it ? Christian Graus Driven to the arms of OSX by Vista.

rrrriiizz wrote: I dont know How to Use this command Did you read the documentation? Setting Server configuration options[^] - User Connection Option[^] Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog

You are welcome dude!!!!! ZAK

"i want to create a websetup project form my vb.net Project that one was created in windows application" How does the Windows app come into play here ? I don't understand, does a windows app create your website ? Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Again It shows error in Last End ie Incorrect sysntax near END, Line 17

Hello Mr.bob, i want to write trigger only, because i want to generate number with Preceeding alphabets like 'a001' 'b002' for taht only i need triggers usually in my graduation i wrote trigger in oracle 9 i. but i dont know with the sql server. any way thanks for your suggestion. can i get the above with out trigger Please let me Know. Thanks RRiiizzzz

Absoulutely. thankyou so much.

rrrriiizz wrote: but now i want to create a webapllication out put for the same project? Create a new Web Forms project. The code would be exectued on your IIS server, not on the client. You're really just creating a website. At least I'm assuming you're talking about writing a web-based application and not a web-based installer to install your Windows Forms application on the client machine. -- modified at 9:24 Saturday 8th September, 2007 A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

rrrriiizz wrote: str = "Insert into EmployeeMaster values('" & txtname.Text & "','" & txtfname.Text & "','" & dtdob.Text & "','" & gencom.Text & "','" & txtqual.Text & " ','" & txtbg.Text & " ','" & martcom.Text & "','" & txtadd.Text & "',' " & txtcadd.Text & " ','" & txtpho.Text & "','" & txtmob.Text & "',' " & txtemail.Text & " ','" & txtpp.Text & " ','" & txtpv.Text & " ',' " & txteno.Text & " ',' " & depcom.Text & " ', ' " & descom.Text & " ',' " & dtdoj.Text & " ','" & catcom.Text & "','" & mopcom.Text & "','" & txtac.Text & "','" & byes.Text & "',' " & txtbv.Text & "',' " & txtcdue.Text & "','" & txtcdate.Text & "','" & txtesino.Text & "','" & txtpfno.Text & "','" & expyes.Text & "',' " & detcom.Text & "','" & txtpc.Text & "','" & txtnc.Text & "' )" This is begging for a SQL attack, you should use parameterised queries, or, better yet, stored procs. Colin has an excellent article on SQL injection, you should read it. In C#, you can do this: string sex = (rdoMale.Checked) ? "Male" : "Female"; Does VB do something like that ? Basically, it depends on how your data is stored, if it's a bool use the check result of the appropriate button. Otherwise, you need to build your paramater based on radio button state. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

thank u ya. it was working fine. thanks a lot

rrrriiizz wrote: Am a beginer only Nothing like jumping into the deep end of the pool without knowing how to swim! You don't know what you're doing. This is what is making this description so hard. I'll simplify this as much as I can. When you create the barcode records, you don't have to put the barcodes in a DataGrid. Actually, you don't ever insert them into a DataGrid. All you do is create the barcodes using an SQL INSERT (OleDbCommand object) directly into your table, inside a for/next loop. When those records are completed, you requery the database using a SELECT statement and a OleDataAdapter object, to retrieve the records between the beginning barcode and ending barcode numbers, filling a DataTable with the results. You then bind the DataGrid to the DataTable. Your user can then start entering the information about each barcode into the table. When they're done, you write the information back to the database using the same OleDbDataAdapter you created to fill this table. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Please tell me the full details how to set per page connections?

Hi , You will need to host your 'portal' on a web server. There are several hosting services available....you can check them out..... Refer MSDN.... You need to create a web setup project to deploy your application on the web server...... If you fail for the first time , call it version 1.0.

please refrain from extending the word "hi" or "hey" Brad Australian - Christian Graus on "Best books for VBscript" A big thick one, so you can whack yourself on the head with it.

First just try opening Query Analyzer and try something like this but replace "value" with something real. Select * FROM EmpMaster1 WHERE EmployeeName LIKE '%value%' and if that works just translate it into something you can put into the code. Do the same for the number filter but you will probably need to do the cast to varchar in order for it to match if it is stored in the database as a number. CleAkO

Hello, You can use bit data type if your gender is limited to male/female. If your gender is more than 2 types i.e. male/female/unknown then you can use tinyint or int. Thanks Mehedi Hasan

does the data belongs to same year ? if so .... In SQL datepart(m, getdate()) returns current month number where clause can be used MonthField = datepart(m, getdate()) - 1

Thanks A lot it was working very nice. thanks for all the others for your reply. thanks