Search:

Type: Posts; User: Pradeep1210

Page 1 of 13 1 2 3 4

Search: Search took 0.36 seconds.

  1. Replies
    7
    Views
    940

    Re: SQL Bulk Copy

    You don't need the intermediate DataTable. There is an overload of WriteToServer which accepts DataReader.

    Somewhat like this:


    Sub DoTransfer()
    Dim connectionString As String =...
  2. Replies
    15
    Views
    1,386

    VS 2017 Re: Parameter is invalid

    You didn't show when you opened the connection. Is it open?



    'Connect Command to DB
    SqlGet.Connection = ConGet
    ConGet.Open()
  3. Re: How to use RecordSet in separate class object

    What is instanceOfMyAppDataClass?

    Try


    If Me.checkData() Then
  4. Re: Getting 4 digit year in all cases and setting?

    You need to have a look at System.Globalization.CultureInfo class and more specifically the InvariantCulture thing.
  5. Re: Passing a SQL query as parameter in additon to other parameters

    To use your table variable in a dynamic query, you would need to pass @MyDeadLines to SP_EXECUTESQL since it is not a physical table.


    EXECUTE sp_executesql @Query, N'@MyDeadLines UserDeadLines...
  6. Re: Passing a SQL query as parameter in additon to other parameters

    The NOT RECOMMENDED way is to use dynamic SQL



    @MyDeadLines UserDeadLines READONLY,
    @SelectThings text
    AS
    BEGIN
  7. Re: How to make links in div".conDiv" clickable because they are now not?

    I tried the regex on the links, numbers and email address you sent and all of them get selected.

    Is there any specific problem you are facing?
  8. Re: How to make links in div".conDiv" clickable because they are now not?

    I tried the regex on the links, numbers and email address you sent and all of them get selected.

    Is there any specific problem you are facing?
  9. Re: How to make links in div".conDiv" clickable because they are now not?

    Can you send some sample text that you are entering that contains the links/emails/phone numbers etc.?
  10. Re: How to make links in div".conDiv" clickable because they are now not?

    No, you can combine them into one regex using | character (which basically means a or b).

    Somewhat like this:


    function embedUrls(text) {
    var urlRe =...
  11. Re: How to make links in div".conDiv" clickable because they are now not?

    All you need is to come up with a good regex for what you need. What I showed you is regex for URLs which relies on the fact that they start with http/https.

    So for the links ending in...
  12. Re: How to make links in div".conDiv" clickable because they are now not?

    How are they sending links - Well-formed anchor tags or just URL in regular text?

    Try this:


    <script>
    function sendFunction() {
    var userName =...
  13. VS 2015 Re: Unhandled ComException after move from Office 2010 to Office 2007

    How many sheets do you have in your Excel workbook?
  14. Replies
    29
    Views
    144,044

    Re: Correct way to use the BackgroundWorker

    Just as I mentioned in my original post, you should not call the Form or controls on the form directly from inside the DoWork event. Instead, report progress and update any GUI elements there.

    The...
  15. VS 02/03 Re: Transfering data from excel to VB.net Application

    At-least there is no straight-forward good way to do this. There are workarounds though.
    Here are a few ways I can think of:
    1. Use AppActivate and SendKeys to set the focus on desired controls...
  16. VS 02/03 Re: Transfering data from excel to VB.net Application

    This is so confusing. Can you rephrase your question? Are you looking for a VB.NET solution, or you already have a VB.NET solution but looking for alternatives?
    And what data are you expecting to...
  17. Replies
    29
    Views
    14,618

    Re: Why Does Nobody Want To Help

    You ask question to one person and expect an answer.. but you don't want to ask question to all the members (including the one you PM) and expect no one to answer? :afrog:

    The prime purpose of a...
  18. Re: Datagridview jumping the first column to add a row

    You could just put a fixed dummy constant value.

    Like this:


    Me.Data1Dataset.Table1.Rows.Add(New Object() {0, Nom.Text, Prenom.Text, niassance.Text ... })


    Since the overload of Add...
  19. Re: how can I add cell clicked event handler to datagridview?

    If you want the control to fire events, use the WithEvents keyword while declaring it.

    So, in your case try:


    Dim WithEvents DGV As New DataGridView
  20. VS 2015 Re: Debugging stops without warning

    My bad.. I was probably wandering in my wonderland while writing that statement. I meant the Form Load event. :blush:
  21. Re: Goto much faster than a simple function? Performance problem

    Just as Arnoutdv said, calling a separate function has its performance implications because it has to push all the current variables into the stack and then again pop them back again after your...
  22. VS 2015 Re: Debugging stops without warning

    Is this happening in the constructor?
    The debugger doesn't stop on errors in the constructors (i.e. Sub New)
  23. Replies
    7
    Views
    935

    Re: Help With Funcitons

    You can also put all the REPLACE in one line since they return the output string and can be fed to the next REPLACE.


    Dim textBoxes = {TextBox1, TextBox2, TextBox3}
    For Each box In textBoxes
    ...
  24. Replies
    5
    Views
    842

    Re: Help click on element !!!!!!

    If you know the ID of the HtmlElement, then you can get it simply by using the GetElementById method. You don't need to loop and look thru all the elements on the page.


    Private Sub...
  25. Replies
    11
    Views
    8,968

    VS 2015 Re: update .csv file from gridview

    While reading/writing data from flat file is a bit cumbersome as compared to any database, it is not as hard as it might seem like.

    Modify your code like this.

    1. In your aspx file add a column...
  26. Replies
    11
    Views
    8,968

    VS 2015 Re: update .csv file from gridview

    How big is the CSV File? How many records?
  27. Re: StrReverse how to make this with VB.net LINQ or an other way...

    Yep, you guessed it right. I am using VS-2008 (.NET 3.5). And it seems weird that though there is no compilation error (which means the overloaded method is present), the outputs are different in...
  28. Re: StrReverse how to make this with VB.net LINQ or an other way...

    Doesn't seem to work. I get System.Linq.Enumerable+<ReverseIterator>d__99`1[System.Char] instead of the reversed string.

    This works though:


    Dim s As String = "hello"
    Dim r As String = New...
  29. Replies
    4
    Views
    1,230

    Re: JavaScript execution via VB

    As to your question, one of these might work.

    Try this:



    htmlInput.click

    'OR
  30. Replies
    4
    Views
    1,230

    Re: JavaScript execution via VB

    It would be easier for everyone to read your code if you format it properly.

    You just need to enclose your code in the CODE tags.

    e.g.



    ... your code goes here ...
  31. VS 2015 Re: Attach my VB.NET project (EXE) to javaw.exe

    What does "attach a program" mean? Do yo want to launch the java program from inside your VB.NET program? Or, do you want to embed the java window in your VB.NET form? Or something else?
  32. Replies
    11
    Views
    1,583

    Re: It'd be neat to "undo" rating a post.

    Looking at the bigger picture, no member whom you gave reputation by mistake (positive or negative) would go a long way if they keep posting the same quality of posts. If you added say 10 points to...
  33. Re: Earthquake in CA and code that doesn't scale!

    Are they all trying to connect to earth quakes? :rolleyes:
  34. Re: Access 2003 SQL NOT LIKE Sub query

    I don't know if there is a better way than this. But you can use this if you can't find a better alternative.

    1. Add the following code to a Module. You can do this by opening the VBA Editor...
  35. Re: Access 2003 SQL NOT LIKE Sub query

    No, you can't use LIKE like that. LIKE is for comparing STRING expressions only, you can't compare a list/array of values against it. You need to think of alternatives.
  36. Re: How to move a picture box randomly on the form

    One way to do it could be like this.

    Add a Timer control and a PictureBox to your form and the following code:



    Const StepSize As Integer = 10 '-- increase or decrease this to move the...
  37. Re: How can I use Select Case to show the number blocks with space?

    Like this:



    Dim fmt As String = ""
    Select Case TextBox1.Text.Length
    Case 6 : fmt = "000 000"
    Case 7 : fmt = "000 0000"
    Case 8 : fmt = "0000 0000"
    Case 9 : fmt = "000 000...
  38. VS 2015 Re: Background Worker very slow compared to main thread

    You are reading each file twice.


    Dim myReader As New TextFieldParser(FileToProcess)
    Dim lineCount As Integer = File.ReadAllLines(FileToProcess).Length

    This means that you spend almost double...
  39. VS 2010 Re: Read a text file line by line, use a number from each line to loop an array n tim

    Since your problem is now resolved, you can help us by marking this thread as [Resolved] so that others coming here with same/similar problems are helped too.
    It is as simple as pulling down "Thread...
  40. Replies
    3
    Views
    1,676

    Re: Dataset Stored Procedure Timeout

    I think the property you are looking for is burried a bit deep.

    You should use the TableAdapterManager class to set the command timeouts for individual TableAdaper commands.

    e.g.


    Dim tx As...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width