Search:

Type: Posts; User: Garrett!

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    584

    VS 2015 Slow Export of SQL View to Excel

    Hi, there. I have two questions. I'm using SQL Server as my database. I'm exporting a view into an Excel spreadsheet. I have two questions about it.

    #1. My export is working. But the only...
  2. Replies
    1
    Views
    489

    VS 2015 Help with e.Graphics.Drawing

    So there very well could be an easier and better way to do this, but this is what I have so far. What I'm trying to accomplish is print out the text in various labels, textboxes, and comboboxes onto...
  3. Replies
    2
    Views
    231

    Old Posts That Help

    This is probably a dumb question, but how do I let someone know that their post helped me? I was looking for some guidance about importing Excel into a Datagridview. I found a post by Tatarpro that...
  4. Replies
    2
    Views
    1,656

    VS 2015 Using a Parameter with DataGridView

    I have a question about using parameters with a datagridview. So I probably need to start out by describing what my project is. There is a miniatures game for Star Wars X-Wing. So basically you...
  5. VS 2015 Re: [RESOLVED] Loading TreeView from Access Database

    I'm using one query. Which I suppose as far as the code is concerned that's one table. This is one spot I know that my code itsn't perfect. I have to make sure that the query is sorted...
  6. VS 2015 Re: Loading TreeView from Access Database

    Well I was finally able to get this working. My code probably isn't the best example of coding. Since I'm just doing this to see if I can do it and because I think it's fun, it works for me.


    ...
  7. VS 2015 Re: Loading TreeView from Access Database

    Thanks for trying to give me a hand with this. I have been trying to change this around to fit my project. So this is what I have:



    Try

    Dim myNw As DataSet
    Dim...
  8. VS 2015 Re: Loading TreeView from Access Database

    Thank you for taking the time to assist me with this. I've been trying to get this going with some luck. It's still not 100% working. So first my code:


    Dim DataReader As...
  9. VS 2015 [RESOLVED] Loading TreeView from Access Database

    I'm trying to populate my TreeView based on a query in Access. That query had tree columns FactionName, ShipName, and PilotName. I would like like FactionName to be the parent in my TreeView,...
  10. Re: HOW TO LOOP THROUGH ROWS IN A TABLE in vb.net

    Thanks for the replies, guys. So it basically sounds like the answer I give my wife when she asks me why they do something they way the do in baseball. "Because they've always done it that way."
  11. Re: HOW TO LOOP THROUGH ROWS IN A TABLE in vb.net

    I'm not trying to derail this thread but if I could ask a question about this. I'm also not looking to start an argument either, it's something that I probably should know. For whatever reason I...
  12. Replies
    6
    Views
    870

    VS 2015 Re: Adding ComboBox to DataGrid

    Thanks for the code. It worked for me.
  13. Replies
    6
    Views
    870

    VS 2015 Re: Adding ComboBox to DataGrid

    Ah. That works much better. I don't know how I missed that event.
  14. Replies
    6
    Views
    870

    VS 2015 Re: Adding ComboBox to DataGrid

    A valid question. My end goal is depending on what item is selected in cboPilot1 load the datagrid with different data.

    I moved the code to the form load and saw the same results are before. ...
  15. Replies
    6
    Views
    870

    VS 2015 [RESOLVED] Adding ComboBox to DataGrid

    Hello. I'm trying to add a combobox to my datagrid. I would eventually like to then populate the combobox with data from my Access database, but I want to see if I can do that myself first. So for...
  16. VS 2015 Re: Make Some Buttons in Datagird Not Visible

    Ah. That makes sense.

    So I was playing around with the datagrid and I noticed that if I clicked on the column headers to sort, the buttons would repopulate. So what I did was created a...
  17. VS 2015 Re: Make Some Buttons in Datagird Not Visible

    Sweet! That worked perfectly! Can I ask how you learned/figured that out?
  18. VS 2015 [RESOLVED] Make Some Buttons in Datagird Not Visible

    I have a datagrid that I have added a button to a column. That works fine. The column that I added with the buttons is called "Add Astromech". The thing is I want some of the buttons to not be...
  19. Replies
    1
    Views
    1,088

    VS 2015 SQL View to XML Document

    Hello. I'm trying to create an XML document based on a SQL view. I have it sort of working in two ways, but not entirely the way I want. First, this is the way the XML document needs to look for...
  20. VS 2015 Re: display Testbox into messagebox

    You just need to concatenate your text and variable holding the text box.


    Dim RESULT As Integer = MessageBox.Show("The dollar amount is ==> " & offer1,"Message Box Title" ,...
  21. Re: How to assign shortcut keys to buttons?

    I guess I'm not understanding what you're tying to do.
  22. Re: How to assign shortcut keys to buttons?

    All you need to do is put the ampersand in front of the letter you want to be the shortcut. So if you want the save button to have a shortcut of s put &Save in the text and it will show Save.
  23. Thread: Microsoft MVP

    by Garrett!
    Replies
    41
    Views
    2,407

    Microsoft MVP

    I feel like this is one of those things I should probably know, but for whatever reason I don't. What does it take to become a Microsoft MVP? Is a test you take?
  24. Replies
    6
    Views
    948

    Re: New to programing Help

    I've seen JMC point this out on other posts and I think it's really good advise, especially since your instructor couldn't help figure out what was wrong with your code. There is something called...
  25. Replies
    4
    Views
    1,043

    VS 2015 Re: Parameter with a Space

    Well, put me down as being stupid. I thought I had double checked my data, but I did not have any companies with a space in the name. That's why I kept not getting any results. Sorry for the post.
  26. Replies
    4
    Views
    1,043

    VS 2015 [RESOLVED] Parameter with a Space

    I have a datagrid that I am trying to populate based on a SQL view. My code to do that is:


    Private Sub StockReportToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles...
  27. Replies
    3
    Views
    936

    VS 2015 Re: Logging Errors into SQL

    Thanks, guys. That did the trick.
  28. Replies
    3
    Views
    936

    VS 2015 [RESOLVED] Logging Errors into SQL

    So what I'm trying to do is log any errors my users encounter into an SQL table. I followed this site's example:
    ...
  29. VS 2013 Re: How to open dtpPicker1 to select the date, when the txtDate.Text selected?

    Not to hijack this thread, but that's a good idea. If I can just ask, can you set a DTP to null? I mean if I have a DTP and sometimes I want a date in it and sometimes I don't. I have a button...
  30. VS 2013 Re: How to open dtpPicker1 to select the date, when the txtDate.Text selected?

    This was something I struggled with too. I wanted to insert null dates into my SQL database and couldn't for the life of me figure out how to do that with a DateTimePicker. It would always insert...
  31. VS 2015 Re: Calculate two fields in a datagrid

    I was able figure it out. For my using previous field calculation I had to to use the For/Next loop.

    Thank you both for the help.
  32. VS 2015 Re: Calculate two fields in a datagrid

    Thanks! That worked. I did have to change .Expression = "ClearQty + ShipQty" to be .Expression = "IsNull(ClearQty, 0) + IsNull(ShipQty, 0)". But that was in the article you provided me. That was...
  33. VS 2015 [RESOLVED] Calculate two fields in a datagrid

    I must be missing something here. All I'm trying to do is add two fields in my datagrid and put that into a new column that I create. It sounds like it should be really easy, so I have to be doing...
  34. Replies
    3
    Views
    714

    Re: how to show this code in vb.net form

    I would use the WebBrowser from the Toolbox. You could use this to specify the webpage:


    WebBrowerName.Navigate("http://www.oil-price.net/dashboard.php?lang=en#TABLE2")
  35. VS 2015 Re: Populate datagrid with a stored procedure with parameters

    Well that's good to know. I was wondering the other day about that but I had assumed that's just the way it is. Using a datatable makes more sense. Well I guess I was using a Dataset as if it were...
  36. VS 2015 Re: Populate datagrid with a stored procedure with parameters

    I see. So is that why in my old, incorrect code I had:


    dgvDailyReport.DataSource = dsOptions.Tables(0)

    That's when I was using a DataSet. So if I had let's say 10 tables also in the DataSet...
  37. VS 2015 Re: Populate datagrid with a stored procedure with parameters

    Awesome! Thanks!

    I know this isn't the same topic as my original post, and I feel like this is a dumb question and I should know this. But what's the difference between as DataSet and...
  38. VS 2015 Re: Populate datagrid with a stored procedure with parameters

    If I use commandOptions.Parameters.AddWithValue("@DateEntered", txtDateEntered.Text) then I make sqlOptions = "dbo.DailyTotals_ssp"
  39. VS 2015 [RESOLVED] Populate datagrid with a stored procedure with parameters

    Hi. I'm trying to populate my data grid from a stored procedure in SQL Server. My stored procedure has a parameter. I have it working except I don't think I'm actually using parameters in my VB...
  40. Replies
    4
    Views
    1,154

    VS 2015 Filter Datagrid with Multiple ComboBoxes

    So I have a datagrid that I want to filter with multiple comboboxes. My datagrid lists all our dealers. My comboboxes would list things like Dealer City, Dealer State, Primary Plant, and some other...
Results 1 to 40 of 113
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width