|
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
|
|
|
|
|
it really should say
if() expects a boolean and "btnPause.Content" isn't a boolean nor convertible to one
and it could add
there is an assignment in your expression; did you intend to test for equality? if so use ==
Why can't error messages be very specific, after all the parser is specific when it checks things.
harold aptroot wrote: I did not vote "bad answer"
Neither did I, although I didn't like it much; the user should not change his habits just because the compiler lacks proper error reporting. The suggestion may be OK for C/C++, but doesn't help much for C# code.
|
|
|
|
|
suitably chastised ...
It's time for a new signature.
|
|
|
|
|
|
I thought it was a good idea, though I could never do that myself.
|
|
|
|
|
Here's a radical idea: why not throw out the '==' and '===' confusion and make the compiler use the single '=' as either an assignment or a comparative operator depending on the context, like VB does?
Oh yeah, because we don't want C# to be like VB with all the stigma associated with such simpleton languages. Sorry, I forgot.
|
|
|
|