i want to insert the splitted data into database table which has only one column.for eg; textbox1.text= 102,103,104 i want to split this numbers into three and that numbers should be inserted in Access db table as follows
EMPNO
1st record 102
2nd record 103
3rd record 104
I am back as always! Here is my question. First and formally, With the code;
SendRequest("http://aavirtual.net/brett/core/classes/class.acars.php?fun=6")
Dim Splitter
Splitter = Split(request, ";")
With that data above, I am creating a For Statement to loop all the data being pulled, into a Rich text Box. Here is the question. I need to count the number of objects Splitted.
Example:
Car;
Train;
Boat;
Bike;
The Splitter is ";", And there are a total of 4 Objects needing to be split. How can i count the number of objects? The Objects are Car;Train;Boat;Bike, And I need visual basic to count the number of those objects which is 4. But I need a function that will output that.
The result should looks like:
array1(0)="D"
array1(1)="H"
array1(2)="2"
array1(3)="3"
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
I am developing vb.net windows application. I am trying to insert data with insert command.I am getting the insert data as long as the application is running. But when i close the application and reopen again the inserted data was not in the access database and i am getting no result. what is the problem, is it in code? i am using like
strsql=" Insert into table(col1,col2) values(val1,val2)"
selectCommand as new oledb.command(strsql,strConn)
selectCommand.ExecuteNonQuery()
Not inserting in the database but showing in application. how?
how can i insert data from data base with selected Datagridview columns i have insert combobox to Datagridview and it can load data from DB now i need insert data to another columns in Datagridview when i change combobox items?
View 7 Replieswhen i try to insert data from database into dataset using data adapter, it takes long time, i want to use hourglass but i'm confused how or when i type the code so user will know that application still work.
View 1 Replieshow to insert new row in the last row have data in data grid view
View 1 RepliesI got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
What I want to happen is that the button from my system will remove the previous data from database and then insert new data to database from text file. Im done with inserting new data. The thing is that I dont how to control or where to put the Delete Command from my code.
[Code]...
I need to complete within 4 days? I have a problem with the insert statment on the code below. This code is working fine by inserting the ststement, but the problem is that the DATE is not being inserted into the SQL DB. The default date is being inserted as 1900-01-01 00:00:00.000. I really want today's date to be inserted into the SQL DB when the other data are being inserted. FYI - At the SQL level the column's data type is Date. I have tried the other way to get the Date column to be updated automatically with the Getdate() function but it's not working. Please help solve what is wrong with my code below. NB: class DALCallRegistry is a class the frmCallTally class uses it.
[Code]...
I need to insert data from DB to another DB. I run this query from VB.NET:for example:
Insert into DBDestino.tablaDest (campo1,campo2)
select valor1,valor2
from DBOrigen.tablaOrigen
Field "campo1" is integer (in DBdestino)But sometimes the value "valor1" (in DBOrigen) is NULL. If I run the previous query, it returns error and does not insert any data.How I can insert data though "valor1" sometimes is NULL?
I had a difficulties to insert the data in vb.net into sql, I had try few times, but it seems the data can't be read in the database.
View 1 RepliesDim con As System.Data.SqlClient.SqlConnection con = New System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|\Database1.mdf';Integrated Security=True;User Instance=True")con.Open()Dim str As String = "insert into Login(Password) values('" & txtPass.Text "')"
Dim sda As New SqlDataAdapter
[Code]...
I developed an windows application using visual basic.NET. I configured my database connection string in app.config file. The problem is that I can retrieve data but cannot insert data into the database. the config file
[Code]...
i already develop system using VB.net with Microsoft Access 2003 as my database. when i running in Windows XP it's working great but when running in Windows 7, i can't insert into it..
View 2 RepliesPublic con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\KarthI\sample\db1\WindowsApplication1\WindowsApplication1\bin\Debug\phm_pharmacy.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
con.Open()
[code]....
I am using this code to insert four values into the table quotation_t11...When i run this code it shows the msgbox that the Data is added successfully The problem is i cant find the data what i inserted in that table..I can able to retrieve the values from the tables but i cant able insert?
City table has 4 coloumns: CityID, CityName, Pincode, DescriptionI have placed Button1 on Form and want to add some data to City table by clicking this button. When I click this button, i get an error msg like Connection Property has not been initialised.
Imports System.Data
Imports System.Data.SqlClient
[code]....
I am trying to create an application where using a vb.net form u can enter data into sql tabel (I am using visual studio 2005 and sql server 2005). I am only able to get data from sql table using "data source configuration wizard".
View 19 Repliesi have 1 errordisplay microsof.jet.4.0 is not initialize into local machine
View 1 Repliesi am now want to insert data(fault and visual(bold)) into the table. After done the calculation, i would like to insert the fault and visual value into my table summary. My field name in table summary for fault(fo_ratio) and visual(visual) So below is my coding. How can i save into the database after done the calculation.[code...]
View 4 Replieshow can i insert a data into the database sql when i choose one radio button and one chekbox i have 4 radio button and chekbox?
View 9 RepliesI have a number of different data bases (all local Access.mdb), each with the same stucture but different data (this data will not be changed it is only the basis for the program - only one database will be used at any one session). Is there a simple way of using a single Dataset to access different Data bases depending on a user selection? - In VB6 the basic query looked something like this;Database A.Execute "INSERT INTO TableA SELECT * FROM " & TableB & " IN '" Database B at location "';"
View 2 Replieshow to insert data in a database?i have every thing set up ..i only need to code to when you click it inserts in the databse..
buy the way i have an obdc set up.is there a way to make it update ?
so if i insert data in the application it updates the mysql databse to?
I bound my combobox in a datasource.How can I insert a value at the top of my combobox?[code]...
View 7 RepliesI'm using visual studio 2005 to develop a mobile application. The database i'm using is sql compact edition. I know in normal sql like mysql, ms sql i can do a multiple insert of data but in sql ce it don't work!
I know of a long way that is to just create a createVendor1, createVendor2 as many time as i need to insert the data..but i don't think this is the right way to do it. this is what i have currently, if i remove the 2nd insert , it works. NOTE: There is a semi colon at the end of the insert but that is not the problem as removing it also doesn't work.
Private Sub FormOrder_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim createVendor As SqlCeCommand = connection.CreateCommand()
[Code]......
I have this code:
Dim myConn As SqlConnection
Dim cmd As SqlCommand
Dim sqlstring, DNAME, DEXP, DCREATION, DLASTUPDATE, DCOMMENTS As String
[code]....
When I execute, it gives me this error:Cannot open database "DOMAIN_NAME" requested by the login. The login failed.Login failed for user 'comm-pc10pcuser10.comm'.and it highlights myConn.Open() I have SQLServer 2008 and a user name and pass for my database.
Insert Data Into Table Using Ado.net?[code]...
View 2 RepliesI have a datagridview and sql table.
I can preview data from sql using my vb.net app this way...
me.textbox1.text = form1.datagridview1.currentrow.cells("columnname").value.tostring
And i know how to insert data into sql table like this....The whole code
Imports System.Data
Imports System.Data.SqlClient
Public Class Form2
[Code]....