Search:

Type: Posts; User: ninelg

Search: Search took 0.04 seconds.

  1. Re: Problems with values when importing XLS into SQL

    One more question....

    I also connect to the Excel Spreadsheet and use a SQL Select command to retrieve the data from the Excel Spreadsheet and populate a datagrid.

    How do I incorporate the...
  2. Re: Problems with values when importing XLS into SQL

    It actually worked..I don't know what I was doing.

    Thank you so much Tom. You're a life saver.
  3. Re: Problems with values when importing XLS into SQL

    Thanks Tom. We're halfway there now.

    The number with the dashes is being imported, but now the number without the dashes are being imported like this: 8.13243e+009. How do I fix this?

    Thanks,...
  4. Problems with values when importing XLS into SQL

    I have an xls file that needs to be imported into SQL Server directly from .net.
    I figured out how to do this, but now my problem is the data. The following data is in the xls file: Name, Address,...
  5. Keeping Data in grid while displaying error message

    I have 5 textboxes embedded in a datagrid that require a date format (mm/dd/yy), but can be left empty if user doesn't have date.
    User can poplutes these textboxes for multiple records and hit...
  6. Replies
    3
    Views
    18,674

    Looping through XML with VB6

    I have the following xml document:
    <messageBody>
    <customerDetail>
    <accountId>123</accountId>
    <custId>ABC</custId>
    </customerDetail>
    <customerDetail>
    ...
  7. Replies
    18
    Views
    997

    Maximum arguments in a function?

    I need to create a dll. The dll will contain a function called passValues(). I will need about 82 parameters in this function.

    Will this work? Does anyone know what the limit is for passing...
  8. Replies
    1
    Views
    1,081

    Disabling the EditCommandColumn of datagrid

    I am using a datagrid with the "EditCommandColumn". This creates an "EDIT" link as one of the columns of the grid.

    My question is...Can I disable the link based on another column of the grid?
    ...
  9. Thread: Login Page

    by ninelg
    Replies
    1
    Views
    571

    Login Page

    I have a login page. I would like to add some more functionality and security to it. I have a table that contains users with their usernames and passwords. Every couple of months I would like to...
  10. Error: Redirect URI cannot contain newline characters

    I have a web page in which a user enters values into a comment field.
    I have another page where based on the selection of drop downs the user gets redirected to another page where they can view...
  11. Replies
    2
    Views
    589

    Maximum arguments in a function

    I have a function that has 66 parameters of which 13 are ByVal and the rest are ByRef arguments.

    This function is producing the error "Too Many Arguments".
    WHat is the maximum I can pass? Is...
  12. Replies
    1
    Views
    382

    XML Post not working

    I am using the following code:
    I create the xml and then call the xmlpost function.

    I am getting an error on the .send “The download of the specified resource has failed”



    Private Function...
  13. Replies
    4
    Views
    4,374

    Re: Importing csv file to SQL Server Using VB.Net

    How about doing a bulk insert on a text file that has the following datad:
    "7187893456"
    "8139987654"

    Will this work?


    BULK INSERT dbo.list_staging FROM '" & sLeadFile & "' " & _
    "WITH (...
  14. Replies
    2
    Views
    490

    Help with string functions

    I have a variable set to: "L:\VoicenetSQL\project\tampa\Politic\NGEV1\File.csv"

    I need to replace the "L:\" with "\\ITITPAFS02\pds\" so that the variable contains the value:...
  15. Replies
    1
    Views
    624

    Getting result of query within vb.net

    I am trying to execute a query from .net. The query is just a count of a table: "SELECT Count(*) FROM Table1"

    How do I get the result of the query into a variable? I don't need to set it to any...
  16. Replies
    3
    Views
    744

    Re: Creating stored procs with VB.NET

    I need to create a stored procedure that has quite a few statements.


    CREATE PROCEDURE usp_PoliticalProcessing
    AS

    UPDATE dbo.list_staging
    SET sPhone = RTrim(LTrim(Convert(varchar(30),...
  17. Replies
    3
    Views
    744

    Creating stored procs with VB.NET

    I have to create databases and stored procs based on a user's prompt through a web page.

    Is there a way to create a stored proc within VB.NET?

    Thanks,
    Ninel
  18. Replies
    1
    Views
    424

    Issues with DLLs

    We have a 3rd party company that created 3 dlls for us that I need to use in my code.

    My app is written in vb.net, but it is a web page.
    I referenced all 3 dlls within my application (there were...
  19. Replies
    5
    Views
    1,050

    Converting C# to VB.net

    I have samples of C# code that I need to use to instantiate an object or even multiple objects.
    I need to convert it to VB.net.

    I have a dll called ProjectUtilities. It is referenced in .net as...
  20. Replies
    4
    Views
    4,374

    Re: Importing csv file to SQL Server Using VB.Net

    Can anyone help me with this?
  21. Replies
    4
    Views
    4,374

    Re: Importing csv file to SQL Server Using VB.Net

    I am doing this on my local machine.

    I got it working with the following code with one exception:


    Private Function ImportLeadFile(ByVal projectfile As String, ByVal sLeadFile As String, ByVal...
  22. Replies
    4
    Views
    4,374

    Importing csv file to SQL Server Using VB.Net

    I have a csv file that is selected by a user. The csv file contains one column (phone number). I need to import this file into a table on sql server using vb.net.

    I've tried the following code:
    ...
  23. Replies
    1
    Views
    729

    Restoring database programatically.. error

    I need to programmatically backup a "template" database and restore it under a different name. The template database just contains the structure with stored procs, but no data.

    What I need to do...
  24. Replies
    1
    Views
    1,086

    Backup and Restore SQL database with vb.net

    I have the following code:



    Dim oSQLServer As New SQLDMO.SQLServer
    Dim oBackup As New SQLDMO.Backup
    Dim oRestore As New SQLDMO.Restore
    Dim BACKUPFILE As String
    Dim DATABASE As String
  25. Replies
    2
    Views
    404

    String functions

    I have the following path of a file:
    "L:\VoicenetSQL\Project\Tampa\Politic\AT0000\Test.csv"

    I need to pull out the folder name where the file resides. In this case I would need "AT0000".

    How...
  26. Replies
    1
    Views
    437

    Populating dropdown within a datagrid

    I have a datagrid on my web form that needs to contain a dropdown within each row.

    Here is the code I have so far:



    HTML: Just the template column of datagrid:
    <asp:TemplateColumn...
  27. Replies
    2
    Views
    451

    Re: Redirection Error

    I trimmed off the spaces and now it works.

    Thanks
  28. Replies
    2
    Views
    451

    Redirection Error

    I am trying to redirect to another page within my aspx page.

    Here is my code:


    Response.Redirect("IncidentReviewDetailUpdate.aspx?CommentHistoryId=1&IncidentId=2&IncidentType=DATA...
  29. Re: Dynamically adding/removing columns in datagrid

    Sorry, I meant to say the 3 columns shouldn't be visible.

    Thanks,
    Ninel
  30. Dynamically adding/removing columns in datagrid

    I create a report by allowing users to select certain criteria from dropdownlistbox.

    Dropdowns: site, project, startDate, endDate, reporting level (summary or agent detail)

    I have the...
  31. Replies
    2
    Views
    519

    Hyperlink control

    How can I capture if a hyperlink was clicked?

    Thanks,
    Ninel
  32. Replies
    1
    Views
    552

    Launching PDF without saving it first

    I need to launch a pdf document from vb.net without forcing user to save the document first. I want the user to just be able to view it.

    Is this possible?

    Thanks,
    Ninel
  33. Replies
    2
    Views
    536

    Validating Date From A String

    I have a textbox on a form. User will enter date in format YYYYMMDD. How do I validate this string? When I used
    cdate(txtDate). I get an error returned.

    Thanks,
    Ninel
  34. Capturing returnValue from DTS package executed from vb.net

    I got as far as being able to execute a dts package from vb.net. The dts package passes a global variable to a stored procedure.

    How can I capture the returnValue of the stored procedure in...
  35. Replies
    0
    Views
    479

    Datgrid: Displaying ids

    I have a datagrid that is populated from a dataset.
    The dataset contains TableId, EmployeeId, LoginTime, LogoutTime.

    HTML Code:



    <form id="Form1" method="post" runat="server"> ...
  36. Replies
    1
    Views
    475

    Populating drop down from recordset

    I have a stored procedure that returns recorset of a list of projects.

    How can I populate a dropdown with this recordset???
  37. Thread: Web Service

    by ninelg
    Replies
    1
    Views
    457

    Web Service

    I have a .net web service page called "Rep.asmx". There are 6 web service functions residing on this page:

    1. Function PunchIn(byval sXML as string) as string
    2. Function PunchOut(byval sXML as...
  38. Replies
    0
    Views
    5,455

    MSXML2.DOMDocument

    I am using classic asp to load xml.
    I used the following code to instantiate the object:

    Set xmldoc = server.CreateObject("msxml2.DOMDocument")
    xmlDoc.async = False
    xmlDoc.validateOnParse =...
  39. Thread: Posting to URL

    by ninelg
    Replies
    1
    Views
    383

    Posting to URL

    Can I post data to a URL in VB 6?

    For example, in a VB app I pull firstname, lastname from database and post to url www.myurl?firstname=sam&lastname=smith.

    Is this possible? If so, how?
    ...
  40. Replies
    2
    Views
    546

    Calling properties/methods of DLL

    I have a 3rd party dll created on .net. I need to create a vb.net app calling the properties/methods of that dll.

    I have the code in C# to do this, but how can I change it to work in vb.net?


    ...
Results 1 to 40 of 40



Click Here to Expand Forum to Full Width