There are about 1000 jpg files need to save into SQL server as image type. I created two fields in the table tImage: one is [Filename] which will take jpg file name and another field is [NewImage] which will store jpg as image. How to code to loop all jpg files and save into SQL table? (jpg is located at d:jpgfiles)
View 1 Replies
I have 2 Tables Table "A" and Table "B". Here is little details.
Table "A"
---------
ItemID (Primery Key)
ItemSKU
[Code]....
i have a parameter error
check this statement
Dim conn As New OleDbConnection
Dim cmd As OleDbCommand
[code].....
The way it works is for each event, there can be multiple 'disciplines'. So I have a disciplines table related to my events table.
I save an event and save a discipline within it, when I open the application again, the event has saved but the discipline hasn't.[code]...
I added a datagridview box to my form from the tools menue. I added some columns and would like to place a save button that allows users to save the data they put in those columns. The datagridview is not bound to a database, it is only being used for design reasons and a database is not necessary. What code can I use in the button to save the changes?
View 10 Repliesi have a form with two sections.header part and detail part.header part contains some text boxes and detail part includes datagridview.when i enter the values to datagridview while runtime ,i want to insert the datagridview values to sql table.when i insert the first row of datagridview will save to sql table but another rows willn't save to sql table and showing an error"Procedure or function Insert_Sales_Detail has too many arguments specified".how can i save all rows in to sql table?
View 1 RepliesI created an ASP Table Control and added a row to it programatically. I then repeated the process to add another row. The first row that I added disappeared and only the newest row is being displayed. Is there a property that needs to be set to allow the state of the table to be saved?EDIT:All I do is click a button on the page and it adds a row to the table. Repeated clicks of the button only add one from to the table., here is the function that adds the rows.
Protected Sub addItemButton(sender As Object, e As EventArgs)
'get the id of the item they selected
Dim id As String = CType(sender, Button).Text
[code]....
i have a Access table named "Loginnumber" with columns "personeelscode ", "filename". "foto" all i want to do is update this table with new info in VB i have a form with an picturebox1 and a textbox for personeelscode and a textbox for filename change it to the right code cause i think there is something wrong with my commandtext
Private Sub Searchpicture_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchpicture.Click
With OpenFileDialog1
[Code]....
I have a datagrid with three columns of data and i need to save all those data to a table in SQL Server.
View 6 RepliesI 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]...
I have a form that i am entering data into and then click a save button to update to the database. but i can not give it to update.[code]....
View 5 RepliesI think I am almost there but can't find the final piece of the puzzle.The code all works fine if I dont include an image as part of the save but need help with setting the correct parameter for the image.
[Code]...
I have a register.aspx and a login function and i am using vb.net
in my register.aspx...i have a user name textbox and a password text and a submit button. IF the user click on the submit button, the password will be hash and store with the username in the database table called "Customer"
1st Qn: i have a problem is that i never try before hashing, so i not sure how to code it , hopefully if someone got a sample or example to teach me it will be nice
2nd Qn: besides that, in my login function, how am i going to compare the hash value for password that is store in database with the password in the textbox to allow to login?
i have a comma delimitted text file that i need to add three fields and update the contents of those three fields and then save the text file.
right now i bring the file into ms access and alter the table to add the fields and then update them but i don't know how to export the access table back into a comma delimitted text file.
I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt.How can I save this dt content into another table of the same database.I'm not ussing stored procedures and dont understand much of parameters.
CODE
Dim cs As New SqlConnection("Data Source=myserver;Initial Catalog=mydatabase;Integrated Security=True")
Dim da As New SqlDataAdapter
Dim ds As New DataSet("Chosed")
[code]....
I'm currently working with these codes. Am I able to save my image and drawing into mySQL table? what codes should I use in order to save them into my table and I may need to able to retrieve it in a later part.
my codes:
Code:
Public Class Page_2
'Declare Starting Points For Drawn Objects
Private sStartX As Short
Private sStartY As Short
[code]....
I use Visual Basic 2008 + MySQL Database.I have create a textbox1.text .MySQL Table Test with Two Columns[code]...
View 4 RepliesI have a stored procedure, and I want to save the results of the stored procedure into a table. Is there a way I can do this with a simple query without creating the table beforehand.
View 8 RepliesI have a MonthCalendar1 on my form and i am trying to save the day the month ans the year to a table from the MonthCalendar1.
.Fields!ISBN.Value = txtBookIsbn.Text
.Fields!SupplierID.Value = txtSupplierID.Text
.Fields!Date.Value = MonthCalendar1.BoldedDates
[code].....
This is a very basic question. How do i update a sql table from vb.net on save button click. This is my insert to code....how would it be for update?
[Code]...
When subtracting two doubles the result appears to be correct but when I save said results in a SQL Server table they are incorrect. I know their are problems with decimal values in the binary world but isn't there a work around for this?For example 421.2 - 418.9 = 2.3, but the result stored in the SQL Server table is 2.29!In the VB code I used Math.Round to round to two digits and the values appear correct during debugging but, as I've said, in the end they are off by .01. [code] decimal(10,2)BTW, I've tried numerous methods of getting the correct value but have not met with any success. I've used Math.Round on Val1 and Val2 separately, after the subtraction, and on the ResultVal. I've also converted the ResultVal to a string using Format(ResultVal, "#####.00") and then back to a number but still the value that ends up in the SQL Server table is wrong.
View 5 RepliesI have face problem with null value i remove the chk from null value n sql server and when i direct save anything in table it dosen't accept null value but when i save these in my form it accept null value.
View 11 RepliesI am creating an app to grab data from excel and preview in datagrid. From the datagrid I want to be able to save to a sql table. I have the excel data in a gridview via a dataset. What I am having trouble with is the sql statement. I know how to insert data, but I can't work out how seperate the data in the dataset to pass it into individual Values of the insert statement. Or should it be done another way? NOTE: I is not essential that the excel data be previewed in the gridview if this would make life easier for me.
Here is my code so far:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Grabs data from excel sheet and stores it in datagrid.
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim con As New OleDb.OleDbConnection
[Code] .....
I have a large csv file that I want to read into my program and sve it to a SQL database table.I'm useing VB2008 and my dabase is SQL2008.
View 2 RepliesDim da2 As OleDb.OleDbDataAdapter
[code]...
Dim da2 As OleDb.OleDbDataAdapter
Dim cols As Integer = Attendance_QueryDataGridView.ColumnCount
Dim rows As Integer = Attendance_QueryDataGridView.Rows.Count
[code].....
How do you save an html table built programmatically in a .html file?
View 13 Replieshow to store CSV & Text file to an Image Field in SQl table. the table is using by some other application that's why i could not change the field data type.
View 5 RepliesHow to Save DataTable Structure And Data Into A Datatbase Table..
View 7 Repliesi'm having problem saving my records into database here's my code
[Code]...
