When a user completes a form, s/he can complete up to 5 records at a time.
If the the user completes 1 record, the ID increments by 1.
However, when a user completes more than 1 record, we would expect the ID to increment by as many records as the user completed.[code]..
There has been an Visual Studio addin created by Heslacher based on code by JohnWein which allows one to copy code in Visual Studio and paste it as HTML code block here in the forums.urls...
View 10 Replies[code]...
created table using microsoft sql database fileinto
I have already my code for generating primes in visual basic. net. Now I need to include inside my prime loop a TWIN PRIME loop which generates adjacent pairs of odd prime numbers.
An example would be [17,19] , [29,31].. ect. I am not sure how to write the code or where to insert it? I know that I have to have a 2 valued state variable SW.[code...]
is there any way i can do this? As normally you can use a BB code on the post. But when using POST string it says error. i'm not sure if its because of the characters in the URL which are giving it an error but i've added in front of " etc [URL ="http://url"]LINK[/URL] is the BB Code, how can i make this work please? as i'm currently using this in a text box then postings it.
ive tryed
[URL =""http://url""]LINK[/URL]
[URL ="http://url"]LINK[/URL]
*Had to add space before "="
how to insert the VB code in the thread exactly like how it appears originally?
View 2 RepliesI have two tables and the form contains a text box so I need to add rows of Table 1 to Table 2 and taking the value in the text box for each row is added to Table 2.i have insert syntax but it is need to modification:
INSERT INTO table2(column3,column4)
SELECT column1 + @parameter FROM table1 WHERE column2=true
table1: column1 column2
[code]....
i have one project (let's call it project1) that is going to add properties to another project's class. The thing is I wanted to make it automatically. So in my project there are two lines of code which I want to add at the bottom of the class.vb or class.cs in a project called project2. Is it possible? If so, how?It is a data access builder software which after adding some new columns to our database we use it to generate its properties and its parameter to be added in BLL. Since we do it often (changing our database structure) I did not wanted to copy data from data access builder software and add it to project2 manually.
View 3 RepliesI have a simple Entity Framework. For simplicity's sake I will transform the entity names to Northwind Like.I have a IEnumerable Of Customer and Item Objects
View 1 RepliesI'm just a beginner at VB.NET...I want to be able to insert a combobox control onto my form through code but I'm not sure how. Google doesn't seem to answer.
Something along the lines of (I have no idea)
Me.AddControl("Combobox")
I would obviously then need to set the properties to setup the position/size etc.
I have a database in sql server 2005 named as Addressbook and table Persons with PersonID as PK.I have created 4 textbox on form for FirstName, LastName, Address, CityID and an ADD button. When I input data to text boxes and press F5 then it show some error message. I hv tried eerything but failed.My code is as following and error messae is (The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.)[code]
View 1 RepliesI am looking for some simple help, excel has this command built in but I am trying to recreate it within a Windows form application. One of the shapes available in excel is a process flowchart square......I would like to create an interface for users to be able to insert a flow chart by drawing some basic shapes. what is the VB code to activate the insert shape command but not actually draw the shape, just allow the user to draw it. I know this may not make sense but if I need to try and describe it again let me know.
View 1 RepliesI want to ask how to make 1 button when they click on it to load the file "start.bat" or how to insert the code from the (.bat) file
ucp.exe + save
Couse i want to make Launcher for the game but the game cannot be run from ucp.exe, couse the game is old version so i need to make it thoud this code from .bat file. And if the file is missing "ucp.exe" to show error that is missing And if the file is missing "start.bat" to show error that is missing (if only that it cannot include the code from the bad inside the program)
I have two tables and the form contains a text box so I need to add rows of Table 1 to Table 2 and taking the value in the text box for each row is added to Table 2.[code]...
View 9 Repliescode to insert a row to a table in database in visual basic 2010?
View 1 Repliesi use Ms Access 2010 DB as Backend and Programing using VB.NET COdeNarmada
View 1 RepliesI have a flash clock html code and i would like to insert it to my form to be able to show that clock on it
View 1 RepliesI am creating a VB.NET (2005) GUI that uses several controls embedded into tab pages.When VB.NET autocompiles (if I switch windows) it adds lines of code to the .Designer file that causes errors:Windows' is not a member of 'System.Windows.Forms.TabPage'.is generated for:
Me.tbRxMinValidBits.TextAlign =
System.Windows.Forms.HorizontalAlignment.Right
The underlined part is what .NET is showing as the error.
[code].....
Is it safe to place the code of INSERT Sql command inside my While End While
[code]...
I am trying to export some data from a SQL Express table to Access using VB.net. The data is correctly displayed in SQL as, for example, temperature with the small degree object and the letters F or C for Farenhiet or Celsius. The character is of course represented by ° = "°" in html code, which is what appears in my access tables.
How can I get the insert statements to correctly pass this symbol? I have thousands of records and this applies to maybe a hundred or so in each of a few hundred DB's I am running this conversion on.I read the data from a Gridview an .aspx .net web page and then use an insert query with an Access OLEDB connection.
[Code]...
I want to know the accurate coding for inserting value from textbox to Access table . e.g : Student type in their name to textbox , when the add button is clicked, the name will be stored to the Microsoft Access table that has been created
Due to too many code version I have been research on web( youtube, google, forum, blog etc) I getting confused of different code from different programmer, can anyone let me know the exactly working coding?
How to make only one record at a time get inserted in the database table and also delete from the other table?
Once the details are filled ,I insert it in table1 as the new record and I delete the same record from table2.[code]...
We have some code that we want to run a BULK INSERT sql command, but it's getting access denied because the account SQLAgent is installed as doesn't have permissions to the folder the file is in. I don't want that account to have permissions to that folder, and would love to use a proxy account if I could instead.
Don't think this helps much, but here's the vb code we're using to run the sql command:
[Code]...
I have a TrueType font in my PC. And there are some unicode characters in it which I want to insert it into my RichtTextBox. The CharMap in WindowsXP shows the unicode character as U+00CC and to the right, it also displays the KeyStroke as Alt+0204So, how do I insert this unicode character in RichTextBox ? Also, if I'm going to distribute this small program along with this particular font, will this end system can easily display the unicode characters ? Or do I have to set any regional settings in that PC to
View 2 RepliesThe following code inserts same data two time in database table, but I want it to insert only one item when button is clicked.What is the problem in this code?
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
If RadUpload1.UploadedFiles.Count >= 0 Then
[code].....
I am creating a form which has the customer information entered by the user.When the user clicks submit the row need to be inserted into table "customer".writing the code to connect to the access database and insert the new row?
View 3 RepliesI am having some trouble getting the correct syntax for a bit if code. I am using vb to insert data into a db and outputting the data as XML, here is the code
<WebMethod()> _
Public Function addTrack(ByVal tTitle As String, ByVal tAlbum As String, ByVal tGenre As String) As String
Dim conn As New SqlConnection("Data Source=MARTIN-LAPTOPSQLEXPRESS;Initial Catalog=mp3_playlists;Integrated Security=True")
Dim sql As String = "INSERT INTO Tracks (trackTitle, trackAlbum, trackGenre) VALUES ('" & tTitle & "', '" & tAlbum & "', '" & tGenre & "') FOR XML AUTO, ELEMENTS"
[code]....
The code is for a ASP.NET web service, when I click invoke on the website i get the error Incorrect syntax near the keyword 'FOR'. If I remove FOR XML AUTO, ELEMENTS everything works find, db updates but I dont get the data to output as XML. I think the issue is with the brackets required for the insert values because this issue does not occur if the SQL statement is a SELECT statement which has no brackets but i just cant figure out the correct syntax?
I am trying to insert a piece of html code into a web browser control in vb 2010. i have tried the webbrowser1.documenttext function but cant seem to get the browser to run the html code.
View 7 RepliesSo, today I was programming, and then right clicked and noticed a 'Insert Snippet' option. I've seen it before, but never clicked it. I thought this was an amazing thing. It had predefined code which auto inserts. Was just letting some of our other members know, that it does include some predefined things such as 'Write to a text file', etc.
View 4 Replies1. Can someone show me sample codes on how to do that ?
2. I encountered a problem with the INSERT sql statement. I keep receiving syntax error in insert statement exception. Is there anything wrong with the statement ?
[code]...