I have a WinForm 'frmUploadStatus' which has a datagridview filled with 1000 records & 20 columns.And also I hosted in hosting server ms sql server 2005 database which has tables one of its table 'Status' (it has 10 columns).Now I want to upload from WinForm 'frmUploadStatus' to ms sql db.
If I change only the connectionstring in my program for uploading the records, it takes more time for uploading.
i am using asp.net and vb.net 2008 ,sql server 2005 for my web application.i want to upload files(.PDF ,.DOC, .DOCX file extenstion in to my table) i did the followin:
create table filetable(filename varchar(300),filesize int,filedata text,contentType varbinary(max))
does the data type of each column correct?
Dim con As SqlConnection
Dim cmdinsert As SqlCommand
con = New SqlConnection("server=(local); Data Source=gig;Initial Catalog=mydb;User ID=sa;Password=test")
Dim str As String
[code]....
can u drop me a line how to uplad pdf, and word files in to a table and then how to get them back?
I often need to copy complete transactions from the production system into the test system. The database structure is the same. Some of the fields in a table might have NULL values.
My objective is to write a program that will fetch records associated with a particular transaction and copy them over to the test system. The database is Oracle 9i (production system) and Oracle 10G (on the test system).
[Code]...
If I give a specific member id, it should fetch all records in MEMBER_MASTER and MEMBER_ADDRESS tables and insert these records in the test system. What is the best way of developing this app? Currently I use sqlloader to do this.
I want to build a front-end and I am thinking I could learn some VB .NET along the way.
i have 3 user roles "ALGEMEEN,OZIS,VERPLEEGKUNDIGE".And I want them added to the database.But when I use the code below it only adds the userrole "ALGEMEEN" and not the other 2.
Dim cmdCheckLidVan As New SqlCommand("SELECT COUNT(*) FROM [Lid van] WHERE [Gebruikers-ID] = @ID AND [Rol-ID] = @RolID", connection)
Dim strRolArrCount As Integer
Dim strRolArr() As String
[code].....
My code below will save records to my database as long as all the parameter have values. One of the parameter is @MI (middle initial), however, there are times that student have no middle initial so when I click my button I get error. I want to still save the record even if one of the parameter value is missing.
[code]...
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesI was just wondering if it's possible to create an app that interacts with a database hosted on a web server... or is it only possible using VB.NET? Also if it is possible, is there any good documentation or tutorials I could reference?
View 2 Repliesi want to upload a file in vb.net.
View 4 Repliesgive me a sample code that works when uploading data from access database into MySQL database...
View 6 RepliesI have wrote a routine to upload a database file to a server using webservice which works fine until I try and send a large file. It errors all the time saying the connection was disconnected. how to upload large files?
View 4 RepliesI can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
View 4 Replieshow to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 Replieswhy when i upload less than 10 item the program do but more than it like 15 and above the program give me error saying "Index and length must refer to a location within the string."
here is my codes below
For Each myDatarow In tblLocal.Select("sync ='0'") '
' tblServer.ImportRow(myDatarow)
' dataimpt = myDatarow.Item(4).ToString
[Code].....
the error appear when the program is going to update the 14th data... meaning from 1st to 13th data program works in the 14th it's not it gives me error "Index and length must refer to a location within the string
i want to develop registration form that asks, username, password and curriculum vitae(cv) file. the third column will store files that are uploaded by clients. user can edit their CV by logging using their username and password. so my question goes here. is that possible to upload the file into database? is there any drawback to upload files into database? and is that possible to send the username and password to a table, and the file into a folder so that user can edit their CV using their username and password, is there a means to connect them?
View 2 Replies<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[code]....
I am trying to achieve the following. I have a web page that I want users to upload a .csv file to, that places the file on a local server and then after that the file is then bulk inserted to a sql database. I can't get the file to save in the location mentioned in the script and I would like to do the bulk insert cleaner.
I have a DatagridView which displays the following: IDNo, SubjectName, FirstName,MI, LastName, YearLevel, Address, Gender. I want to save whatever is displayed in it to my database...My code below does not save the SubjectName all the rest are saved.
Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click
Try
[code].....
Programmatically using vb.net, could we export all records of a sql table into a txt file at once?
View 1 RepliesI have ALWAYS used the SQLDataSource to update my records in my SQL Server 2005 database, so i am not really sure how this would be done in normal code. I am using VB.NET but if you are a C# developer and want to show me some code that is more than welcome as well.
I am using ASP.NET 3.5.My user will see a page with 5 Text boxes with their contact details in. Those details I will get from a SQL Server DB and when they go and change the text in the text box and click submit, it must then save the changes.
This is very easy with the SQLDataSource but how can i code this myself?
I am trying to learn XML, for which i have created a simple Employees Program. I want to save the records of the employee in an xml file, so far i have the following code:
vb
Private Sub SaveRecord(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim XMLSettings As New XmlWriterSettings
XMLSettings.Indent = True
XMLSettings.IndentChars = " "
XMLSettings.NewLineOnAttributes = True
[Code] .....
This is only working for a single record, How should I insert more employees records within this xml file?
i have a problem in displaying records between two dates...i have two datetimepickers to choose date from datebase...start date and end date..when i choose start date 1/1/2009 and end date 1/12/2009 then all the records between 1/1/2009 and 1/11/2009....the records of date 1/12/2009si not shown...date format is month/day/year.....i have posted my code below..
Dim rpt As New CrystalReport8() 'The report you created.
Dim cn As SqlConnection
Dim cmd As New SqlCommand()
[Code].....
I need to create an HTML page to be sent as E-mail , the HTML page should contain an Table which contains the records from the database. The records to be selected from the database are bound by the conditions given by the user.So i wanted to ask what is the best way to create the HTML page, should i create them dynamically or Can we link the HTML page to the DB , or anything else.
View 2 RepliesI have the following records in DataGrid .see in Pic. On button click, I am scanning thru all the records. Just tell me that dataGrid RowCount is from:
For j = 0 To DataGridView1.RowCount - 2
Or
For j = 0 To DataGridView1.RowCount - 1
Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button11.Click
[Code] ......
I am making an inventory program in which there's an ItemMaster and Sales Form. Currently there are 15000 records of items(increasing daily). I want to display all the items in the sales form so that the user can select an item from the list for billing, and also in the itemmaster so that if the user wants to edit any item then he can select it from the list.
I can make a common list form for both sales and master, but i have to load the data from the database into the list every time the list is displayed(which is taking lot of time), so is there an better way to do it.
How do I display the concatenated records in my combobox? I have the following codes
Private Sub frmAssignSubjects_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If cnn.State = ConnectionState.Closed Then cnn.Open()
If rdoHS.Checked = True Then
[code].....
What should I put in the DisplayMember and ValueMember? If I will not concatenation, I just use "LastName" and "IDNO" in my DisplayMember and ValueMember respectively then records get to display in my combo.
Im inserting records from a dataset to access table by selecting a key(dix) from a listbox. below is the code Sub loop2(ByVal dix)
ds.Clear()
table_name1 = "TestStepDetailTable"
con.ConnectionString = dbprovider
con.Open()
'MsgBox("database is open")
[Code]...
The problem is when i insert a first key(dix) records its coying fine. But when i insert the second set of records in is sorting int he table. but when i looked at the dataset by using gridview the recods appears in a right order. but the updated table is somewat sorted order. Is there any possible way to insert the records in the same order in the dataset..
I managed to displayed records from two tables in one datagridview and the first column being a combobox. Now, I would like to get those records displayed and save it to another table. this what I did.
For i As Integer = 0 To dtgLoad.Rows.Count - 1
Using command As New SqlCommand("INSERT INTO tblteachersload (Teacher ,SubjectName) " & _
"VALUES (@Teacher, @Subject)", cnn)
With command.Parameters
.AddWithValue("@Teacher", Me.dtgLoad("Column1", 0).Value)
[Code] ......
I would like to loop through the records of the datagridview and then save the same to a table.
I have the following fields in my table:
English
Math
Science
Computer
[code].....
How do I get to display only the students records with a grade 85 and above in all subjects?
i'm making a utility in which i'm loading 100,000 records again and again, problem is that it takes much time to load records in datagridview every time.
i've used data set and data reader both but same result. if i use paging then there's will be a problem of search a record on keyup event.
I have the following problem. I have some project written in Visual Basic (not Visual Basic .NET but simple Visual Basic - sic!). I can compile it and generate a dll. Then inside my web application I add reference to this dll library. When I run my web application hosted in default Visual Studio server, everything is fine and I can debug my Visual Basic project. However, when I host my web application in IIS then I can't.Code does not stop in my breakpoint. My asp.net catch the exception when I try to execute some method from the mentioned library which is something like:
Unable to cast COM object of type 'xxx' to interface type 'yyy'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{4C2875B5-3265-306B-9C74-1BEC98986B1A}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
I have sets of web hosted images that I need my user to be able to select 1 from each. I thought a listbox would work for this, but I can't figure out add an image to one. Is this possible? better way of doing this? I am using the latest free vb.
View 2 Replies
