My files are being inserted but the byte array is showing as a 0x0000... etc for every file after the first inserted file. The first inserted image is correct. The database is set up as an Image type. The problem exists in the code here\
Dim uploads As HttpFileCollection
uploads = HttpContext.Current.Request.Files
For i As Integer = 0 To (uploads.Count - 1)
[code].....
I have many text files in a folder. What I can do now is to read through one text at a time and insert it into the database. My little app reads a text file when I debug it. So, I need to run it several times to read all those text files and import them into the database.
My question is how to read multiple text files inside a folder at a time. Here's my code which works fine but it reads only one text files at a time.
Private Sub btnRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRead.Click
Dim filelocation As String filelocation = "F: xtfilesch25.txt" Dim chid As Integer chid = 25 'read from file Dim MyStream As New StreamReader(Path.Combine(Application.StartupPath,
[code].....
Obviously, I need a way to loop through a folder and check if there's text file. But I cant get it right.
What tools/methods are available to build pcl stream from PDFs.We have a bunch of generated PDF files that get tied up into one big pdf.I need to generate a print job to print this with the ability to insert pcl escape sequences (to control paper feed and output bin stacking) per page. As of now we use the VB.Net printing classes, convert the PDF into a rasterized image using a third party tool to print. This does not allow us to insert PCL sequences into the print job.
So, basically, we need to process a bunch of PDFs, append them to the pcl and insert PCL commands as we go along. Is there a way to achieve this. Our application is written in VB.Net.
Imports ATSMS
Imports Scripting
Imports System.IO[code]....
this is my code n it works well but wen i want to insert multiple textbox value then it gets an error.
i have a datagrid contol with multiple rows. my database structure and datagridview stucture is same.
now how to insert multiple rows from datagrid to database in vb.net
right now i'm trying to google some related article about LINQ to better understand it. But I came across with this issue been googling to find some answer but I didn't get lucky so here my problem.
For Each lvItem As ListViewItem In lv_orderlist.Items
passSQL = "INSERT INTO t_selling_history (f_product_id_fk, f_qty, f_qty, f_user_id_fk, f_created_dt, f_trans_status)" _
[code].....
I want to insert records from a datagrid with multiple rows, into the database, is it possible?
View 1 RepliesI have a directory full of .txt comma delimited files arranged as shown below. What I want to do is to import each of these into a SQL or SQLite database, appending each one below the last. (1 table)... I am open to C# or VB scripting and just not sure how to accomplish this. I want to only extract and import the data starting BELOW the 'Feat. Type,Feat. Name, etc' line.
These are stored in a mynetworkdirectorystats folder on my network drive. Ideally I will be able to add functionality that will make the software/script know not to re-add the file to the database once it has already done so as well.
[Code]...
i found in internet, many examples are regarding insert only one image. but now i want it to have multiple uploaded images that we can delete and view it first before we save it on database. how to store the images uploaded?
View 3 RepliesHow to insert and retrive multiple asp.net checkboxes values to MSSQl database as comma seperaed string 1,2,3,4,5 using vb.net ? and retrieve the inserted checkbox chekched in disabled form ..using vb.net url...I want this type of whole layout in vb.net means if user registered selected seats then then next the same page load for todays date the selected seats will be disabled
View 2 Replieshow would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 Repliesi have a big problem here when i want to insert 6 data into 6 different row in 1 click.
in field @ form it have name, staff no.,items, quantity and date. We can select 6 items to insert which i use ComboBox for save the data in form. In this case, each name can choose 6 items in one time and i want to save it in database just in 1 click. that mean it will put a same name in 6 rows in a table. the look like this but it not complete...
[Code]...
How to insert multiple data into mssql without using loop?
i'm developing a clinic management system, while doctor may give few medicines to patient,therefore i hope inside my database,the data will look like
[Code].....
this is my 2 tables, i hope when storing data ,the recordID will not increase based on how many ItemID inserted.
I'm designing a PC-based app that has a little local database. I'm using VB.NET with SQL Server Compact Edition. The user will only ever have access to one database file, because it's all about storing a user specific data. However I'm thinking of the situation where there could be multiple users that access the PC, each with their own Windows account. So ideally I'd need separate database files for each User.
I'm not sure how to implement this. I was hoping to deploy the 'empty' database as a ClickOnce deployment, but I can't see how I can have a database per user doing this. Also I'm not sure where to store the database files anyway. perhaps in MyDocuments for each user? Or perhaps I need to stick to just one database, but add a 'User' column into every table, so it can hold data for every user. I didn't want to do this though - because I wanted to keep the nice separation between the data offered by physically separate files.
I have a website that has highly granulised access and hence requires many web.config files. The problem is I would like to trim the menu so that only certain users will have access to certain folders. I have enabled trimming and setup roles in the sitemap, however when I access the page the menu is not show, as I am authorized to view the default page which is not in a subfolder. When I type the url of a page in sub folder's I have access.
How should I handle this:
A site map for each web.config file - don't know how this will work Removing the sub web.config file to only use a single one
I know this is out there and probably illogical but I was wondering if it was possible to take multiple picture files and compact them into one file.... and then retrieve them from the program later? Way to combine any amount of image files into one file
Module Module1
Sub combine()
Dim img1 As New Bitmap("i1.jpg")
[CODE]...
could someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
[Code]...
Visual Studio 2008VB.NETFramework 3.5Windows Application
I have a SQL database names TestSQLVB
In it a table called tblTest2, with a three fieldstest2id , int, pk, increment by 1field1, varchar(50)field2, varchar(50)
I have a dataset named Dataset2.xsd
A tableadapter named tblTest2TableAdapter
A insert query names InsertTest2 with fields @f1, @f2 and ExecuteMode = Scalar
When I run the following code per MSDN [URL] the database does not get updated.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim testds As New DataSet2TableAdapters.tbltest2TableAdaptertestds.InsertTest2("One", "Dog")
End Sub
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'm developing an application to help law enforcement retrieve and analyze logs and other files left by the use of Pidgin (a multi-protocol messenger client). Right now I'm nearly done, but I want to add the ability to search chat logs for user-defined words or phrases and I don't even know where to begin.
Chat logs are stored as html documents in a folder/sub-folder/sub-folder/sub-folder fashion, where each sub-folder can have dozens of sub-folders inside of it, and the final sub-folder can have dozens if not hundreds of chat logs. If anybody could point me in the right direction, I'd be very grateful.
(Also, this is the first program I've written since about 2005, and I'm essentially teaching myself VB as I go. If you'd like to see what I've cobbled together so far, you can find the program here.)
why my insert doesn't insert into mysql database
[Code]...
here is my code so far:
Public Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim i As Integer
[Code].....
when i click the button, i get a error message saying "Syntax error in INSERT INTO statement". as far as i can tell, i have everything i need to insert a new row into the database, and i dont see why this problem is occuring.
item(0) is an autonumber key field, so that should make a new record by itself, and i have declared the input textboxes as the data() array
I'm trying to copy multiple excel source files into one excel file. My current code is working only for 3 source files..If more than 3 files are there, it doesn't copy the data but creates blank work sheet in the output excel file. Lets say I have a source folder with 5 excel files. Each workbook contains one worksheet with data. It copies upto 3 worksheets along with data into output excel file.
Lets say excel1 contains A as work sheet, excel2 contains B as work sheet ,excel3 contains C as work sheet ,excel4 contains D as work sheet ,excel5 contains E as work sheet .Now my output excel file should look like..OutputExcel with A, B, C, D, E along with respective data.But my current code is giving output as A,B,C worksheets along with respective data but its creating blank sheet1,sheet2 in place of D & E.
SSIS Script Task Vb.Net Code:
Public
Sub Main()
Dim filePath
As
String =
[code].....
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 RepliesI have a table for users (username, password .. etc) and another one for products (product name, price, quantity, username .. etc)
I want the username from the first table to be inserted (with the rest of the product info) into the product table when the user put it for sale.
How can I do this?
I'm using visual web developer 2008 express
I am using C# and MSAccess as my database.
Code:private void ExecuteQuery(string strempname,string strQuestion,string IndividualRating,string OverallRating, string Comment1, string Comment2,string Comment3, string SessionName) { string strQuery= string.Empty; try { strQuery = "insert into FeedbackDetails(EmpName,Question,IndividualRating,OverallRating,Comment1,Comment2,Comment3,SessionName)"
[code]....
so this actually opens and close connection for every method. but i need to open and close the connection only one time. so how to customize this code to achieve my need. now i am hitting database for 14 times in a button click as of now. instead i need to hit only once but all the rows has to be inserted in my database.i am using MSAccess as Database.
queryStr = "INSERT INTO tbl_user_ldr_responses (rec_num, ques_no, response, comment) " & _
recnum & ", " & "1, " & "'', " & reader.GetValue(1) & " UNION ALL" & _
recnum & ", " & "2, " & "'" & reader.GetValue(2) & "', " & "''"
How can I fix my string so that it will resemble the below SQL code to insert multiple records with one insert command?
INSERT INTO thetable (field1, field2)
SELECT value1, value2
UNION ALL
[Code]......
I'm trying to upload to a folder files, however, this files can already be there, so the user could replace or maintain all the files. So if the user choose to maintain the file, I must rename the new file, like: file(1) --> or something like that.
View 14 RepliesI created a dataset and i am using OleDbDataAdapter to insert new values to access database. But when i close the program and after open it, values are not in the database. How can i solve this problem? Also, i have another problem. When i write codes that
[Code]...
I'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
[Code]...
