I am trying to insert data into two tables on two different forms. My problem is that I don't know how to get the last entered Auto generated ID from the first table to pass it to second form.
View 4 Replies
I already made a code on vb.net to generate random numbers with letters using HEXA + date time. Now, all i want to know is how to set it to single use? Once they got it, they can no longer use it back. They have to request for new one..
View 10 RepliesHow can I call this kind of subroutine Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click ? How to pass the values of the two parameters sender and e?
View 4 RepliesI created a custom datagridview. In the constructor of that datagridview, I set
Me.AutoGenerateColumns = False
and then, declared and added 4 DatagridViewImageColumns and 140
DatagridViewTextBoxColumns by the code
...
Dim dvgCol as New DataGridViewImageColumn
[code]....
But when I add an instance of that datagridview onto a form, in the form.design.vb there are many code defines for each columns and then sometimes adds additional code to create those columns again. Sometime when I delete the datagridview control in the form,that code is not deleted.
I have around 60 dropdowns and textboxes on webform, have primary key column (QuoteNumber) too which is dropdown control and Auto-generated value. I have a button called AddQuote when I click this button QuoteNumber should be autogenerated in database and same should be loaded into QuotNumber drop down, how can I achieve that.
View 7 Repliesas I'm starting at this I'm very confused trying do this stupid code in visual basic 2008 in .net : Each time i create an instance of clsTest (for example) i would like to do an attribute call mID that adds 1
For example:
instance 1-
mName = test1
[code].....
Auto generated alphanumeric pk
[code]...
I have a VB 2008 app that creates controls at runtime. I can read these controls EG: textbox or dropdown by the following line.
<code>
TXT_value = CType(Main.Controls.Find(TXT_item, True)(0), TextBox).Text()
</code>
I can see the value but sometimes.. Sometimes I get a indexoutof range exception.
I am trying to format the width of my gridview columns dynamically for easy of use in editing and updating. Is it possible to have multiple column widths defined? Here is the code I am using to create the gridview...
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
[code].....
knows how to display autogenerated id on textbox in a form?for exampleif i have 2 textboxes
1st txtbox is for CustomerID
and the other is CustomerName
when im gonna add a new record
[code].....
I created a vb.net script to autogenerate a code. Now, after generating this code, what I want is to determine the validity of this code. for example, a code has been generated now and this code will be valid for 24 hours only. Can someone help me how to do this? i have no idea as of this moment. Been searching over google and dont know what's the right keyword for that.. Below is my script for the auto generation code
Dim randomvalue As New Random
Dim randomhold As Integer
Dim newcode As Long
[code]....
I am new to vb.net. I created a vb.net script to autogenerate a code. Now, after generating this code, what I want is to determine the validity of this code. for example, a code has been generated now and this code will be valid for 24 hours only.
Below is my script for the auto generation code
Dim randomvalue As New Random
Dim randomhold As Integer
Dim newcode As Long
For i As Integer = 0 To 9999
randomhold = randomvalue.Next(1, 9999)
newcode = randomhold & DateTime.Now.Minute & DateTime.Now.Year
Label3.Text = newcode
Next
The code generated will be sent via sms. If the code hasn't used within 24 hours, it will be invalid.
i'm worried about doing this since my changes will be overwritten when the dbml file is auto generated again (as they often are).i'm thinking of doing a partial class and writing out the same properties to annotate them, but worried that it will complain about duplicates, and the reason i can't even experiment brings me to the second part of my questions...
that, the expandable arrow on my dbml file listing is missing, right clicking and selecting "View Code" just displays an empty partial class as below.
[Code]...
For example:Public Event CurrentChanged As EventHandler(Of CurrentChangedEventArgs(Of T))Shows the message "Do not nest generic types in member signatures." on CurrentChangedEvent, which is the variable that holds the delegate for the event, and VB generates it automagically.How do I suppress the rule for the item?
View 1 RepliesIDE :: Project Template Awareness for Auto-Generated CodeE
View 2 RepliesI need to help about treeview.I have a auto generated treeview with only SubNode checkboxes like this;Forexample; when I want to check B-SubNode-1 checkbox, the other node checkboxes (A-Node & B-Node) must be uncheck if it is checked. It might be check all SubNode checkboxes if their state under on a same Node.
View 2 RepliesI'm using a 3rd party tool to generate my model including code classes for the MS Entity framework. What I wanna do is etablish a real layer application. I'm speaking of the layers:
Presentation
Business
Data
If I'm not wrong the generated classes represent the data layer. My question is if I should wrap this classes up for my business layer or not. In some way these generated classes already represents the logic of my application as it was derived from my database. But is this enough?
I definitely wanna use LINQ as well which works pretty good with the generated classes alone.
I'm looking forward to any comments.BTW: It's going to be a ASP.NET web application. I have used the projetc type "class library" for the data layer. The web application will use this DLL.
I am trying to use a script mananger to use page methods to communicate between the server and client side of my page. I have added this code to the html
<asp:ScriptManager ID="ScriptManager1" runat="server"
EnablePageMethods="True">
When I add this, here is what is inserted into the designer page.
Protected WithEvents ScriptManager1 As Global.System.Web.UI.ScriptManager
But when this is automatically added, i get this error.
Error 52 Type 'System.Web.UI.ScriptManager' is not defined. C:UsersBillDesktopiPlan-7-layerlistingsummarytreeMain.aspx.designer.vb 32 44 iPlan
I added a reference in my project to system.web.services - but still can not seem to get around this error.
Using this
TxtBox = New TextBox()
With TxtBox
.Name = "T" & reader("area").ToString
.Visible = True
[code]....
The name would come out like "T3" Now I want to put a value into that textbox.How can I address the correct Textbox?
According to the General Naming Conventions the usage of CLR type names (e.g. String, Int16) should be preferred over the usage of language specific type names (string, short). I usually follow this advice. Resharper however seems to use the language specific type names when generating code (eg. when extracting methods or generating foreach loops) which is very annoying.
View 2 RepliesAs mentioned in the subject. I found this default setting in VB 2010 rather annoying. For example:I have created an combox box and i have created an event as below as well
Private Sub cmbBuildingID_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbBuildingID.TextChanged
listUnitStatus()
[code].....
I'm messing with a GUI however I can't seem to find the auto-generated initialize components method. There certainly is a constructor somewhere, my gui initialises and works just fine, but I can't see it...
View 4 RepliesI am using ADO.NET Datasets in my VB Applications. I have a typed dataset with one Parent table and many child tables. I want to generate Identity Key when I insert data into Parent Table and then update the data in all child tables with the Same key (As Foregin key).At last, I want to update the dataset in Database(SQL Server08).Well, the above thing can be possible by first inserting Parent Table in Database directly, get the Identity column and than use to for Child tables.
View 4 RepliesI want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
I've spent a couple of hours trying to find the answer to this, and although there are tutorials all over the 'net none of them work for me (or I am too n00b to understand what they're telling me.I'm creating users in asp.net using Membership. What I want to do is add the generated UserId to a column in a custom table I've created, to link the stuff in the custom table with the user created in aspnet_Users.
[Code]...
I'm trying to produce a repeater showing amounts of money taken by various payment types into a table.Payment types available come from a global settings file as an array, I am creating a dataTable by looping this list and extracting sales reports (there might be a more efficient way than this loop, but this is not my concern at the minute).My question: How do I bind this to a repeater and display it when I dont necessarily know the table column namesI've tried various methods to give the table a header row and give the columns numerical names from a for > next loop, but am either getting no results, orystem.Data.DataRowView' does not contain a property with the name '7'. < or whatever numberThis is where I currently am:
EDIT: JUST REALISED MY CODE WAS AWFUL, SO UPDATED:
Dim paymentTable As New DataTable("paymentTable")
For j = 0 To UBound(paymentTypes)
[code]....
Rather than running numerous queries in Access I am trying to write a front end for a DB2 database. The Access database is getting to a size that it is causing Access 2007 to have reliability issues and frequent compacting is required. I have created the Dataset, the Table Adaptors, and the Connection String already, but when I put in a bit of code in to fill the Table Adaptors the remote connection I have to work is going crazy (chewed up about 180MB before I realised it was pulling data from work).
Before I started the project I copied the .accdb to my local PC HDD and I pointed the connection string to it, but it still looks like it is trying to pull data from the work network. If it was a small database I wouldnt be concerned but it is pulling major data every time I run it. I have only 2 out of the 4 Table Adaptors running and it didnt fill them even after 10 minutes.
Here is the code I was trying to run... Server name has been substituted for Server for obvious work reasons.
Because the tables are so large I was looking for a way to pull only the columns I need to from the tables, I tried adding .SOFT_ID to the first line of code but the TA spat the dummy message below...
Value of type 'System.Data.DataColumn' cannot be converted to Application_Name.DS_DB2Database.Server_SOFTDataTable'.
Code:
Me.TA_ServerSOFT.Fill(Me.DS_DB2Database.ServerSOFT.SOFT_ID)
Me.TA_ServerSOFT_FOUND.Fill(Me.DS_DB2Database.ServerSOFT_FOUND)
Me.TA_ServerHARD.Fill(Me.DS_DB2Database.ServerHARD)
Me.TA_ServerREF_SUP.Fill(Me.DS_DB2Database.ServerREF_SUP)
I would also like to pull just the data columns I need to speed up the query.
Note: In case youre wondering why I am not connecting directly to the DB2 database. I currently dont know where it is stored and while leveraging Access I am trying to put a level of separation between the app and the db for the time being, later I will try connect directly.
Just started trying to convert all my access database into Sql Server databases and also create vb .net application for them all. First problem I encountered was there doesn't seem to be anything like a continous form(I know there is a datagridview). So i thought i would create a flowlayoutpanel. Place lots of textboxes on it and fill each of textboxes with information form my dataset. now on to the problem. one of the textboxes is the item description field. This field can have one word or many words
View 1 RepliesSay I have a table called tblTest in MS Access with the primary key called field0 which is set to autonumber and a few other fields, say field1, field2 and field3. Say also, I inserted a new row using:
SqlO = "Insert into tblTest (field1, field2, field3) Values (value1, value2, value3)"
Dim cmdO As OleDbCommand = New OleDbCommand(sqlO, conn)
cmdO.ExecuteNonQuery()
[code]......
i'm importing a text file into a access table like this:
vb.net
sql.CommandText = "SELECT * INTO [tblMailList] FROM [Text;DATABASE=" & frmMain.FolderName & ";HDR=NO].[" & frmMain.TextBoxFileName.Text & "]"
sql.ExecuteNonQuery()
my question is what is the best way to add an autonumber to the table? i currently do it like this:
vb.net
sql.CommandText = "ALTER TABLE [tblMailList] ADD COLUMN [ID] AUTOINCREMENT;"
sql.ExecuteNonQuery()
but when the file is too large i get this error: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."
and yes, i have tried to change the registry entry and it didn't work:
vb.net
My.Computer.Registry.SetValue("HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0EnginesJet 4.0", "MaxLocksPerFile", "9000000")
