Search:

Type: Posts; User: IliaPreston

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds; generated 14 minute(s) ago.

  1. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks for your advice.

    What are those newer technologies?
    Please note that i am talking about developing GUI applications (having forms with buttons, checkboxes, textboxes, grids, etc. on them)...
  2. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.
    I did what you recommended, and it works perfectly.

    You also said:


    Also, in line with that statement, in post #22 you said:


    Is concatenation (for the purpose...
  3. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks for your help.
    Windows rebooted my computer to install updates.
    Then, suddenly the problem (empty properties page) went away and it works fine.
    The using declaration works fine as well.
    ...
  4. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.

    Based on your statement (above quote) I assume that that first selection means .Net Core.
    So, I selected that:
    https://i.imgur.com/o0grgah.jpeg...
  5. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.
    But, looks like I am stuck.

    I deleted the whole new solution/project and tried to create it from scratch.
    But, looks like there is no item to choose for ".Net Core" +...
  6. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    As I said in my previous post, your recommendations worked perfectly.

    But then I realised that that was an EXISTING solution/project.
    So, I thought the initial cause of the problem was (maybe)...
  7. Responding to an existing thread doesn't work

    I just tried to respond to one of the posts under this thread:
    https://www.vbforums.com/showthread.php?902467-Problem-with-conversion-of-values
    by clicking on "Reply with quote".

    When I clicked...
  8. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Yessssssssssss !!!!!!!!!!
    It works now.
    I am so happy.

    Thanks a lot for your help.
  9. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.

    I can certainly do it like this:

    using (var obj = new SomeType())
    {
    // Use obj here.
    }
    but, I also wish I could do it by means of the declaration, like this:
  10. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.
    You are basically raising two points, both of which are valid and interesting.

    Let me first discuss the second point, that is the issue with connections.
    You told me...
  11. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.


    I am not quite sure what that means.
    Those routines have everything that they need passed to them as input parameters.
    So, what parameter do you think is missing in...
  12. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks for your help and comments.

    You may be right on that, but I am not sure.
    An sqLite column is stored as sqLite REAL datatype which is the equivalent of C# double datatype.
    So, in that...
  13. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    I am converting to single because I need a single.
  14. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks for your help.

    First of all the query is:

    sql = "select STD_NUM * 15.37 from STUDENTS where STD_NUM = 1001"

    So, obviously, the output is expected to be 15385.37 but Visual Studio...
  15. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Looks like there is still a problem in here.

    My original bad code:

    return Convert.ToSingle(retVal);


    works, but, there were a lot of objections raised against it in...
  16. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.
    It makes a lot of sense and is very informative.


    I am sorry if my question was viewed as blaming.
    I ABSOLUTELY don't blame anyone.
    The only reason why I asked it,...
  17. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Thanks a lot for your help.
    The reason I wrote it that way is that I learned from your code in post#6 in...
  18. Replies
    45
    Views
    5,283

    Re: Problem with conversion of values

    Hi.
    Thanks a lot for your response.
    I think maybe I didn't clarify my question properly. So, I will explain in here.

    I am writing a routine like this:

    public float...
  19. Replies
    45
    Views
    5,283

    Problem with conversion of values

    I have a routine that reads an int value from database:

    public int RunSqlReturnInt(SQLiteConnection conn, string sql, int AltValForNull = 0, int AltValForNoRec = 0)
    {
    ...
  20. Replies
    11
    Views
    1,202

    Re: Need help to get rid of a virus

    Thanks a lot for your help.

    Ever since I ran Malwarebytes full scan and uninstalled google Chrome, the problem has completely stopped.
    No more notifications pop up.

    Thanks again for your help.
  21. Replies
    11
    Views
    1,202

    Re: Need help to get rid of a virus

    Thanks a lot for your help.
    However, I don't think I can go to Google Chrome Settings > Ste settings > ...
    At least not yet, because as I said in post #6:


    But, your advice is really...
  22. Replies
    11
    Views
    1,202

    Re: Need help to get rid of a virus

    I really don't know.

    What I can say for sure is that I did not DELIBERATELY enable notifications from that site.
    I NEVER enable ANY notifications from ANY site.
    I ALWAYS say NO to all of those...
  23. Replies
    11
    Views
    1,202

    Re: Need help to get rid of a virus

    Here is what I did:

    After I initiated this thread, I closed google Chrome.
    Other browsers (Waterfox and Vivaldi) as well as a number of other applications were left open.

    Then I left my...
  24. Replies
    11
    Views
    1,202

    Need help to get rid of a virus

    A few hours ago, I was surfing the web using Waterfox browser, when a search lead me to a Chinese website.
    I couldn't read Chinese, so I copied the URL from the addressbar, opened google Chrome,...
  25. Re: Problem with ExecuteScalar and ExecuteReader methods to read a single value

    Thanks a lot for your help.
    Now my routine works fine.
    I have to set this thread to Resolved, but before doing so, let me understand something:

    Is it true that the column values in...
  26. Re: Problem with ExecuteScalar and ExecuteReader methods to read a single value

    Thanks for your help.

    I am trying to write the routine like this:

    public int New3_RunSqlReturnInt(SQLiteConnection conn, string sql, int AltValForNull = 0, int AltValForNoRec = 0)
    ...
  27. Problem with ExecuteScalar and ExecuteReader methods to read a single value

    Regarding sqLite in C#:
    I know that in order to read a single value, I should use the ExecuteScalar method instead of the ExecuteReader method.
    Let's say for now the value is of int type.
    However,...
  28. Re: Visual Studio C# Toolbox is empty very so often

    MS wants to move away from Windows Forms !!!???
    I am not sure what you are talking about.

    If that happens, then how can we develop a simple application containing some forms and placing some...
  29. Visual Studio C# Toolbox is empty very so often

    Seasons greetings everyone.
    I wish you all a very merry Christmas.

    The problem that I am going to explain, happens to me soooooo often:

    I open Visual Studio, and suddenly the Toolbox is empty:...
  30. Re: I get this error: database table is locked

    Any comment on my latest post (post #22) would be greatly appreciated.
    Thanks again for all your help.
  31. Re: I get this error: database table is locked

    Thanks for your advice.
    Regarding the scope of the connection object, I understand that:

    1- The connection object is lightweight. Therefore creating and immediately dropping it for every use is...
  32. Re: I get this error: database table is locked

    Thanks for your help.

    1-
    2-

    I am willing to believe you on both counts, but a simple test shows otherwise.
    Here is a screenshot:
    https://i.imgur.com/DeTVjdq.jpeg

    In the above screenshot...
  33. Re: I get this error: database table is locked

    Yes, this time it worked.
    However, at the last moment, I suddenly noticed that in the local window, result is of type object(long).
    (Same screenshot as my previous post:...
  34. Re: I get this error: database table is locked

    Hi.
    Thanks for your help.

    I made the change that you recommended, but the problem persists.
    Here is a screenshot:
    https://i.imgur.com/9GALhb9.jpeg

    Please help.
    Thanks again.
  35. Re: I get this error: database table is locked

    Thanks again for your help.
    I am trying to use the above method that you provided.
    I just make a tiny change (use a form-level connection object).
    Here is my method:

    public int...
  36. Replies
    3
    Views
    924

    Re: Need help with recordsets in sqLite

    Thanks a lot for your help.

    The documentation that you provided clarifies a number of issues.
    For example, after reading your documentation, I now know what a DataTable and also a DataSet is and...
  37. Replies
    3
    Views
    924

    Need help with recordsets in sqLite

    I understand that in database programming, one of the major concepts is the idea of a recordset which is an object that holds a series of records.

    In sqLite, however, I have noticed that there is...
  38. Re: I get this error: database table is locked

    Thanks a lot for your help.

    Is that method GetInt32 in the above quote what you use to retrieve a single integer value?
    And do you recommend it?

    Thanks.
  39. Re: I get this error: database table is locked

    Thanks a lot for your help.

    Regarding my code, and that I am going to get rid of it and instead use the "using" statement, I need to understand one thing.
    You said:


    Well, I now know that...
  40. Re: I get this error: database table is locked

    Thanks a lot for your help.

    Basically, I understand that using the "using" statement is the best, and I am going to adopt that way of coding.
    However, before I abandon my current way of coding...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width