export csv file into sql server
I am working with .net windows application. I have csv file .I want to export this file to a table in sql server.I have the data adapter designed in the dataset. ...
I am working with .net windows application. I have csv file .I want to export this file to a table in sql server.I have the data adapter designed in the dataset. ...
I have a VB.net console app and I am opening a function in a dll written in fortran. I am passing 3 arrays through the function by reference. When they come back out the otherside they ahve all tunred to arrays of only one element. And that element is 0. I read on the internet somewhere that when doing this kind of thing it is a good...
Hello, Is there a way to generate URL inside a controller? I want to do the following inside a controller instead of a view. <% =Url.Action("Validate", "Home", New With {.ValidID = ID})%> ...
Hello, I found several examples on how to write to dataset, but most of them involve a ds.fill(..) from a data connection and I need a simpler solution. Basically I want to create an xml file from the values entered in a few textbox. I tried different methods but can't make it work. What is the best way to accomplish this? One method ...
I have the following multithreading function to implement threads fetching from a list of urls to parse content. The code was suggested by a user and I just want to know if this is an efficient way of implementing what I need to do. I am running the code now and getting errors on all functions that worked fine doing single thread. for ex...
Private Sub ChangeCursor(ByVal target As FrameworkElement, ByVal cursor As Cursor) target.Dispatcher.Invoke(DispatcherPriority.Normal, New DispatcherOperationCallback( _ Function() Mouse.OverrideCursor = cursor Return Nothing End Function), Nothing) End Sub and...
I'm trying to write an application that will allow a non-administrator user to create virtual directories in IIS6. I've tried numerous different ways of impersonating a administrative account but nothing seems to work to create the virtual directory. Here's some of what I've tried: dim sDirPath as string = "IIS://remotehost/W3svc/1/ro...
I have numeric data that I am getting from a database. They are all numeric, but they are a mix of int, money and real. Using VB.NET, how can you programmatically determine the datatype of a field in a resultset? ...
Using vs2008, vb.net, C#, fw 3.5 I am consuming my service in my client Service is hosted in IIS Client(winforms MDI) is generated using svcutil using /l, /r, /ct, & /n switches Service and client both use a MyEntities.dll I am using nettcp with TransportWithMessageCredential I cache the proxy in the main form if Membership.Valida...
If I want to set my Font I can use new Font=("Times New Roman", 12, Drawing.FontStyle.Bold) Instead of Bold, I can use Italic, Regular or Underline. But I want to make use of Bold and Italic at the same time. How can I do this? ...
i am new to this. i have 4 pages. login.aspx, account.aspx, settings.aspx and fliers.aspx. its all programmed in vb.net with sql server backend. on my firstr page, login.aspx i have this code in the .vb page - Dim SQL As String = "SELECT * FROM table1 WHERE email='" + Me.txtUserName.Text + "' AND password='" + Me.txtPassword.Text + "' "...
im using asp.net with vb.net in backcode. On my first page, i diplay names of all employees. I want to give that a hyperlink, that when clicked upon shall open the next page with say a querystring and opn only that employees records. Also I want the save the employeeid (which is not shown on page 1) on the second page, cause when i do up...
I am running a crawler and tried to implement a multithreaded crawler. I created multiple threads to take a url from a list and go crawl it. What I would like it to do is either have all the threads fetch a url concurrently or for each thread to fetch one and then parse the html. What I have so far is not working and previous posts have ...
I have a customer combobox that allows the programmer to set tooltips for the dropdown items at run time. It works great as long as the listing is from the dropdown (i.e. I press the down arrow.) However, I would like it to work for the "SuggestAppend" list as well, but it isn't. I 'borrowed' the code from an online source (can't remem...
Okay I;m really new to VB.NET and desktop application development. Simplified this is what is happening in my application: Dim Files() As New List(Of IO.FileInfo) Files.Add( (New IO.FileInfo("C:\img1.jpg")) ) Files.Add( (New IO.FileInfo("C:\img2.jpg")) ) 'Picture is a Windows.Forms.PictureBox in my WinForm ' Picture.Image = New System....
I would like to have some sample code on how to do a paginated ComboBox. My data consist on 1300+ items. When the user clicks the combo box arrow, the combobox will display display 25 (page size configurable) items at the time with arrows up/down (depending on page location) so that the user can request the previous/next page. The data i...
I am writing a search engine whose purpose it is to search all kind of blogs for specific kinds of content. I'm particularly focusing on these blogs engines: Blogger LiveJournal MySpace Open Diary Tumblr TypePad Windows Live Spaces Wordpress.com Xanga Now my question is: Is there any way I can use google to find links that are from a s...
Hi, I am having a problem getting pastespecial to work. Here is my code: osheet.Range("C2").Copy(.Range("C3:C" & endRow)) '**end of data osheet.Range("C:C").Select() osheet.Range("C:C").PasteSpecial(Paste:=Excel.XlPasteType.xlPasteValues, _ Operation:=Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, _ SkipBlanks:=Fal...
this is my vb.net code - in the subroutine i have - Private Sub xxx() Sqlstr = "SELECT * FROM table" ExecuteNonQuery(Sqlstr) SqlCmd = New SqlCommand(Sqlstr, SqlCnn) SqlDR = SqlCmd.ExecuteReader If SqlDR.HasRows Then Do While SqlDR.Read() r = New TableRow ...
I have a very basic windows forms app. it needs to download some files in the background. How can I tell when the download is done?? Here is what I have: Dim bits As New SharpBits.Base.BitsManager Dim mynewjob As SharpBits.Base.BitsJob = _ bits.CreateJob("jobname", SharpBits.Base.JobType.Download) mynewjob.AddFile("ht...