Search DaniWeb - custome

how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by haqayyum Dear friends I am using vb 2008 with access 2007 at the backend. I want to make custome invoice id like Inv0001. when make next invoice the id should be Inv002 and so on. add 1 numeric value in the previous one. Please help me any help will greatly appriciated Custome CreateUserWizard and Login With my own Database 14 Years Ago by bharanidharanit Hello, I want to use CreateUserWizard. Here i want to add some additional fields in that wizard. Also i want my own validation (even for password format) in this wizard. Also i want this to be stored in my sql database, instead of ASP.NET Website Configuration default website (as it is very larger of around 10 mb). How can i do this? So when… Re: Custome CreateUserWizard and Login With my own Database 14 Years Ago by reach_yousuf [QUOTE=bharanidharanit;1078010]Hello, I want to use CreateUserWizard. Here i want to add some additional fields in that wizard. Also i want my own validation (even for password format) in this wizard. Also i want this to be stored in my sql database, instead of ASP.NET Website Configuration default website (as it is very larger of around 10 mb… Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by GAiXz get the max value of your ID in your database then add one like this SELECT MAX(ID) as MAXID from tblID Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by Reverend Jim to add the leading zeroes you can pad the number out by nextid.ToString("0000") once you have maxid. You can generate the next id in the select by select max(ID)+1 as nextid from tblID Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by haqayyum my following code will only show 1 numeric value in TransIDTextBox however i want to showing this format like 00001 or 00002 Private Sub transIDload() ds.Clear() da = New OleDbDataAdapter("Select * FROM Transactions", dbcon) da.Fill(ds) da.Dispose() 'dbcon.Close() If ds.Tables(0).Rows.Count &… Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by Pgmer Get the MAX(ID) from table and then append 0000 to it and show. Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by mani-hellboy [QUOTE=Pgmer;1755034]Get the MAX(ID) from table and then append 0000 to it and show.[/QUOTE] Forgot the one thing to find the length of ID there only easy when you add 10,11...,100,101,....,1000,1001... [CODE] temp_id=string.Empty; for(int i=0;i<(5-id.lenth);i++) { temp_id+="0"; } temp_id+=id; [/CODE] Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by poojavb [QUOTE=mani-hellboy;1755067]Forgot the one thing to find the length of ID there only easy when you add 10,11...,100,101,....,1000,1001... [CODE] temp_id=string.Empty; for(int i=0;i<(5-id.lenth);i++) { temp_id+="0"; } temp_id+=id; [/CODE][/QUOTE] I have done the following to get the custom ids like DOC1, DOC2, DOC3 … Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by Pgmer But i prefer to have primary key as integer not as text or varchar. indexing will be done on primary key if it is text performance will go down. U can have one more column in whci u can save the data Doc1,Doc2 etc.. Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by poojavb [QUOTE=Pgmer;1755142]But i prefer to have primary key as integer not as text or varchar. indexing will be done on primary key if it is text performance will go down. U can have one more column in whci u can save the data Doc1,Doc2 etc..[/QUOTE] I have posted for getting the string Doc1 and Doc2......and so on.... Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by Pgmer [QUOTE]in the DOctormaster table I have the ID field as the primary key and datatype as text.... [/QUOTE] Data type u mentioned is of varchar which i said not preferable. Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by mani-hellboy [QUOTE=poojavb;1755080]I have done the following to get the custom ids like DOC1, DOC2, DOC3 and so on.... I have create a table which will store the number in it.... and the master table will just save the value in database with string eg. I have a table as IDvalues with one field that is DOCValue and datatype number with value 1 in… Re: how to create custome id like inv0001 or inv0002 in vb.net 2008 12 Years Ago by Reverend Jim But that doesn't get you leading zeroes. For that you need to apply formatting such as nextid.ToString("0000") By the way, while it is true that there is a performance hit when you use a varchar as a primary key, it will likely be negligible unless the database is very large. Another person with Javascript links that will not open.. 19 Years Ago by blackjpb … had Enable active scripting turned on tools /internet options/security/custome level 2. Downloaded a file from [url]http://www.microsoft… problen with installing redhat 9 and vmware 5 18 Years Ago by osos.bg … 7 GB of free disk space and i've choosed custome installation, the selected packages are about 2.8 GB and… 404 Custom Error Page Not Working in Mozilla Firefox 17 Years Ago by mrhaana … fine in Internet Explorer i.e: succesfully redirecting to the custome error page. But it is not working in Mozilla firefox… AIHS help 16 Years Ago by vjw757 …://yabsoft.com/aihs-feature.php[/URL] I have had a custome design made for this script. Now the thing is i… Re: AIHS help 16 Years Ago by autocrat Okay - I think I get it (you had "custome"... and I read it 3 times as being "… Creation of file types and encryption 16 Years Ago by mexaros … can I find resources on how to create my own custome file type? We are using javascript, ajax, and php(this… Why are videos not viewable with IE but with Firefox? 16 Years Ago by vishakha_ate … tried in Internet Options, security tab i have changed the custome levle of Internet zone. Display Video and animation on a… Help With this code 15 Years Ago by Stefano Mtangoo … all values respectively (prod_name, prod_id, prod_quant) use while loop until custome says exit""" while True: tuple1 = get_prod() name… Cannot update Windows XP 15 Years Ago by sampson Windows XP Pro. SP3. IE7. Have always been able to update this rather new computer. I get to express or custome. As always I hit express. A window comes up that says something about control panel but it goes quick but I believe it states to check the time and date is correct on computer. I have done that and that was correct...help Re: Cannot update Windows XP 15 Years Ago by sampson … is what appears very briefly when I hit express or custome option for update. Picture 3 is what appears in the… How to set custom papersize to printer from code in vb.net 2005 13 Years Ago by choudhuryshouvi … except the reports specially which needs to be displayed is custome mode. we have used some code to dynamically set the… Php vBulletin Question 13 Years Ago by -==Zero==- … : 1000 [COLOR="Red"]Gold Point[/COLOR] : 5000 This Custome Field Appear Normally In Postbit_Legacy I Need To Know How… help with modules 12 Years Ago by bomko i have this 2 custome modules and when i try to call module turtle i … PHP Themeing Engine 12 Years Ago by Stefano Mtangoo … I'm trying to figure out how to make simple custome theme engine for my custom PHP CMS. I want to… How to set up of custom html default error pages 12 Years Ago by tadisaus2 … receive an error. However, I want to set up a custome page to replace the default pages that error throw. How… Windows Grid Scroll Coding 11 Years Ago by hirenpatel53 Hi all I have Placed One Custome button on Grid Withe refference of the location of rows …