Generate New IDs In Database Or From Classes?
Jul 23, 2009
When generating new IDs as such employeeIDs, i typically let a store procedure pass the Highest EmployeeID entry to the DB and i create a class to generate a new EmployeeID based on this returned ID from the DB. In industrial based applicaiton, do they write a class to generate a new ID so that new ID generation happense in the Business classes or do they create triggers to do it so that the new ID generation happenese in the database?
View 9 Replies
ADVERTISEMENT
Sep 29, 2010
I want to create program in vb2008 express with ms access database. Can somebody help me so i can learn how to program using classes hard coded. I have learned vb6 before but it has a big difference on vb2008.
I have a database named "DATABASE" in ms access 2003 and the details are: Table :
EMPLOYEE(EmpNo, EmpName), DEPARTMENT(DeptID, DeptName), CATEGORY(CategoryID, CategoryName), SUPPLIER(SupplierID, SupplierName), ITEM(ItemID, Itemname), ITEMLIST(ItemListID, ItemID, ItemDescription), INVENTORY
[CODE]...
All the CAPITALIZED name are Table and all items inside the parenthesis are fieldnames. I don't know where to start on working on this RECORDS. I was able to understand visual basic 6 a bit, and i am trying to apply the coding to VB 2008 but all i get is errors. I am hopeless now and i need help to be able to start my programs. If someone can give me a sample code, i think i would be able to trace the line of code to be able to understand it. I am currently an inventory manager on the small company i was working with and i like to organize my record by using database.
View 1 Replies
Jul 28, 2009
i've been previously using Visual Studios built in wizards for manipulating data access to and from an MSAccess Database, however just recently i coded my own classes and connections to the database, ive been able to select, update and delete records effectively however my problem comes with inserting records.
I have a 3 tiered table database:Tbl_PO, Tbl_Parts, Tbl_Shipments each po has multiple parts, each part has multiple shipments.when i insert a record into the tbl_PO, i need to retrieve the ID used on that insertion.
View 4 Replies
Aug 12, 2011
i am new beginner of visual basic, could you give me step by step to generate report using visual studio 2005 and my database is sql 2005.currently i am using a windows aplication..
View 1 Replies
May 3, 2009
I am coming from VB6 and I am starting to convert an existing VB6 code to VB.Net. What tools can I use to automate this task?
View 3 Replies
Jan 11, 2011
This in ref to this question that i asked but never got answered ASP.NET 4 ACCESS DATA TO APPLY TO NavigateUrl but suppose thats redundant now.
I need to generate dynamic URLs from a database in code behind and then use them in a list view but i cannot find anywhere on the internet or in my book that covers something like this.
Im getting data out using below in a code behind page:
'portfolio navigation data
Dim rdrPortfolioNav As SqlDataReader
Dim cmdPortfolioNav As SqlCommand = New SqlCommand()
[Code]....
how to loop through each record on the code behind page to generate all the urls then how to show these on the actual page within the list view.
View 1 Replies
Nov 17, 2009
can dot net generate class from database table ? means if i have a 1 table & want to create class for 1 table like insert, update, delete functions & properties(for table columns)
View 1 Replies
May 10, 2010
I am creating an Add-In that I want to create classes and forms based on a database structure. I can't find any information anywhere on how to programatically add code to classes. I know I can write out the files and add them to a project, but that would limit what I can do in the future. I would like the possibility to update a function in the future which would be impossible writing out a file and loading the whole thing back in. It would destroy any modifications made to the class, and since this Add-In will only be creating a framework, there will usually be modifications.
I got this line from the macro recorder:DTE.ActiveDocument.Selection.text = strDACode
But I like to keep Option Strict on, and this is late bound according to the IDE. There seems to be very little help on the IDE and how to use it creating Add-Ins. If I overlooked something please point me there, but I can find nothing. I don't know if it can be done, but I was able to do it in an Add-In for VB6.I would also like to add controls to a form, so if anyone can point me somewhere where it explains
View 3 Replies
May 8, 2012
I have limited knowledge on VB coding. I am now creating a system which allow customer to select exhibition event and booth number they want and next reserved which day they want to rent.By default, in GridView control can add checkbox Field but it only generate 1 checkbox for 1 row of data.
As state in the title, I have no idea how to generate the checkboxes for every field in database call D1,D2,D3,D4,D5,D6 and D7, each carry value 0 by default.Now I want every single field have a checkbox to allow customer select which day they want to reserve and retrieve their checked value to stole into corresponding D1-D7 field, checked value will update value 0 to 1.Next, how should I coding to store the checked value into database? in default.aspx or default.aspx.vb? generate checkbox instead of using gridview?What I want
My coding:
<%@ Page Language="VB" MasterPageFile="~/MasterPageMember.master" AutoEventWireup="false" CodeFile="member_view_event_list.aspx.vb" Inherits="member_view_event_list" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">[code].....
View 2 Replies
Jan 27, 2012
I would like to generate a tracking number as primary key for my database.
There will be total 12 letters for each tracking id. Example: 2012010001-1
The "2012010001-1" is actually from combination YYYYMMxxxx-v where YYYY is the current year, MM is the current month, xxxx is the auto generate number(increment) and -v is the version where it can be -2 -3 but using the same YYYYMMxxxx.
For both YYYYMM is not a prob as i can get the value from Date.Today.Month/Date.Today.Year. But how am I going to ensure the xxxx is an auto increment but will be reset back to 0000 every new month.
For example:
2012010000-1 (Month January, so start from 0000)
2012010001-1
2012010002-1
[Code].....
View 1 Replies
Aug 31, 2009
I am trying to generate an excel report where the data is coming from access database using VB.
View 2 Replies
Jul 30, 2011
I was wondering if it was possible to generate fields or details (they are called in IDE) of a xml tables .When you create a database than go into the Datasources and find the table you want than there is a drop down box with datagridview and details.When you select details and than drag the table over to your form ,the IDE creates or the nessiary fields to add and view the data.
If Possible ,How do I do this Using a xml file and at runtime .I have already managed to create the xml as a dataset and view it in a datagridview .But how do I create the fields for the tables .BTW the XML has Multiple tables?
View 1 Replies
Mar 16, 2011
I am a beginner in ASP.NET using VB Code. I want to generate a Unique reference no by concortinating three column fields.[code]...
View 1 Replies
May 9, 2012
I want to generate checkbox field using GridView and system will calculate how many field to display according to number of totalDay. If totalDay stored in database is 7, so upon calling the eventID it will generate 7 checkboxes, D1-D7 checkboxes field will appear; if totalDay is 5, it will generate 5 checkboxes, D1-D5 checkboxes field will appear.
In PHP, I manage to auto generate number of D field I want according to value totalDay. But I do not know how to code in VB. The PC Fair Event has duration 7 days, so it will display 7 checkboxes after user select event and booth to book: The Carnival 2012 has duration 5 days, so it will display 5 checkboxes after user select event and booth to book:
The code in PHP which can generate the checkbox:
$query = "select * from booths, eventinfo where booths.eventID=eventinfo.eventID && booths.eventID = ".$id."";
$_SESSION['EVENT_ID']=$id;
$result = mysql_query($query);
$result2= mysql_query($query);
[Code] .....
View 1 Replies
Jan 23, 2012
I have two classes, one nested in the other. [code]Neither "Name" or "ID" are unique between operations and records.I wish to construct a dictionary using LINQ = Dictionary(Of String, Of List(Of Integer), whereby the keys are uniqe examples of Names in my collection and the values are the collective set of distinct IDs that are associated with those names.
View 2 Replies
Jun 13, 2012
How can I structure my classes so that the user interfaces though a single class while the supporting classes are hidden from their view? I think its best understood in an example:
Public Class MyInterface
Public Economic as EconomicClass
Public Sub New()
MyBase.New()
[code].....
So you might ask why am I even separating them? It's strictly for others who will be working with this interface. I need to funnel them though a logical structure:
interface.Economic.MyMethod
interface.Currency.MyMethod
etc
This way everything is already handled for them in the background and they only need to run the method they need. I don't know if I can have it both ways in VB.NET.
View 23 Replies
Jan 12, 2011
I just wondering can Itext done the following function before i dive into it.I want to develop a window application, and schedule this application in my server. This application should query the data from (oracle) and with itext help (i hope it help), generate pdf report. Then insert back to oracle as blob.
View 2 Replies
May 8, 2011
I'm developing a system to generate a water bill for a local area.In it i need to print out the bill from using the data from the database. how to generate & print the bill in vb.net.
View 2 Replies
Jun 22, 2010
I am trying to generate random images from access database using hashset as it is said to be unique and there won't be any repeated images appearing. But, it doesn't seem to work.
How can i get it to work? By the way, i am very new to the concept of hashset.
Private Function GetImageFromByteArray(ByVal picData As Byte()) As Image
If picData Is Nothing Then
Return Nothing
End If
' is this is an embedded object?
Dim bmData As Integer = If((picData(0) = 21 AndAlso picData(1) = 28), 78, 0)
' load the picture
Dim img As Image = Nothing
Try
Dim ms As New MemoryStream(picData, bmData, picData.Length - bmData)
img = Image.FromStream(ms)
Catch
End Try
' return what we got
Return img
End Function
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Panel1.Visible = False
Panel2.Hide()
Dim conn As New OleDbConnection
Dim DA As OleDbDataAdapter
Dim DS As New DataSet
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;User Id=admin;Password=;"
DA = New OleDbDataAdapter("Select Empty, EmptyName, Target, TargetName from PicturesDisplayed", conn)
DA.Fill(DS)
Me.PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage
Dim oledbconnection As OleDbConnection
oledbconnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAdministratorDesktopdb1.mdb;Jet OLEDB:System Database=system.mdw;")
oledbconnection.Open()
Dim command As OleDbCommand
command = New OleDbCommand("select count (*) from PicturesDisplayed", oledbconnection)
Dim count As Integer
count = command.ExecuteScalar()
oledbconnection.Close()
Dim randomImage As New HashSet(Of Integer)
' Create a integer and new Random object
Dim intPic As Integer
Dim rand As New Random
'Pick a random number between 0 and the number of images in database
intPic = rand.Next(0, count)
randomImage.Add(intPic)
PictureBox1.Height = 256
PictureBox1.Width = 256
PictureBox2.Height = 256
PictureBox2.Width = 256
Dim pic1x As Integer = _
(Me.ClientSize.Width - PictureBox1.Width) 2
Dim pic1y As Integer = _
(Me.ClientSize.Height - PictureBox1.Height) 2
PictureBox1.Location = New Point(pic1x, pic1y)
Dim pic2x As Integer = _
(Me.ClientSize.Width - PictureBox2.Width) 2
Dim pic2y As Integer = _
(Me.ClientSize.Height - PictureBox2.Height) 2
PictureBox2.Location = New Point(pic2x, pic2y)
' Now set the picturebox image equal to the image chosen from the array randomly using the random
PictureBox1.Image = GetImageFromByteArray(DS.Tables(0).Rows.Item(intPic).Item(0))
PictureBox1.Visible = True
PictureBox2.Image = GetImageFromByteArray(DS.Tables(0).Rows.Item(intPic).Item(2))
PictureBox2.Visible = False
If (randomImage.Count = count) Then
Me.Close()
End If
End Sub
View 1 Replies
Aug 20, 2011
i have probleam with my reportviewer, After i generate my report it only show 1 row from my database, My report also to big which is width until need 2 page . Any advice how i can generate all data in my database using reportviwer.and how i can resize my report. For you info i use visual studio 2005 and sql 2005. I also attach here the picture of the report and my database contain
View 3 Replies
Oct 24, 2009
Here is some example code of what I mean:
vb
Public Class Form1
Private Sub Button1_Click(ByVal sender as Object, e as systemEventArgs) Handles Button1.Click
[Code]....
View 5 Replies
Jul 10, 2009
I m trying to raise Click event of Textbox explictly but I m getting "Derived classes cannot raise base classes" error.[code]....
View 1 Replies
Jun 21, 2010
I am using vb to make a hospital system which works with a access database. i am having an issue with the updating function to the database, this time round instead of hard codding the connection i used the connection/data source wizard, in microsoft visual studio 2008 and there fore most of the code has been auto generated for me, which includes the insert, delete and update funtions from what i can find and what i have read vb is ment to also auto generate this which it is not. the funny thing is that i can close the program down and reload it (as long as i haven't opened the database) and my changes are still there but if i go and open the database and it hasn't changed. also i can change the database through the use of the Dataset connections in the datasource tab but not int he program the code ive found and believe that is meant to update the database
This is running off a couple of buttons i also have a update query but have know way of accessing it
Me.Validate()
Me.TblPatientDetailsBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.PatientInfoDataSet)
View 1 Replies
Sep 24, 2010
so far i got
code
For Each item As Reflection.FieldInfo In GetType(NameSpace.ClassWithNestedClasses).GetFields
rtfAppend(item.Name & ":" & Tab & item.GetValue(Me))
Next
For Each item As Reflection.PropertyInfo In GetType(NameSpace.ClassWithNestedClasses).GetProperties()
[code]...
which gets me the simple string vars and properties of my top class, but how can i apply this to loop through all sub classes and get there vars and props?
View 1 Replies
Oct 13, 2011
Searching the internet finds no less than 700 different ways and opinions to accomplish what I'm trying to do, and I would just like to know the simplest, most bullet-proof way possible.
[Code]...
I simply want to extract the string "bar," which is inside <hostName></hostName>I can do this easily enough with simple string functions, but I'd like to do it with one of the .NET XML classes/methods.
View 2 Replies
Jul 27, 2010
I have three classes Employee, Manager and Salesman. Manager and Salesman classes inherits Employee class.
Employee :
Public MustInherit Class Employee
' Field data.
Protected empName As String
Protected empID As Integer
Protected currPay As Single
[CODE]...
Manager :
Public Class Manager
Inherits Employee
[CODE]...
Salesman :
Public Class Salesman
Inherits Employee
[CODE]...
Now I have created a object of salesman and manager using the following code:
Dim objSalesMan as Employee=new Salesman("xyz",1,2000,5000)
Dim objManager as Employee=new Manager("abx",2,5000,"production")
Is this a good programming pratice or should I use:
Dim objSalesMan as new Salesman("xyz",1,2000,5000)
Dim objManager as new Manager("abx",2,5000,"production")
View 6 Replies
Jun 17, 2010
I find that I write a lot of code within my classes to keep properties in sync with each other. I've read about Events in Classes, but have not been able to wrap my head around how to make them work for what I'm looking for.For example, in this one I always want to keep myColor up to date with any change whatsoever in any or all of the Red, Green or Blue properties.
Class myColors
Private Property Red As Byte
Private Property Green As Byte
[code]....
If one or more of those changes, I want myColor to be updated. Easy enough as above, but is there a way to work with events that would automatically do this so I don't have to put myColor = Color.FromArgb(Red, Green, Blue) in every sub routine?
View 3 Replies
Jun 8, 2011
How can I create a namespace and classes in it, then save it, and reuse the namespace in other projects? Do I have to click on Create Class Library in Visual Studio?
View 2 Replies
Jan 12, 2012
I am new to .net and was wondering if there are any projects which have sets of vb.net classes online which i can use. For example we have Flourish — PHP Unframework which has lots of php classes therefore a programmer doesn't not to replicate code on each project. Is there a asp.net (vb) resource website or any open source project which has built in vb.net functions.
View 3 Replies
Oct 28, 2009
created class TestA. There is Sub mysub defined inside it. Now I want to use this Sub in other class. So far I did like this:
Dim oTestA As New TestA
Dim dblA As Double
dblA = oTestA.mysub
[code].....
View 3 Replies
