|
Have you considered using autocomplete or whatever it is?
|
|
|
|
|
Where are the customers list stored ?
I know nothing , I know nothing ...
|
|
|
|
|
Why does it matter?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
If they're stored on a piece of paper its going to be real difficult to write the ODBC driver 
|
|
|
|
|
Hello all,
I am a bit perplexed and maybe one of you can point me in the right direction.
I have a windows form containing a DataGridView that has data imported into it from Excel and a combobox representing a job number. A user will make changes to the data in the DataGridView and then I want to post this entire DataGridView plus the job number to a MySQL table.
I havne't found any information about how to post the unbound DataGridView to the MySQL table with one extra column of data (job number).
What I would like to know is the proper steps to accomplish this task.
I am using VS2008 and the MySQL Connector/NET v6.2.3
Thanks
Jeff
|
|
|
|
|
Assuming I have the data in a DataTable, I cobble up a (parameterized) INSERT statement based on the table name and column names then iterate through the Rows setting the parameter Values and calling ExecuteNonQuery.
I have a routine that does it in one of my data access classes.
|
|
|
|
|
Thanks for the response.
That sounds simple enough, except that I don't know how to access each of the data rows when none are selected. All of the literature that I am looking at assumes that data in the datagridview was taken out of a database table and then updating is a snap. but... it seems strange to me that using a datagridview for data entry should be so hard. (I think I am overlooking something, but I don't know what it could be.)
Unfortunately, I am very confused and don't really know where to proceed from here.
Jeff
|
|
|
|
|
As Piebald said:
foreach(DataGridViewRow row in myDGV) {
.. stuff column values in an INSERT statement
.. execute it
}
|
|
|
|
|
Thank You!
After some trial and error with syntax and the imported column names from excel it worked as advertised.
You saved me a ton of time.
Jeff
|
|
|
|
|
you're welcome
|
|
|
|
|
delete
modified 2-Apr-21 5:20am.
|
|
|
|
|
I don't understand your question. Do you want your program to navigate the browser to a specific url?
/ravi
|
|
|
|
|
Message Closed
modified 2-Apr-21 5:20am.
|
|
|
|
|
You could browse IE's url history or write a browser helper object that could send the url to your Windows Forms app. See these articles for ideas:/ravi
|
|
|
|
|
textbox1.Text = webBrowser1.Url;
I know nothing , I know nothing ...
|
|
|
|
|
Hi,
you could read the content of the address bar of some browsers. In C# that would take some P/Invoke code to call FindWindow and GetWindowText; as the window belongs to another process, you would also need to allocate and access memory in that other process. You can find some of the basic techniques in my TrayIconBuster article (LP_Process class).
Doing it this way would have several limitations:
1. the solution is slightly different for each specific web browser, as the logical location of the address bar will vary.
2. the address bar does not always represent the current page; e.g. when frames are involved, the bar will show the URL of the frames page, not the contained page(s).
The alternative is to create your own browser and have the required functionality built-in. A good starting point would be the WebBrowser Control. Of course, people could still use another browser, but so they can in the former approach (you can't prevent them from downloading and installing FireFox, Safari, Chrome, etc).
|
|
|
|
|
Isn't this sort of info somewhere in the browser log, history or something, maybe you can use that instead of scraping the browser window.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Message Closed
modified 2-Apr-21 5:16am.
|
|
|
|
|
I've the same problem.
I was searching a long time and the best solution I was found is DllImport(user32.dll)
You should use some methods like FindWindow, FindWindowEx and SendMessage.
You must first find main class of IE window, e.g. use WinSpy++.
Then you go from class to class, from parent to child (IEFrame -> WorkerW -> ReBarWindow32 -> Address Band Root -> edit) First use FindWindow, next FindWindowEx.
In class named "edit" there is a url.
Use SendMessage, WM_GETTEXT and e.g. StringBuilder class to get the url.
But it only works with IE
How do this in Opera or Chrome? Any idea?
|
|
|
|
|
is there a possibility to work with a crystal report without using dataset???
because in my project I'm working with dictionaries
thank you
|
|
|
|
|
tek 2009 wrote: without using dataset
That's the only way I've done it.
|
|
|
|
|
I keep getting the below error message when I try and run my code.
Error 3 Cannot implicitly convert type 'object' to 'bool'. An explicit conversion exists (are you missing a cast?)
When I try run the below code:
private void Pause_Click(object sender, RoutedEventArgs e)
{
if (btnPause.Content = "Pause") <<<<
|
|
|
|
|
==
|
|
|
|
|
Instead of coding:
if (btnPause.Content == "Pause")
try writing it this way round
if ("Pause" == btnPause.Content)
then when you inadvertently miss one of the = signs the compiler will give you a much more useful message.
It's time for a new signature.
|
|
|
|
|
Richard MacCutchan wrote: the compiler will give you a much more useful message.
I don't know about that, you'd get "The left-hand side of an assignment must be a variable, property or indexer", which is true of course but it tells you to fix the wrong thing, it's saying that you should change the LHS into a variable. It's also saying that it's an assignment, but that just adds to the confusion because "there is no assignment, so the error makes no sense". OTOH, the "Cannot implicitly convert [type] to bool" is entirely clear, and since it's pointing to an expression in an if it tells you "you stuck something into an if that is not a bool" which is exactly what the problem is.
Or maybe I'm just used to that kind of error..
edit: I did not vote "bad answer" by the way, so don't get mad at me please
modified on Saturday, August 7, 2010 10:34 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
