I have a database, 3 or more tables and a one of them with 3 or more columns.In this table i have ID column, Name Column, Date Column etc.I like to select one record for printing and give to the person one or more Receipt of payment (bill).But every time i like the number of Receipt to be unique. For all persons in my table and all payment.
View 1 RepliesI have a database with 3 or more tables. Each Table have 3 or more columns. In one of tables, named "Persons" i have ID column, Name Column, Date Column etc.I like to select one record (opened with click in new Form Window)for printing and give to the person one or more receipt (bill).Every person take every month one receipt of payment.
But every time i like the number of receipt to be unique. For all persons in my table and all payments.
Every payment need to show somewhere in Form for check if person has pay the months before this month.
The start number format will be 00000000 or 00.000.000 or A000000 and next will be +1.
Ask for further explanation.[URL]...I know how to copy text from text box and paste it to file in specify place and print this file.
How would I go about generating a unique receipt number in the following range:
GA00000-GZ99999? I am not allowed to use the 'I' and 'O' letters so GI00000-GI99999 & GO00000-GO99999 would be excluded. Ideally, I'd like to create this in T-SQL but can also do it in VB.Net. This number will be stored in SQL and I can access it prior to generating the next one. They do not have to be sequential.
Using VB.NET 2005 Express edition, I have a task to create a simple receipt using a Epson TM T88IV Thermal printer. I don't have any idea where to start. Can you show some good example or links that I can study to create an application?
View 1 RepliesI'm developing a policy administration system and I need to generate a unique policy in this formart
RP000000/HH
Where R is the Region i select from a Combobox, P is the product the client chooses and the auto generated six digit number and HH is the hour when the record was entered in the system. I want the auto generated number to be the ID in my ClientDetails table in my DB.Here is my code of what I have done so far.They want to be able to tell the region and the product by just looking at the policy number.
Private Function PolicyNumber(ByVal intRegion As Int16, ByVal intProductCover As Int16) As String
PolicyNumber = intRegion.ToString & intProductCover.ToString & "000000" & "/" & Hour(Now).ToString
End Function
[code]....
There were three similar questions in StackOverFlow but none gave an answer.. If have found why this error in occurring but don't know the fix. I am using Strongly Typed Dataset for my project which is created as a dll for DAL. I have added the Sql Server Table into this dataset using the designer and has created a DataAdapter
[Code]...
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim FILE_NAME As String = Server.MapPath("counts.vbi")
[Code].....
On Stack Overflow, I found the question Generate a receipt number in this range.In answers (from Adam Maras) I find this code (very interesting for me):
Private Const FirstReceiptNumber As String = "GA00000"
Public Function GenerateReceiptNumber(ByVal lastNumber As String) As String
If lastNumber.Length <> 7 Then
[code]....
But show me error in GenerateReceiptNumber().ow do I use that code to give me a receipt number in TextBox1 when I open this form?The receipt number must be +1 next time with Form_Load.
Our current solutions/projects have several classes combined into one file, I'm told this was done due to the slow compile times in VS
View 6 Replieshow to create table in visual studio 2008
View 2 RepliesI have a table called MEMBER with fields for mem_id, mem_name, mem_addr, mem_city,mem_state, mem_zip and another table called STATE with state_id, state_addr, state_name in Access 2007.On the Visual Studio 2008 form, there is a combo box for the state. The goal here is to display the state abbreviations, but use the state_id value for the mem_state (there is a foreign key between those two fields).The mem_state is defined as number, the state_id is autonumber. Under the mem_state definition in Access, I used the lookup wizard (on the database that is in the bin/debug folder) to set the following properties:
Display Control - combo box,
Row Source Type - Table/Query,
Row Source - SELECT [State].[state_id], [State].[state_abbr] FROM State ORDER BY
[code].....
I am trying to "make table" query. Below is my texT
[Code]...
I have an insert query set up for my VB table adapter. It includes all the columns in my table. Some of these columns are Nullable VARCHAR and DATE and I want to set them to null on the insert.
In my code I have two varaibles defined as Dim Sdate as nullable (of date) Dim Sdata as nullable (of Char)
And I set them as follows:
Sdate = nothing
Sdata = nothing
On the insert query the "Catch" is activated and displays "Nullable Object must have a value"
I Sdate and Sdata have values, then the insert works just fine.
I am new to VB and trying my hand at the below code. I am trying to determine the number of records for each possible combination. Depending on the outcome of the number of records groups may be combined. I am not able to find the record count for each grouping. Can you please look at the code below and suggest what I am doing wrong?
[Code]...
I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
i have create a software for my college which is document management. well am doing good so far up to now where i need to upgrade my database what i mean ?
in case i need to make any changes to my database i don't want to enter the database and create new table or add new fields to existing table to my current database,i would like to do that throught visual studio 2010 programaticaly. something like an additional application where i will choose my database path and the application will upgrade the database with new tables or new fields .
i would like also to ask, in order to create database,or if you already have the database and you like to just open the connection to it programaticaly and add new field ,or relate some table ,you have to work with different librarys? Like ADOX,DAO etc ? and other.?
I am trying to figure out how to add a theme to my excel worksheet before saving it. I have found this code to change the cell color but have yet to find anything to change to a pre-default excel table format (the Table style light 2 theme)
[Code]...
How can i just select all the cells and place that Table style light 2 onto them all using VB.net?
I have a database that has two tables in it. One is a table of items (table1) and the other is the table of current items (table2).On form load I need to generate a random amount of the items from table1 and populate table2 with them. I was trying to do something like this:
[Code]...
WebMatrix is a web development and deployment tool by Microsoft so how is this compared to Visual Studio? which Use C# Razor Syntax is that more better coding.
[Code]...
I have to compile projects which was compiled in Visual Studio 6 in Visual Studio 2005. When i compiled i got a set of same error. I opened the project for VS6 by selecting File->open->project/solution and tried to build a solution by Build option but i am getting the following error.
[Code]...
Is it possible to open visual studio express files with normal visual studio?
View 2 Repliesi am working on a project and i want your help for something. I use access database and visual studio vb.Net. In one of my forms i want to get records in a datagridview , between two dates . For example , i have the table Sales and i want to see all my sales between the two dates.
[Code]...
In my project i have different users lets say 100 users. My problem is most probably authentication. What i wanted to achieve is this;1. When user1 creates an account (saved database) with the following details
name: user1
lastname: user1
When he/she logging in into the system that information must be viewed by him ONLY. (authentication)
2. If user2 logging in he/she can't view the information of user1 (obviously).
I have already posted this assignment . The assignment is to create a VB.NET program that calculates the monthy mortgage payment for a $200,000 mortgage with an interest rate of 5.75% for 30 yrs. The program compiles and the interface window comes up but when you click the payment button nothing happens. fix this program because my other 4 assignments are based on this progam. The Visual Studio project file is attached.
Public Class Form1
Private Sub Form1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Click
[code]...
I developed a small application which accesses a MS access database on my computer using VB.net. I developed the program on windows xp 32 bit. At the moment I am using windows 7 64 bit and the program simply will not run. I get a null reference exception when I try to do anything to the database. I have narrowed this down i THINK to the db provider. I was using Provider=Microsoft.Jet.OLEDB.4.0; and tried using Provider=Microsoft.ACE.OLEDB.12.0;. Neither seems to work. The path to my database is 100% correct. This is the error I am getting:
Null reference exception was unhandled.Object reference not set to an instance of an object.
Like I say the program runs fine on the windows xp machine. If it helps the access database file extension is mdb.
I am very confused about the database type to be used in my vb.net application. I have been using SSCE database, but for that user has to download and install SSCE, which many of my users do not want. If I use Access, the security issue is very very serious.
View 1 RepliesI am trying to control an access database with my program.I am using Visual basic.net as a programming language.It's look like I can do a simple (read-navigate-update...) without writing code in Visual Studio 2008 by:1- new windows form application project.2- loading my data source (table).3- drag and drop to my form my table from Data ources tab after changing it to (Details).4- Visual studio will automatically make> ( data set - Binding source - table adapter - table adapter manager - binding navigator )
View 4 RepliesI've been googling to find a guide on how to access a database with visual studio.I cant find anything complete or up to date. I should point out that I dont have a great deal of experience with SQL.I'm not really 100% sure where to start. Most of the guides I've found tend to assume your accessing an existing SQL database and I need to set one up from scratch. I'm not sure if I'm even setting SQL server up correctly. point me in the right direction on where to get started. A good, up to date tutorial would be great.
For my purposes the SQL database will only be written to from the local machine but there will also be another machine writing to this database.I'm currently using Visual basic Express 2010 and SQL Server Express 2008 R2, mostly because they are the most recent when I googled it.
Want To connect to database using vb .net in visual studio and check if it has connected to sql db or not...If it has connected i want to fetch some data from db?
View 3 RepliesI have a very strange problem with the application I wrote.
It is a database application using SQL and Visual Basic 2005 from visual Studio.
I get an error Value cannot be null. Parameter name: context.When I get this error which accumulate 3 or 4 times in design mode, on an open form. some of the properties disappears for the textboxes like dock, buinding and so on. Does anyone knows what this error means.