I want to do a task with a function controlling database with vb scripting. My form will include textbox, button and datagridview to view the database table manually without add from the microsoft access or other..how i want to make the table appear when i put a number into the textbox that refer to the number of row and column and then click the button to create the database table? Besides, how to rename it using textbox?
View 3 RepliesIs it possible to manually save data from my dataGridView to my SQL server database table?
if it is possible can some please tell me how to do it because i don't like using the data sets and reader VB has because it doesn't give me full control over the procedure.
please see the code below it all works fine its just the last two line im struggling with, which is where i am trying to save the data from the two columns in my DataGridView [code]...
I have created a local database (.sdf) and added a few records. What I really would like to do is connect to the database manually and load the records in a listview. Anyone with some tutorials?
View 5 RepliesWe have exactly 120 employees entered in "EmpMaster" table, "EmpId" number field set for 'Auto number' start from 1-121. Now my problem is HR Department instructed me to continue EmpId number start from 1121 for new employees. So I want to continue new records in the same Table.I'm using the code to INSERT record is : EmpMasterTableAdaptor.InsertQry on windows form. Operating - Visual Studio 2010Prof and SQL Server 2008 for database.
View 2 RepliesI'm trying to create table in my database, that would have name like i type in Textbox and than i have to click the button With code like this :
sqlCmd.CommandText = "CREATE TABLE NAME = '" & TextBox1.Text & "' (First_Name char(50))"
I'm getting erorr : Incorect syntax near "name that i type"
Im trying to do an assignment at uni and it requires me to create a database and search the table?Ive created a table CustomerContact I want the user to input AccntRepNo and click a search button.ill use this number to search (query) my table dispaying all the records related to the AccntRepNo?Ive been reading alot about connections but i already have a database setup
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim repNo As String
repNo = AccntRepTextBox.Text
[code].....
I am using SQLite ADO.NET Provider.
I want to create a database with 2 tables via code in vb.net .
Please provide code for the same.
I am using VS 2010 Winforms, working under XP SP3 Pro
i am trying to create a table in a access 2007 database with the name stored in a variable wich the user inputs. For example, if the username entered by someone is "John", i want to create a table in the database also named "John". I have tryed this:
Dim mypath = Application.StartupPath & "\mydb.mdb"
Dim mypassword = ""
Di Cmd As OleDbCommand
[code].....
Is it possible to Create a New table in the Database using any Action. The application I have designed is based on DateTimePicker. Is it possible to Create a table "March", "April" so on, when the user selects March or April for the first time. So that records of that particular month will be updated in that particular table.
View 1 Repliesi have a access database and i want to create a new table using codes only.
View 2 RepliesBasically, I'm working on a VB project, one instance of it at home using VB Studio and one at school with SharpDevelop (portable). However, some of the school computers do not have .NET 4 and therefore I can't run SharpDevelop to make the forms, etc. I would like to know how to edit/make a form via code, in Notepad++. An example of this would be setting up a form with controls such as TextBox, Button and perhaps MenuStrip.
View 2 Repliescode for creating a class in vb.net for a database table that includes insert,delete,update function.
View 1 RepliesI create a DataView that load a table from database.
Dim da As OleDb.OleDbDataAdapter
da = New OleDb.OleDbDataAdapter("select * from customers order by name", cnmain) ' I load complete table
[Code].....
�Thst's all I need? Because when I recover the first row of DataView filtered, it appears the first row initially loaded when I don't put filter.. �Do I need to refresh DataView to view te changes?
so far i have this for my code:
Using myConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & databasePath & ";User Id=admin;Password=;")
[Code]......
This did not work but did when i just tried creating the table and not the fields.
I create multiple dynamic pictureboxes and it are to many to add them all manually, is there a way I can e.g. use an integer which adds up every time a new picturebox is made. Then I want to add the same code to every picturebox. Now it creates the picturebox and moves it to the next spot and doesn't create a second. I am using this code if its helpfull:
[Code]...
I want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
View 2 Replieshow to use a dynamic table for my MS SQL database? Im using vb.net 2008...any idea on how to do it?
e.g. - Output
ID LastName FirstName Address Order
001 Doe John Kentucky 10-10
002 Smith Jack Kansas 10-11
Im working on a prog for my work. however, im stuck. I come to a spot where i need the prog to copy a sample table to an existing database. we can either simply copy the sample table, or as a last resort, create a new one from scratch.
View 6 RepliesI have the code I am using below. On 3.5 framework Access 2003 database vb net 2008
I already have the database created but need to be able to add Tables and fields with the correct datatypes. So far it's not working but i don't know why or where the error is.
Private Sub MDIParent_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code].....
The below code is suppose to create a database and a table with a column "FirstName" which is assigned a value "James"
Imports System.Data.SQLite
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
But for some reason the app only creates a a database which has a size of 0 bytes. Why is it not working . I am using I am using SQLite ADO.NET Provider. , VS 2010, Winforms
I have used My.Settings for quite some time now, in both VS2005 and now in 2008, but never noticed this behaviour yet... I must be forgetting something trivial? I create a StringCollection setting and manually enter some data (strings).I write some code to handle this, and I get it to work.
Then, I manually add some new strings (and edit the older ones) in the Settings page, save the project, and run my code again.For some reason, the last changes have not been saved... Whenever I look in the settings page, I see them there, but my code cannot recognize them..
[Code]...
how to create a web service reference manually in visual studio. I do not want to use the "add reference" already contained in the ide.
View 6 Repliesi want to start my coding immediately about linking the database in vb...but i dnt knew how...hw i can lnk my database...
View 11 RepliesIs there any way to create a button which basically clears a entire table in your database?
I was hoping to have 2 buttons, 1 to empty a table 1 to fill the same table again.The idea is to store a year long values, and at the end of the year delete all of those with a button.The other button i want to use to fill the same table again.Starting from 1st day of the year untill the last day of the year.
I have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 RepliesProtected Sub GridView1_RowCommand _
(sender As Object, e As GridViewCommandEventArgs) _
Handles GridView1.RowCommand
If e.CommandName.CompareTo("command") = 0 Then
Dim itemID As Integer = Convert.ToInt32( _
GridView1.DataKeys(Convert.ToInt32(e.CommandArgument)).Value)
[Code]...
Basically, it doesn't work and I don't get it. I've been trying to figure this out for a few days now and I can't see what I've done wrong. As you can see I'm trying to manually update a field in my database with the value of (originalvalue)+1 when the user clicks the buttonfield of the corresponding row.
I guess what I'm asking is if anyone can point out any mistakes, please do, or if there's a better way to do this (without having to go through all the DAL/BLL BS)
I want to create a class (I think) that has properties that correspond to column names in a database table, such that they come up in Intellisense when I type the dot after the class name. Is this possible to do?
View 5 RepliesI'm building an application that is intended to function off and online using the new Local Database Cache functionality included with Visual Studio 2008. My issue however does not pertain to that directly, as I have a pretty good understanding of how to use it and how it functions. My issue is with getting an understanding on how to directly write to a SQL database.
Most of the tutorials, videos and education available when it comes to databinding makes the assumption that I need my application to pull data and edit it, but in my case all I really need (in fact intentionally all I want) is for the application on Submit to write data that it pulls from the form as a new record in a SQL table.
Here is what the program looks like now.
Public Class StatCom
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
At the moment the program simply does a status check for connectivity and wether it can ping the server (in this case the SQL server) for the purpose of displaying a online or offline status in the form.
I follow it up by making the status checks.
Finally I declare all the various fields I want to capture and write to the database.
What I want to do now is have a SUBMIT button that on click takes all the data in the form and writes a new record to the database I have already setup and have data connection to.
I know that the code has to be written using the .recordset functionality, but I haven't found any could tutorials on the subject that have turned on the light upstairs.
I have a legacy data table in SQL Server 2005 that has a PK with no identity/autoincrement and no power to implement one. As a result, I am forced to create new records in ASP.NET manually via the ole "SELECT MAX(id) + 1 FROM table"-before-insert technique.Obviously this creates a race condition on the ID in the event of simultaneous inserts.
What's the best way to gracefully resolve the event of a race collision? I'm looking for VB.NET or C# code ideas along the lines of detecting a collision and then re-attempting the failed insert by getting yet another max(id) + 1. Can this be done?
i am trying to create a program that connects to a database and shows table fields in listview in windows form i manage to do that but i want now to have a button to take the total of a column in a list box ,lets say from the column "money"?
View 9 Replies