Re: MS OFFICE refence version create problem to change code of program - C# Discussion Boards

OriginalGriff7-Dec-09 1:37

7-Dec-09 1:37

Well it has the advantage of honesty!

Not enough to just give you the code, but at least it's honest.

First: Decide what database system you will use. What have you got to play with?
Second: Create a table in the database, create a field in the table.
Third: Write code:
Third.First: Connect to database
Third.Second: Read from database, identify highest existing entry
Third.Third: Increment enty to create new one.
Third.Fourth: Add to database, check for error.
Third.Fifth: If error, repeat from Third.Second.
Fourth: Use new entry as number.

There are other ways to do it, but that is the basic idea.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"

Re: Generating a Unique ID.

Abhinav S7-Dec-09 1:16

Abhinav S

7-Dec-09 1:16

Try searching for GUID on msdn. You might get what you want.

Re: Generating a Unique ID.

Ashfield7-Dec-09 1:19

Ashfield

7-Dec-09 1:19

Abhinav S wrote:
You might get what you want.

But I doubt it when he doesn't want guids. The OP says Should Look like this "CID-00001,CID-00002,CID-00003.....", which are not GUIDS (but are dead easy to generate anyway)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Generating a Unique ID.

Abhinav S7-Dec-09 1:31

Abhinav S

7-Dec-09 1:31

Then I suppose its just a lot of homework Smile | :)

MS OFFICE refence version create problem to change code of program

ishika_kukki7-Dec-09 0:14

ishika_kukki

7-Dec-09 0:14

hi all,
i m working in a desktop application in which i added reference of MS WORD DLL and MS EXCEL DLL, and all reporting is Done in Word File and Excel File, project is working fine but whenever we installed program in any other system which contain MS OFFICE of other version an error generated,
Example: -

if i include reference of ms office 97, word ddl than i open exiting file as
WordDoc = new Word.Document();
WordApp = new Word.ApplicationClass();

WordDoc=WordApp.Documents.Open(ref filename, ref missing, ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
WordApp.Visible = true;

if we include reference of ms word XP dll than we open file as

WordDoc=WordApp.Documents.Open(ref filename, ref missing, ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing);
WordApp.Visible = true;

simiraly MS OFFICE 2003
includes some more parameter for OPEN method

my problem is that how can we include a Reference which work same for all version, because for every version of OFFICE we cannot make seperate code

thanks
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.

thanks pls help me

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 | :)

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