Search:
Type: Posts; User: Garrett!
Search:
Search took 0.01 seconds.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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.
...
-
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...
-
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...
-
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,...
-
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."
-
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...
-
Thanks for the code. It worked for me.
-
Ah. That works much better. I don't know how I missed that event.
-
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. ...
-
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...
-
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...
-
Sweet! That worked perfectly! Can I ask how you learned/figured that out?
-
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...
-
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...
-
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" ,...
-
I guess I'm not understanding what you're tying to do.
-
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.
-
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?
-
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...
-
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.
-
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...
-
Thanks, guys. That did the trick.
-
So what I'm trying to do is log any errors my users encounter into an SQL table. I followed this site's example:
...
-
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...
-
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...
-
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.
-
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...
-
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...
-
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")
-
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...
-
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...
-
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...
-
If I use commandOptions.Parameters.AddWithValue("@DateEntered", txtDateEntered.Text) then I make sqlOptions = "dbo.DailyTotals_ssp"
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|