I'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"
I created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
View 8 RepliesHe wants to create a new table in the database (his using vb.net, mysql). The tricky thing is that he wants to name the new table from the the input being encoded into a textbox.
To create and name a new table from the input in the textbox.
I am working with a Vb.net 2005 application. On the application I have a Create table button which when clicked creates a table in Sql server with the code shown below;
Code: Private Sub BtnCrtTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnCrtTable.Click
[Code]...
This is really a pre-defined table and the data is already specified to be inserted to the table. However, my primarily task is to read a flat file which has the data and consider the first line as the column to be column names.
Therefore, initially I created an open dialogue to browse for the text file and store the path such as E:Datafile est.txt, in a TextBox1 visible at run time. Now the task is to change the above "create table" to read the txt file (column names are on the first line) and then create the table in the database.
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
I have a data table whose one column is related to a column of another table. I have a listbox in a form which shows a column (which is sorted by another column value by ORDER clause) of the parent table and other columns are in textboxes. The child table is represented by a datagrid. When I add a new item in parent table and click save, the newly created item is listed at the bottom of the listbox violating my ORDER clause. When I wrote some codes to fill data again after updating, it shows an error message[code]...
View 3 Repliesi am using visual studio 2005 and database sql server 2000. i want to read table of database and readed data insert in temporary table again update that inserted record.
View 3 RepliesI'm trying to connect to an Access table who's name includes spaces ('look Material Type').How do I identify this table in an OleDB string
View 2 Repliesi able to insert the table but i unable update to another table at the same time
my
Imports System.Data
Imports System.Data.OleDb
[Code].....
I am trying to do a home project and after many hours of failing to complete what seems to be a simple process I have decided to ask for some help. None of the examples I have found on over 20 websites is complete or works as the author suggests. (Im sure because of version differences)
I want to make a Visual Basic Program that, by means of clicking on a radio button and then clicking on a button named "create" will add a blank table to my db named by the string variable connected to a listbox where this name can be first entered before clicking on button1. Can someone help guide me in the right direction? The table needs to have three columns; Col1, Col2, Col3 -my database is named "Database.sdf"
Form/Interface info radiobutton1 'an option that if selected = true in the button1 click event will process the data that creates the table. textbox1 'table name input button1 to create table 'to run the process combobox1 'shows available tables that exist in the db button2 'click event shows the combobox (table) in the datagridview window button3 to delete 'to delete the selected table button4 to reset 'to clear radio button choice,textbox1, and combobox1 datagridview1 'to veiw the selected table Note: if also possible I would like a datagridview of the new table on the same form after it has been created.I am using Visual Basic 2008 Express, It is a microsoft SQL Server Compatct 3.5 Database
I am using OLEDB and using datareader and with the read function i am reading table to the form. But now i want the textbox values to be written to the table? I tried with the fill, but not getting.
View 1 RepliesMy sql database is :and on form1 objects is 5 X Textbox and 1X numericupdown I want with numericupdown value=1 then first 5 rows column name fill on the 5 textbox and so numericupdown value =2 then fill second 5 rows fill on the 5 textbox and so for all rows repeat.
View 5 RepliesI am working on my new project and I need to create a table for each user dynamically. In which the user will provide the Table name in the textbox and on pressing Create button a new table gets created in the same MS access database file with the provided name.[code]...
View 17 RepliesI 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 RepliesI have 3 controls sharing the same Bindingsource.Each control will require a different parameter for the query call to the DB to populate the proper controls data.However each control is filled with the same data and using one ctrl has the same effect to the thre controls. The controls all mirror eachother.how can i create a new instance of the table adapter?
View 9 RepliesI want to create an access table at runtime. It happens that my table has to change, this means that i need to alter some or all of the fields. I need to be able to do this at runtime. I am using the following code, but it does not seem to work. The last field has to be an Autonumber field.
Private Sub CreateLessonPlan() '' Create table if it does not exsist
If con.State = ConnectionState.Closed Then
con.Open()
End If
Try
' Drop the Employees table if it already exists.
[Code] .....
Is it possible to alter the structure of a table that already has some records in it?
I have a string array that represents the field names for a table I need to create. Given that the first field type is date, the second is time, and the rest are floats, what is the easiest way to create the table? I am currently using the following code, but it seems there may be a simpler, less convoluted way
vb
'read the column names from the OPC server
Dim colNames() As String = GetFileColumnNames().Split(","c)
'build command string used to create the table
[code]....
I have a data table.
And I only want to have a single row in this table. I then write the changes to an xml file. The user will edit the row in this table save the values in the settings.properties. And then when ready write the changes to the config file.
However, I am thinking is there a better way. As I have to keep removing the row that was currently added. Then create a new one.
' Add the data to the datatable and write the changes to the config.xml file
Private Sub btnWriteConfig_Click(ByVal sender As Object, ByVal e As EventArgs)
' Only create a single row. All changes must be made to this row only.
[Code].....
im using this code for create view joining tow table but its gived me error on 'INNER JOIN' :
Cmd.CommandText = "CREATE VIEW MyQry As SELECT TblData.Emp_ID,TblData.Emp_Name,TblData.Emp_Bonus,TblData.Emp_Salary,TblData.Emp_Sanction FROM TblData WHERE TblData.Emp_ID LIKE '" & LstEmp.Text & "' INNER JOIN
[Code].....
I want to be able to get the one record I return from a table and put the results into text box's directly rather than put the result into a combo box and then transfer the text across.
Private Sub GetStationStats()
conn.ConnectionString = myConnString
Dim myCommandStationStats As New MySqlCommand
Dim myAdapterStationStats As New MySqlDataAdapter
Dim myDataStationStats As New DataTable
Dim SQLStationStats As String
[Code] .....
The fields Signon and SignOff, plus many others which I didn't include in this sub. Above code does work, its how to get it into a text box.....
How do I copy a table to another table without overwriting the contents of the second table?
View 2 Repliesin my application I have 2 different dataset.[code]How I can accumulate all content of second table in the first table (table_completa should store the result of all query) table_ Completa = table_completa + table_query..Remember that the table are in 2 different dataset
View 11 RepliesI am a newbie and am trying to open a table in SQL Server 2008 table from Visual Basic using ADO and its throwing up a weird fatal error. The error message is:'A fatal error has occurred and debugging needs to be terminated. For more details, see the Microsoft Help and Support web site. HRESULT = 0x80131c08. ErrorCode: 0x0' The code I am running at the time is:
[Code]....
Let's say, I have something like a table in the WebBrowser component, it's not actually a table, because the data organized in flash, but, it's organized like a table, it has like rows and columns. You can see more in the attached file. Can I transform this text organized as table into DataGridView or some another tool that serves as table. like_a_table.JPG
View 3 RepliesI have a large form that is set up from master-detail datasets in Visual Studio 2008.I havene master table with a large amount of detail tables. Several of the detail tables also have detail tables linked.Now I need to add a master table that sits on top of my existing master table making it a detail table.
View 7 RepliesI have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
View 1 RepliesI have this code to edit the datarow of my table adapter but t doesnt update the table. I think i have a missing code that's why but i cant figured it out. by the way im using vb2008 and SQL as my database. [code]
View 3 RepliesI 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]...
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I got an error when I tried to save a deleted record in a table which I use to store username and password.
I can delete with no problems but the error message popped up when I clicked on the update icon
My login code is like this
Imports System.Data.SqlClient
Public Class Form1
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As
[Code]....