Re: SQL and Progress Updates - C# Discussion Boards

Expert Coming20-May-07 20:51

Expert Coming

20-May-07 20:51

Use a delegate and add it to the event for your object.

TextBox txt = new TextBox();<br />
txt.VisibleChanged += new EventHandler(TextBox_VisibilityChanged);<br />
<br />
public void TextBox_VisibilityChanged(object sender, EventArgs e)<br />
{<br />
   //Do something<br />
}

The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.

jason_mf20-May-07 21:02

jason_mf

20-May-07 21:02

My Class :
public class MyClass
{
private int stauts =0;

public int Stauts
{
get{return status;}
set{status = value;}
}
}

How write a event associate "Stauts" when "Stauts" changed.
thanks.

PandemoniumPasha20-May-07 21:32

PandemoniumPasha

20-May-07 21:32

hi,
you could try the following:

public class MyClass
{
private int stauts =0;
public delegate void MyEventHandler(object obj);
public event MyEventHandler OnStatusChange;

public int Stauts
{
get{return status;}
set
{
status = value;
OnStatusChange(this);
}
}
}

for more information read http://www.codeproject.com/csharp/eventarguments.asp[^]

regards
Smile | :)

jason_mf21-May-07 19:55

jason_mf

21-May-07 19:55

why "MyEventHandler" does not have "EventArgs" parameter?

blackjack215020-May-07 21:32

20-May-07 21:32

Call the event hanlder inside the body of the set{ } statement.

Re: SQL and Progress Updates

jason_mf20-May-07 22:15

jason_mf

20-May-07 22:15

the declared sentence: "public event StatusHandler statusChanged",
where should i write it?
thanks.

SQL and Progress Updates

Expert Coming20-May-07 20:44

Expert Coming

20-May-07 20:44

I have a very basic upload/download application. The app uses a select statement to download and a insert statement to upload. The reason I include those is because I am not sure how to get a progress report from them, ie completion percentage. I may be uploading upward of 100megs and don't want the user to just sit there waiting. I have tested a 5meg file and it takes about 3 minutes to upload and does so correctly, but the user has no idea what is going on.

How do I get progress of the SQL read/write so I can update my progress bar?

Thanks in advance!

The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.

Dave Herren21-May-07 3:41

Dave Herren

21-May-07 3:41

I am not aware of a way to do this, but it has been my experience that as long as users see the progress bar moving they know the application is not hanging and feel some better. So estimating the % complete based on seconds elapse divided by (average megs per second * megs) should be a reasonable solution (I swear microsoft often does things like this). Just make sure that the last 5% of the progress bar moves much more slowly and stops at 99% so that you don't reach 100% before it's done.

topcoderjax

delete record from Datagrid view which check box are checked

kushak_manoj20-May-07 20:08

kushak_manoj

20-May-07 20:08

:(hi all,
in my window form i m bindng one datagrid with check boxes now i wnat to dele those record which are checked how i can do this in window C#

i m also bind the image of the member into datagirdview(images are in the DB)

how i can perform this

regard Smile | :)

Re: delete record from Datagrid view which check box are checked

Manoj Kumar Rai20-May-07 21:45

Manoj Kumar Rai

20-May-07 21:45

Hi,

Deleting records:
You can follow the following steps to get the "checked" records deleted.
1) First get the records marked "checked"
2) Use the dataGridView1.Rows.Remove to remove the data from the Grid.
3) Use the SqlCommand to get the records deleted from the database.

Binding Images:
I have bound a image column from the access database with the "datagrid" automatically from wizard. Please note that the type of the column in data table is Ole Object.

Manoj
Never Give up

Regular Expression Match Grouping

nasambur20-May-07 19:56

nasambur

20-May-07 19:56

hi,

i'm trying to parse C# file and want to change the code..
i have a class with following lines of code, assume

class Test
{
  public void method()
  {
    Foo.Bar = "Demo";
  }
}

i want to extract only the property name and its value..

i have a pattern like this.. which extract the value only, but i need the property name too..

<code>
"\\Foo.[^;]*(=\\s*\")(?<val>([^\"]*))";
</code>

plz give me a pattern which extract the both.

regards,
nas

DAAB- SQLHelper ExecuteDataSet vs Fill Method

K.P.Kannan20-May-07 18:29

K.P.Kannan

20-May-07 18:29

We are using SQLDbAccess.dll provided by Microsoft. There are two methods are filling the Dataset. Fill method and also ExecuteDataSet. Which one will be better? Thanks

Re: DAAB- SQLHelper ExecuteDataSet vs Fill Method

Tarakeshwar Reddy22-May-07 2:55

Tarakeshwar Reddy

22-May-07 2:55

K.P.Kannan wrote:
Fill method and also ExecuteDataSet

If your taking about DataAdapter.Fill then it is better to use the ExecuteDataset method as the SQLDBAccess.dll would look after opening/closing connections

Navigate the web

brsecu20-May-07 16:26

brsecu

20-May-07 16:26

I've been coding for quite sometime but never with web. I just need someone to help me get started.

I'm trying to automatically push a button on a web page without a manual mouse click(its written in html). Where do I start? Can I even do it with C# or should I use another language. I was trying to use the standard webcontrol but it seems limited. Can anyone help? Thank you very much.

blackjack215020-May-07 19:10

20-May-07 19:10

Hi.
It can be done quite easily with the webbrowser control. If this is what you would like to use I could guide you. Please reply if interested.

brsecu21-May-07 1:15

brsecu

21-May-07 1:15

I am very interested. Very very interested. Maybe a small code snippet. Thanks again.

blackjack215021-May-07 21:34

21-May-07 21:34

Ok, here it is.
I hope it's not too late. I was quite busy yesterday afternoon and I didn't have time to check the codeproject forum.

So, a simple example of how to do an automatic search on google:

Place a WebBrowser control on your form.
Use it's navigate method to load the google page:

MyWebBrowser.Navigate("http://www.google.com");

In order to access the controls on the webpage and use them, you need to know what their names are from the html source of the page. If you take a look at google's source you'll see all the controls, and among them these two:

and

The first one is the text box where you type the text to search and the second is the search button.

So, all you need to do is fill the text box and after that simulate clicking the "Google Search" button. Like this:

HtmlElement searchBox = MyWebBrowser.Document.All["q"];
searchBox.InnerText = "code project";
HtmlElement btnSearch = MyWebBrowser.Document.All["btnG"];
btnSearch.InvokeMember("click");

Hope this helps.

Have a nice day!

PS: There's a very quick and easy way to find the name of the controls you need from a web page. It's called Firebug. It's a plug-in for Firefox. Just use it. I'm sure you'll find it great, too.

brsecu22-May-07 10:52

brsecu

22-May-07 10:52

Everything you said worked to perfection. Thanks for the help. Now that I have the basics down I am able to understand how the control works. You the man!

blackjack215022-May-07 11:31

22-May-07 11:31

I'm glad I could help.
Good luck and happy coding!

Little_Dice27-May-07 21:46

Little_Dice

27-May-07 21:46

So how would you go about selecting certain boxes. Like username and password, and then click a button.

Login
Username:
Password:

blackjack215027-May-07 22:34

Re: Navigate the web [modified]

27-May-07 22:34

Well, I guess the same way I filled the search box on google's page.
Have you tried setting the InnerText property?
Maybe you could give me the link to the page you want to interact with and I'll try myself.

Little_Dice28-May-07 11:32

Little_Dice

28-May-07 11:32

Alright I finnally got everything working except the button. To my knowledge i don't see the button in the source code. It just says

Did you get my email?

-- modified at 2:20 Tuesday 29th May, 2007

blackjack215028-May-07 22:16

28-May-07 22:16

I didn't check my email yesterday. I'll read it in the afternoon(about 4-5 hours from now), as I'm not allowed to use my private email at work.

Did you use Firebug to identify the web controls? If not, please do so. You'll see why.