How to load large data to multiple filtered combobox's - C# Discussion Boards

Re: MS OFFICE refence version create problem to change code of program

dan!sh 7-Dec-09 0:46

dan!sh

7-Dec-09 0:46

I think you can make use of late binding here. Or have something like:

// Check Office version

if(Office 2003){
// do something 
}
else if (Office 2007){
// do something else
}
else{
// why don't you upgrade your office version?
}

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: MS OFFICE refence version create problem to change code of program

ishika_kukki7-Dec-09 18:35

ishika_kukki

7-Dec-09 18:35

can u show an example which will be same for all version of MS OFFICE, just simply opening a file.

Re: MS OFFICE refence version create problem to change code of program

Eddy Vluggen7-Dec-09 2:54

Eddy Vluggen

7-Dec-09 2:54

The InterOp-DLL's for Office are version-specific, and you'll need the same version on the desktop. You could use a plugin-architecture (the strategy pattern) to decouple the logic from your application.

ishika_kukki wrote:
in VB 6.0 we hav to add or change only reference and no need to change in code, but in C# .net i have to change the code as well as Reference of Office DLL.

Can you show an example?

I are Troll Suspicious | :suss:

How to save textBox to a file

tamir9017-Dec-09 0:10

tamir901

7-Dec-09 0:10

Hi,

I'm trying to save the context that i have in my textBox (Multi Line) to a text file,
But to keep the lines order.

i know how to do it with richTextBox-

foreach (string line in richTextBox.Lines)<br />
                    {<br />
                        textToSave.WriteLine(line);<br />
<br />
                    }

But i have to user textBox only... Frown | :(

Someone has a idea?

Re: How to save textBox to a file

dan!sh 7-Dec-09 0:47

dan!sh

7-Dec-09 0:47

You can make use of File.WriteAllLines method to do this.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: How to save textBox to a file

JoeSharp7-Dec-09 0:48

JoeSharp

7-Dec-09 0:48

hi
why you write the text line by line?

using(StreamWriter sw = new StreamWriter(filename))
{
sw.Write(textbox.Text);
}

regards

Re: How to save textBox to a file

tamir9017-Dec-09 1:16

tamir901

7-Dec-09 1:16

Thanks,
It's working great... Wink | ;)

How to load large data to multiple filtered combobox's

Sevententh6-Dec-09 23:43

Sevententh

6-Dec-09 23:43

Hi,

I'm after some suggestions on best practice to resolve an issue of loading large data combobox's (WPF).
I have two combo's Country & Airport. Country combo is to filter Airport combo (with just Airports in that Country) simple...

There are approx 260 Countries and 10,000+ airports worldwide

Using MVVM

public viewmodelFlights()
{
CountryList = new List<CountryModel>(wcfService.GetCountries());
AirportList = new List<AirportModel>(wcfService.GetAirports());

icCountryView = CollectionViewSource.GetDefaultView(CountryList );
icCountryView.CurrentChanged += new EventHandler(icCountryView_CurrentChanged);
icCountryView.MoveCurrentToPosition(-1);

icAirportView = CollectionViewSource.GetDefaultView(AirportList );
icAirportView.CurrentChanged += new EventHandler(icAirportView_CurrentChanged);
icAirportView.MoveCurrentToPosition(-1);
}

just so you get the vm idea Big Grin | :-D

I'm trying to get this initial loading quicker. Is there anyway to only load the airports once the Country has been selected?
I have a bigger problem with a hospital list which has 1,000,000+ records!!

SendKey Method

M Riaz Bashir6-Dec-09 23:17

M Riaz Bashir

6-Dec-09 23:17

Hi,

kindly let me know, How may I send "TAB" key aur "SHIFT+TAB" key
using SendKey method?

(Riaz)

Re: SendKey Method

Abhinav S6-Dec-09 23:24

Abhinav S

6-Dec-09 23:24

Try SendKeys.Send("+{TAB}");

Re: SendKey Method

M Riaz Bashir6-Dec-09 23:55

M Riaz Bashir

6-Dec-09 23:55

Thank you

OnGotFocus

Tagamoga6-Dec-09 22:56

Tagamoga

6-Dec-09 22:56

Hello.

Unfortunatally I am new to c#. Ich have written a class, that derives TabPage. Unfortunatally it's OnGotFocus Method does not react, when the Tab gets the Focus. What I do wrong?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    class MontlyTab : TabPage
    {
       [...]

        protected override void  OnGotFocus(EventArgs e)
        {
            base.OnGotFocus(e);
            // do something very Special
        }

	[...]
    }
}

Thank you for help!

How do you know, that Tagamoga has been assimilated by the borg?
"Recistunce ist fiutille."
Sorry for violating the english language.

Re: OnGotFocus

Shameel6-Dec-09 23:08

Shameel

6-Dec-09 23:08

Try OnEnter and OnLeave events.

Re: OnGotFocus

Tagamoga6-Dec-09 23:17

Tagamoga

6-Dec-09 23:17

*giving a big hug* THANK YOU, it works!

How do you know, that Tagamoga has been assimilated by the borg?
"Recistunce ist fiutille."
Sorry for violating the english language.

Re: OnGotFocus

Shameel7-Dec-09 6:53

Shameel

7-Dec-09 6:53

you're welcome Smile | :)

database connection problem

Erdinc276-Dec-09 21:48

Erdinc27

6-Dec-09 21:48

hi all
i am just beginner in c# and i want to make a PhoneBook project by using ADO.Net.. and i use SQL Server 2005 Express Edition for my database
but i have a problem while connecting database..in the error it says:
"Cannot database "Kisiler" requested by the login.The login failed.The login failed for user 'Computer\SQLEXPRESS'"
my connection string is like that :
SqlConnection con = new SqlConnection("Data source=COMPUTER\\SQLEXPRESS;initial catalog=Kisiler;integrated security=True");
i checked services after that error..everything looks running when i looked at SQL Server Configuration manager
what should i do now ?

Re: database connection problem

lalit146-Dec-09 22:21

lalit14

6-Dec-09 22:21

SqlConnection con = new SqlConnection("Data source=COMPUTER\\SQLEXPRESS;initial catalog=Kisiler;integrated security=True; User id=sa; Password=123456");

Use this. but do remember to type ur userid and password

Regards
Lalit Manik

Re: database connection problem

Erdinc276-Dec-09 22:42

Erdinc27

6-Dec-09 22:42

thanks for the reply friend
i tried the string u wrote but still i get same error
and i didnt use any password while i was creating my table...i mean i use 'Windows Authentication' mode
u have any else suggesstion ?

Re: database connection problem

puri keemti6-Dec-09 22:27

puri keemti

6-Dec-09 22:27

Problem is with connection string.
User name and password credentials are missing there....

Re: database connection problem

MNantu6-Dec-09 22:43

MNantu

6-Dec-09 22:43

When connecting to a database with Integrated Security set to true, I don't think you need to specify User ID and Password. Smile | :)

Re: database connection problem

MNantu6-Dec-09 22:36

MNantu

6-Dec-09 22:36

Try changing the Data Source to

Data Source=.\\SQLEXPRESS (Assuming you're using the default instance.)

You can also check out connectionstrings.com[^]

Hope this helps =)

Re: database connection problem

Erdinc276-Dec-09 23:15

Erdinc27

6-Dec-09 23:15

hi
i checked the site
but as i see my connection string is the same in the site
i give permission that user to use the database but still i have error
Frown | :(

Re: database connection problem

MNantu6-Dec-09 23:20

MNantu

6-Dec-09 23:20

Which OS do you use by the way

Re: database connection problem

Erdinc276-Dec-09 23:43

Erdinc27

6-Dec-09 23:43

i use windows XP

Re: database connection problem

lalit147-Dec-09 0:01

lalit14

7-Dec-09 0:01

Try "Integrated Security=false" and the above code i have given...

i Hope it will work

Regards

Lalit Manik

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