Search Results - VBForums

Search:

Type: Posts; User: geek648

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    3,573

    Re: Open Source RDL: My-FyiReporting

    Quick Update
    The project is still going strong, and has been renamed Majorsilence Reporting although My-FyiReporting lives on in the URLs involved!...
  2. Replies
    3
    Views
    208

    Re: open a new form from form 1

    Simplest way is to have a public variable in the chqdetail form, and set it (oForm.YourVar=whatever) to whatever you require before you show the form.
  3. Replies
    3
    Views
    208

    Re: open a new form from form 1

    For starters,


    Dim oForm As chedetail
    oForm = New chedetail()
    oForm.Show()
    oForm = Nothing

    There are various ways to pass data into the new form.
  4. Re: LINQ : combine two selects like a SQL CTE?

    Ah, brilliant, many thanks!
    What a great way to play with data, impressive stuff :)

    The Wrong Way

    At first I couldn't get this to work

    Dim tst = From row As DataGridViewRow In...
  5. [RESOLVED] LINQ : combine two selects like a SQL CTE?

    Quick Question, I hope, is there a way to Select from a Select in LINQ?
    Combine two operations in one, rather than one step following another?
    Just so I can read data from a DGV, but name the...
  6. Thread: Sql

    by geek648
    Replies
    9
    Views
    894

    Re: Sql

    Is it someone else's database, or your own (as suggested by "tbl1964 is sitting in design mode grid unused") ... so it's not too late to re-organise it?
  7. Replies
    10
    Views
    401

    VS 2008 Re: I don't know what is available!

    That's the problem with programming, it's like "the blind leading the blind". There's often an elegant and sophisticated way to do something, but unless someone tells you about it, or you read it...
  8. VS 2010 Re: How to define If string contains something.

    INK or LNK ?
  9. Thread: Sql

    by geek648
    Replies
    9
    Views
    894

    Re: Sql

    The general idea of a relational database is to NOT have duplicate data in different tables. You put it in one place, and join to it as required :)
  10. Thread: Sql

    by geek648
    Replies
    9
    Views
    894

    Re: Sql

    Are tblEPData2 and tbl1964 joined by particular fields? If so, add this in your WHERE clause : AND (tblEPData2.field1 = tbl1964.field2)

    And please explain what you mean by "need to output another...
  11. Replies
    10
    Views
    501

    Re: i have error saving in database

    And whatever you do, beware of SQL Injection. The user could type in all sorts of nasty things in the text boxes that would end up as SQL commands. Use parameters instead.
  12. Thread: Backup of SQl

    by geek648
    Replies
    15
    Views
    1,357

    Re: Backup of SQl

    There's "ideal and proper", and then there's "what's good enough and what he wants to do for his own reasons" :)
  13. Thread: Backup of SQl

    by geek648
    Replies
    15
    Views
    1,357

    Re: Backup of SQl

    You could shell out to a command line to export the required tables, using sqlcmd or bcp -
    http://stackoverflow.com/questions/425379/how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd
  14. Re: Can't change the contents of a table in SQL Server2005

    http://geekswithblogs.net/allensb/archive/2006/07/27/86484.aspx
    http://social.msdn.microsoft.com/Forums/en-AU/sqlexpress/thread/33de3d74-03df-49c1-9d16-d94aa0dac9b7

    Just google for "either do not...
  15. Thread: HELP with SQL

    by geek648
    Replies
    4
    Views
    316

    Re: HELP with SQL

    What flavour of SQL is it?

    This might do it...
    select Qty, Desc, Cast(Qty as varchar)+Desc as Combine from...
  16. Replies
    7
    Views
    539

    Re: Usb flash drive letter problem

    Please consider how easy that would be to spread all manner of viruses and other infections :)
  17. Replies
    12
    Views
    1,338

    Re: PHP Script that connects with MS-SQL Database

    SqlSrv connects to any SQL Server that can be reached.. there are some nuggets of helpfulness here -
    http://go4answers.webhost4life.com/Example/connecting-remote-sql-server-host-46406.aspx
  18. Replies
    12
    Views
    1,338

    Re: PHP Script that connects with MS-SQL Database

    Try sqlsrv_connect using SQLSrv. Goggle for : mssql_connect sqlsrv_connect

    “mssql was dropped from PHP 5.3 distribution. Since the “php_mssql.dll” is no longer deployed with PHP 5.3, all calls to...
  19. Replies
    8
    Views
    593

    Re: Search data from a Gridview or Dataset.

    Well at least I can serve as an example of how not to do it, LOL.
    I'll get my coat.

    Thanks for educating me :)
  20. Replies
    8
    Views
    593

    Re: Search data from a Gridview or Dataset.

    You could have another datatable and when the Search Text changes, copy the matching rows from the original to the shown datatable (or just unhook the DGV from the original dt and manually fill it...
  21. Replies
    8
    Views
    593

    Re: Search data from a Gridview or Dataset.

    You can loop around the DGV contents (or the original dataset)...


    For Each row As DataGridViewRow In DataGridView1.Rows
    MessageBox.Show(row.Cells(0).Value.ToString)
    ' or...
  22. VS 2010 Re: Inner Join two tables and getting their values

    (dupe - can't delete)
    (technical error made me re-post the posting, and surprise surprise it had already posted despite a "database error")
  23. VS 2010 Re: Inner Join two tables and getting their values

    Try to break down your problems into simple steps, verifying along the way what works and what doesn't, then you'll find where the problem lies.
    In this case, try a simple sql query and see if that...
  24. Replies
    15
    Views
    14,729

    Re: What IS Assembly??

    I think the OP may have meant a .net assembly :)
    http://en.wikipedia.org/wiki/Assembly_(CLI)
  25. Re: Could you tell me what kind of database is this?

    Aha, having spelt RMKF right in Google this time...
    http://stackoverflow.com/questions/812867/free-reader-for-rmkf-cobol-database-files
  26. Re: Could you tell me what kind of database is this?

    The RAR contains a single file "RECAXACU" (no extension) of 106MB.
    Notepad++ opened it (a lot more quickly than Win32Pad. It blew up standard Notepad, LOL) and it's all binary bric-a-brac with...
  27. Replies
    8
    Views
    327

    Re: Framework versions question

    Thanks, it's all very intriguing and puzzling. I thought I had a grasp on it, but now I'm very confused!
    I'm keen to see what anyone else could contribute...
    Cheers
  28. Replies
    8
    Views
    327

    Re: Framework versions question

    Thanks, anyone else care to chip in with more technical detail?
    Cheers
  29. Replies
    8
    Views
    327

    Framework versions question

    I assume that backwards compatibility is built in? i.e. a .DLL compiled for v3.5 should be ok to use with a v4 project?

    I ask because I'm about to play with some Open Source widget and their...
  30. Re: Any way to register VB Express 2010 without internet?

    Thanks, I dialled in my key and it seems to have worked, it doesn't say Evaluation any more, and trying the registration option again it says it's already registered. That's about as hopeful as it...
  31. Any way to register VB Express 2010 without internet?

    I've installed via an ISO downloaded from MS via a link I found on a blog,
    I used my netbook and copied it via USB stick onto my desktop PC which has no internet connection.
    It's working but it...
  32. Re: Check the value of a Variable then take some action

    Anyone that interested in hacking won't be put off by anything you can do :)

    Write the registration stuff in another language that compiles to a standalone .exe you can shell out to (the free...
  33. Replies
    4
    Views
    345

    Re: Quick OOP question - object lifetime

    Thanks, it all seems to be behaving itself. Just 4 lines of code (including the End Using) gets me a SQL query result loaded into a datagridview, so I'm happy with my first real class :)

    My query...
  34. Replies
    4
    Views
    345

    Quick OOP question - object lifetime

    I've written a SQL Query class so that I can get query results in as few lines as possible throughout my application.
    My Query class has a DataTable property (called Results) so I can access the...
  35. Replies
    5
    Views
    3,573

    Re: Open Source RDL: My-FyiReporting

    There have been updates to the Wiki, hopefully that makes it even more simple for newcomers.
    https://github.com/majorsilence/My-FyiReporting/wiki

    Guide to the New Report wizard...
  36. Re: DataGridView loses data I added to an added column!

    Got it working, thanks.

    Example: Add a column to a dataset read from XML, and check all rows for a bad field and set the new "Errors" field :


    oDSet = New System.Data.DataSet
    ...
  37. Re: DataGridView loses data I added to an added column!

    Thanks. Unfortunately the XML isn't mine, it's an export from some other system - hence I'll need to check carefully each row contains valid values before doing anything with it - and alert the user...
  38. Re: DataGridView loses data I added to an added column!

    Aha, sounds like a plan :)
    Thanks!
  39. Re: DataGridView loses data I added to an added column!

    Thanks - so I have to manually copy the XML dataset to the DataGridView, so it's unbound - set up the columns by hand, etc - and all will be well....?
    :)
  40. DataGridView loses data I added to an added column!

    Am I being dumb? I read a XML file into a DataGridView...


    Dim oDSet = New System.Data.DataSet
    oDSet.ReadXml(strFilePath)
    DataGridView1.DataSource = oDSet.Tables(0)

    The XML file contents...
Results 1 to 40 of 75
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.