I have to write a code in vb.net (2010).To get a data from Database A table 1 and dump it to Database B Table 2.What's the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
View 2 RepliesI am getting data from my database and I want to have that data as a table in excel file.
So, I have written the following :
[Code]...
I am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
View 1 RepliesI have insert a data which is in binary format into sql server database table Column type of table is Image Type. I have to read this column from a XML file,I am able to read but
[Code]...
Is 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]...
How to correctly insert image data from XML file to database table using sql server CE and openxml,XML file is written by vb.net DataSet.WriteXml method?image data is stored in database table is :
0x89504E47.my XML file Content after written by WriteXml method is :
<?xml version="1.0" standalone="yes"?>
<Data>
<Table>
<image>iVBORw0KGgoAAAANSUhEUgAAAcIAAAGuCAYAAAADLg..</image>
</Table>
</Data>
but after inserting with openrowset and openxml using stored procedure to another database table its value changes to this :0x2F0039006A002F00340041004100510.and is not the first value and raises an error in vb.net for opening image from database.
I am using the tutorial posted here for my database testing. I have gotten it to display the data using a messagebox but it just goes through them 1 by one. I want it to display all the data from the database in a table on my form.
Using connection As New SqlClient.SqlConnection("Server=71.200.87.112MySQLExpress; Database=database_test;User ID=sa;Password=greddy6;Trusted_Connection=False;")[cod
I use this code to create dump files of my database.Now what I want, if possible, is to encrypt it so that when it is viewed in notepad or anything similar, average users cannot read it.
Code
Call isDirectoryExist()
Call createDbBackupName()
Dim myProcess As Process = New Process
Dim strUser As String = "superadmin"
[Code]...
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesI am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
I wrote an import procedure that extracts certain row data from Excel files. Currently, I manually create a DataTable in VB.NET, add columns and their datatypes. don't add anyconstraintsto the table, but the SQL database table where this data is going to does haveonstraintssuch as a column can't be null, check constraintsor unique constraints.Here is a simple example of my code.
Dim dt As New DataTable
With dt
.Add("Column1", Type.GetType("System.String"))
[code].....
I have a dataset (WW1Dataset) with one data table(WW1).(database used in an access database) I'm trying to filter the dataset e.g a user wants to filter by a chosen surname (SurnameTextBox.text) so the datset is filtered to display only those records wherethe surname column in the dataset matches SurnameTextBox.text.
View 1 RepliesI am using vb.net to code and sqlserver 2008 as backend.I have a checkboxlist that needs to be filled up with data from the database.The data in the field is comma delimited (Blue, Red, Orange...)How do i populate my checkbox with this data from the DB?
View 1 RepliesI hate to ask this question on this forum, but I'm having a lot of trouble finding it on these online tutorials. Basically, I'm learning about SQL, VB.NET, and how to glue the two together, and I've learned about using SqlCommand.executeScalar() to get the first entry in a table. But that's all it's really good for, right? Or is there something more to the story here?
Basically, I'm wanting to ask about how to pull in a FULL table from a SQL database while using VB.NET, as well as how to pry substrings and stuff from it. Again I'm having to ask this on this forum because all these online tutorials seem to ignore the subject completely.
I currently have a drop down box that selects a customers id, when selected it populates the neccesary fields. I now want to populate these fileds by entering a customers name in a textbox. The customers names are in a table in sql server.
View 1 RepliesI am working with VB.NET.. i have a DataTable called "QUESTION", containing 3 fields:
QuestionNumber (unique integer key)
QuestionText
QuestionType
In my SQL Server database I created a Table called "QUESTION" with the same fields.
QuestionNumber is defined as integer unique key, auto increment
Now, when i make a bulk copy to insert the DataTable into the SQL Server, the database overwrites my QuestionNumber from the DataTable and generates new ones (starting from 1 increment 1).
How do i have to change my database setup, that the original QuestionNumbers are copied into the database?
how to authenticate users with the SQL Server database table using VB as a web service. I managed to connect to the SQL server via this VB code;
Public Sub ConnectToSQL()
Dim con As New SqlConnection
Dim cmd As New SqlCommand
[Code].....
how to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 Repliesi have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 RepliesWe are doing a project using VB2010 as front end SQL server 2008R2 as backend.We need the code to display all the images in thumbnail view in VB when we open a database table.
View 1 RepliesI am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard .
View 1 RepliesThe above is more or less the complete question. I have created a table in the VB 2010 Database Explorer but I cannot for the life of me work out how I can get this copied or created into the underlying server. It is not appearing in the underyling serverand when I run the code of course I ge "invalid object <tablename>" I have data as well in the table that appears in Database Explorer. I think I have missed something fundamental in my overall conception of using VB 2010 Express with SQL Server Express in that I don't know if I have a local copy (that isn't then mirrored on the server), or what (the ____ have I got)? An article that explains the overall relation of Database Explorer to the underyling Server would be great as well
View 8 RepliesI have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
I am new about VB. I've got one problem I can't solve by myself. The goal is to add to VB project form some command like table where I could enter some records and after that this data would be inserted in database by pressing commandbutton. Is it possible for datagrid to do something like this or Yhere have to be different data entry controls?
View 1 RepliesI'm using ASP.net to add a record into a table:
With SqlDataSource1
.InsertParameters("Name").DefaultValue = fldName.Value
.InsertParameters("Email").DefaultValue = Text1.Value
.InsertParameters("tContent").DefaultValue = taLE.Value
.Insert()
End With
I now realize that I need to get the id (a Unique Identifier that Auto Increments by 1) of the record I just added.
I am quite new at this so bear with me. I am trying to just download data, save it row by row into a database, then upload it (sorta a backup). I am using vs2010 and VB. The database I have in vs is a .sdf (not sure if i should remake as a .mdf) and the download of data is working fine. Saving it into a table isnt going so well. I am using a form to click a button to start the download, and most of my vb code is in another vb file. Making it into a method is causing me no end of pain due to the object refernce errors and nonshared reference errors. But I go to far for this. Anyways I tried to use
[code]...
[code]...
This codes are working but how can I validate the username if it is already in the database?[code]...
I have a Form1 that is the main application form, that display certain data from a database. Then I have Form2 that add/delete data from a specific table in the database.My problem is, When I add data to the database, and save it, it work fine, But, it does not reflect on the main form, after I close Form2. Only when I exit the application, and open it again, it shows. Is there a setting or something I need to do to update/refresh the info added so I do not need to restart the application?
View 3 RepliesI'm working with the project that require save all user personal information in one table when they login my system. The problem is too many users login my system per day ( or one user can login/out many time per day), it's very hard to manage. So, I want to add one more function which can specify one user information. My solution is create a text box and a find button to filter the user whose name in text box and copy to other table after that show that table, the problem is I don't know how to do that.
I also try the code which show below, but with that way I can't achieve my require[code]...
Another question is how can I delete all information in a table in database?
I am trying to insert a new row of data into table in an Access2010 database.There are 5 fields in the table called Users. ID, Username, Password, Manager_Access and Admin_Access. These fields contain data types ID(autonumber this is the primary key), Username(text string),Password(text string) and Manager_Access and Admin_Access are true/false boolean. I am using a comboBox, a textBox and two checkBoxes as the source of the new row data.I have used the Dataset Designer to raise an INSERT Query on the Users table called InsertNewUserRecord. The SQL statements look like this.
INSERT INTO Users[code]....
I have set the ExecuteMode in the query properties to Scalar.The code then looks like this
Dim Username As String = ComboBoxUsername.Text
Dim PW As String = TextBoxPassword.Text()
Dim MR As Boolean = CheckBox1.Checked[code].....
I am getting error messages telling me "Syntax error in INSERT INTO statement.If I try a query with just the Username and Password which are both text then it works fine.If I try a query with just one of the Boolean fields it works fine.If I try both Boolean fields or the text fields and one Boolean field then I get errors.