Re: how to copy database ? - C# Discussion Boards

Re: Index error...

Support12318-Jul-07 23:40

Support123

18-Jul-07 23:40

yes all items have subitems Smile | :)

Thanks...

i thought that there are two events taking place in the SelectedIndexChange event just after i posted the message...

Thank you for your time Smile | :)

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Re: Index error...

Colin Angus Mackay18-Jul-07 23:30

Colin Angus Mackay

18-Jul-07 23:30

Support123 wrote:
Convert.ToString(lvTestA.SelectedItems[0].SubItems[0].Text.Trim())

See all that - I'd separate that out into lots of lines as it makes it much easier to debug. This is the only code that appears to use indexes so I'm guessing it is here that the problem lies.

selectedItems = lvTestA.SelectedItems;
firstItem = selectedItems[0];
subItems = firstItem.SubItems;
firstSubItem = subItems[0];
string theText = firstSubItem.Text;
string theTrimmedText = theText.Trim();
string convertedText = Convert.ToString(theTrimmedText);
TestD.LoadData(2,convertedText);

NOTE: I've left out the class names for most of the above - you'll have to fill that in.

The above code can now be much more easily debugged and stepped through. You can then see exactly which line has the problem - And you can watch the values so you can see exactly what it is doing.

This should help you narrow down your problem.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

My website

Re: Index error...

Thaer Hamael19-Jul-07 0:04

Thaer Hamael

19-Jul-07 0:04

Hi,

I guess there are two changed events, one when the original selection gets unselected,
the second one when the newly clicked item gets selected.
Rose | [Rose]

Thaer

Re: Index error...

Martin#19-Jul-07 0:11

Martin#

19-Jul-07 0:11

Please, tell me that Luc and you are twins and you allways think the same.
Otherwise it would look like you copied Luc's suggestion![^]

Hmm, just compared you two Birthday dates and I have to say it's a big gap in between.
Sorry Luc, don't want to say that you are soo old! Wink | ;)

All the best,

Martin

Re: Index error...

Luc Pattyn19-Jul-07 0:37

Luc Pattyn

19-Jul-07 0:37

Then why did you ? D'Oh! | :doh:

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Index error...

Martin#19-Jul-07 0:55

Martin#

19-Jul-07 0:55

Hmmmm,

I just wanted to show the community how well experienced you are! Smile | :)

All the best,

Martin

how to copy database ?

help as an alias18-Jul-07 22:55

help as an alias

18-Jul-07 22:55

I m trying to make an application which is connected with more than one database and its depend on user that user may have any name so I create a database name is blank in bin --> debug folder when user make a new colony database. It copy from the existing database which have already same tables query etc.
plz give me coding.
plz help me and thakx in advance

Nikesh Yadav,
CSS infotech,
Gurgaon,
Haryana(India).

Re: how to copy database ?

Colin Angus Mackay18-Jul-07 23:21

Colin Angus Mackay

18-Jul-07 23:21

Er nikesh yadav wrote:
plz give me coding

The code will be highly dependent on the database that you use.

If it is Access then a simple file copy might suffice

If it is SQL Server the two choices I'd look at would be to restore a blank database to the location that you want, or to have a set of scripts to create a brand new database

Other database system may offer similar choices, they may offer something completely different.

Re: how to copy database ?

help as an alias18-Jul-07 23:35

help as an alias

18-Jul-07 23:35

i m using Access

Re: how to copy database ?

Colin Angus Mackay18-Jul-07 23:49

Colin Angus Mackay

18-Jul-07 23:49

Then you probably just want to copy the file. See the FileInfo class.

See: MSDN - FileInfo[^]

Threading concept..

Ron.S18-Jul-07 22:40

Ron.S

18-Jul-07 22:40

Hello All,

I am trying to bind the listbox to a column of the datatable. If i try directly on the click of the button then it will display the data. but, if i am trying to do this by creating a thread for this process it is doing nothing, no error is shown. Please help me.

Thanks in advance.

Bharath.S Ron

Re: Threading concept..

Eduard Keilholz18-Jul-07 22:47

Eduard Keilholz

18-Jul-07 22:47

I think an exception IS thrown however you catch it on some place. You cannot change GUI related things on a diffrent thread.

Try creating a delegate and call the delegate from your diffrent thread using Invoke()

for example :

<br />
private delegate void doBindListbox();<br />
private void BindListbox()<br />
{<br />
// Code to bind listbox<br />
}<br />

and call the delegate from your diffrent thread like so :

<br />
this.Invoke(new doBindListbox(BindListbox));<br />

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: Threading concept..

Ron.S18-Jul-07 22:58

Ron.S

18-Jul-07 22:58

Hi,

Is this the correct way?
trd = new Thread(new ThreadStart(this.Invoke(new delegateloaddata(loaddata))));

delegateloaddata = delegate.
loaddata = is the method which has to be called through thread

Bharath.S Ron

Re: Threading concept..

Eduard Keilholz19-Jul-07 0:57

Eduard Keilholz

19-Jul-07 0:57

No, it's not...

<br />
private void StartMyThread()<br />
{<br />
ThreadStart ts = new ThreadStart(InvokeBinding);<br />
Thread th = new Thread(ts);<br />
th.Start();<br />
}<br />
<br />
private void InvokeBinding()<br />
{<br />
this.Invoke(new doBindListbox(BindListbox));<br />
}<br />

See the example in my previous post....

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: Threading concept..

Ron.S19-Jul-07 2:41

Ron.S

19-Jul-07 2:41

Thank you.

I tried that method it is working and loading the data into the listbox but, it is not working as a thread. I cannot stop it in between.

Bharath.S Ron

Re: Threading concept..

Eduard Keilholz19-Jul-07 3:16

Eduard Keilholz

19-Jul-07 3:16

What do you mean with :

Bharath.S.Ron wrote:
I cannot stop it in between.

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: Threading concept..

Ron.S19-Jul-07 19:39

Ron.S

19-Jul-07 19:39

Hi,

AS i am trying to impliment that as a thread , i want to stop it in between as well.
stop in the sense, the form should not freeze while performing that function, i should be able to click other buttons as well while this is being doing its job.

Bharath.S Ron

Re: Threading concept..

Ron.S19-Jul-07 20:30

Ron.S

19-Jul-07 20:30

this is the code which i am using.

public void loaddata()
{
try
{
conn = new SqlConnection("Data Source=local; Initial Catalog=Northwind; User ID=sa; Password=; Persist Security Info =True;");
adpt = new SqlDataAdapter("Select * from Categories", conn);
ds = new DataSet();
adpt.Fill(ds);
listBox1.DataSource = ds.Tables[0];
//trd
listBox1.DisplayMember = "CategoryName";
Thread.Sleep(1000);
//trd.Start();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

on click of the button i am calling that thread.

private void btnStart_Click(object sender, EventArgs e)
{
try
{
// this is wokring

ThreadStart myThreadDelegate = new ThreadStart(loaddata);
trd = new Thread(myThreadDelegate);
trd.Start();
trd.IsBackground = true;
// till here
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}

}

this below code is to stop the thread.
private void btnStop_Click(object sender, EventArgs e)
{
//Thread trd = new Thread(new ThreadStart(this.loaddata));
//trd.Abort();
try
{
if ((trd.ThreadState == ThreadState.Running )|| (trd.ThreadState==ThreadState.Background))
{
trd.Abort();
}

}
catch (ThreadStateException Ex)
{
MessageBox.Show(Ex.ToString(), "Exception",
MessageBoxButtons.OK, MessageBoxIcon.Error,
MessageBoxDefaultButton.Button1);
}
}

please help me..

Bharath.S Ron

Custom Tab Control

T.EDY18-Jul-07 22:39

T.EDY

18-Jul-07 22:39

Hi,

I Have Some Problem how can we bind data into tab control..for example:

i have a table name Working, in first column i have field name "Id" for primary key and i make it autoincrement, and in the second column i have field name Status..what makes me confuse if on field status have 2 value :"typing, printing"..how can i make tab control have 2 tabPages name "typing" and "printing"

Please Help me coz i'm new in C#...

Thanks and Regard,

TCim

Visual studio error on load

Russell Jones18-Jul-07 22:29

Russell Jones

18-Jul-07 22:29

I'm getting the following error:

Project FooBar could not be opened because the Microsoft Visual C# .NET compiler could not be created.

I reinstalled VS as recommended by the next line of the error message and it all worked fine.

This morning i open VS and guess what, I get the message again. Reinstalling took me hours yesterday and reduced my PC to a uselesss whirring mess for most of that time. It did however fix the problem for the last few hours of the day.

The suggestions i see on the web are that this problem is due to having a pathname over 260 characters in the project but i've moved my project folder to c and it stil doesn't open.

Has anyone else suffered this problem and found a fix?

Thanks

Russell

Re: Visual studio error on load

originSH18-Jul-07 22:50

originSH

18-Jul-07 22:50

I assume you've googled and worked through the results?

http://www.google.co.uk/search?hl=en&q=could+not+be+opened+because+the+Microsoft+Visual+C%23+.NET+compiler+could+not+be+created.&meta=[^]

Re: Visual studio error on load

Russell Jones18-Jul-07 22:57

Russell Jones

18-Jul-07 22:57

yeah,

strangely One of the guys found a solution suggested by ReSharper. I installed Resharper thinking it might tell me what was wrong. When I opened the project my cursor changed to a biohazard symbol with a green arrow and magically my project now works.

Who knows what was up with it, I hope I'm not back here tomorrow having suffered the same problem when i turn my PC on in the morning.

Russell

Re: Visual studio error on load

originSH18-Jul-07 23:56

originSH

18-Jul-07 23:56

wow! it might be worth going over to the resharper forums and asking if they've done a fix for the issue Smile | :)

handle Printer

Chatura Dilan18-Jul-07 22:17

Chatura Dilan

18-Jul-07 22:17

I'm working on a project on controlling the printer using C#. Such as restrict printing, counting no of pages.

I need references...
and I like to share ideas, if you have worked on that kind of project.

Any ideas? any links you know?

Thanks. Smile | :)

Chatura Dilan

Changing color while drag mouse

satsumatable18-Jul-07 22:11

satsumatable

18-Jul-07 22:11

Hi,

I want to change the color of Panel when i drag the mouse, that is color should be changed only where am dragging rest of the area should be as it is.

I have mouse position as like below

temp.X = e.X ;
temp.Y = e.Y ;
mMousePos = this.panel1.PointToScreen (temp);

I want to set the color for the area btw e.X and e.Y

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.