Re: simple connection to Access database in c# - C# Discussion Boards

Rickard Andersson²⁰5-Dec-02 0:49

5-Dec-02 0:49

Christian Graus wrote:
so long as it has the .NET framework installed

Christian, I don't want to be bothersome, but do they really need the whole .NET Framework? Smile | :)

Don't they only need the .NET redistributable files (20mb)in able to run C# apps? Smile | :)

This has been discussed many times before, but. Because he was newbie I wanted to say this. Hope you understand my point, Christian.

Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!

Re: C# and Windows'98

djkno35-Dec-02 1:31

djkno3

5-Dec-02 1:31

Also I've read that you *can* develop on win98 with C# because the redistibuteable comes with the C# compiler. Allthough I've never used it like this...

Re: C# and Windows'98

Rickard Andersson²⁰5-Dec-02 1:57

Rickard Andersson²⁰

5-Dec-02 1:57

djkno3 wrote:
you *can* develop on win98 with C# because the redistibuteable comes with the C# compiler

Which compiler?
If you mean csc you can use it on Win98, but the Visual Studio .NET is only a NT capable IDE as Christian said.

Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!

Re: C# and Windows'98

djkno35-Dec-02 12:05

djkno3

5-Dec-02 12:05

Rickard Andersson wrote:
Which compiler?
If you mean csc you can use it on Win98, but the Visual Studio .NET is only a NT capable IDE as Christian said.
actually yes that is the the compiler but I fail to see where he said anything about Visual Studio .NET Poke tongue | ;-P

as far as I know http://www.icsharpcode.net/OpenSource/SD/default.asp[^]should run on win98...

Re: C# and Windows'98

Rickard Andersson²⁰5-Dec-02 20:42

Rickard Andersson²⁰

5-Dec-02 20:42

That is an IDE. Not a compiler. I don't think there is more than the csc compiler for C#....

Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!

Re: C# and Windows'98

Christian Graus5-Dec-02 6:33

Christian Graus

5-Dec-02 6:33

Rickard Andersson wrote:
Christian, I don't want to be bothersome, but do they really need the whole .NET Framework?
Don't they only need the .NET redistributable files (20mb)in able to run C# apps?

That is exactly what I meant.

Christian

No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002

Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002

Again, you can screw up a C/C++ program just as easily as a VB program. OK, maybe not as easily, but it's certainly doable. - Jamie Nordmeyer - 15-Nov-2002

simple connection to Access database in c#

Abu Atwan4-Dec-02 13:36

Abu Atwan

4-Dec-02 13:36

Anyone tell me about creating simple connection to Access database in c# using datagrid, and textboxes. .:confused

Re: simple connection to Access database in c#

Nick Parker4-Dec-02 17:55

Nick Parker

4-Dec-02 17:55

Abu Atwan wrote:
Anyone tell me about creating simple connection to Access database in c# using datagrid, and textboxes.

Sure here is a quick example:

string sql;
sql = GetSearchString();<font color=green>  //function that creates my SQL statement</font>
try
{
	string myConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" 
         +  "Data Source=" + @"C:\Documents and Settings\User\Desktop\phonebook\phonebook.mdb";
	OleDbConnection myConnection = new OleDbConnection(myConnString);
	myConnection.Open();
	OleDbCommand myCommand = new OleDbCommand();
	myCommand.Connection = myConnection;
	myCommand.CommandText = sql;
	OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myCommand);
	DataSet myDataSet = new DataSet();
	myDataAdapter.Fill(myDataSet);
	this.dataGrid1.DataSource = myDataSet;
	this.dataGrid1.Visible = true;
	myConnection.Close();
}
catch(Exception err)
{
	MessageBox.Show("An error has occured\n\n" + err.Message + "\n" + err.Source + "\n", "Phone Book Error");
}

Hope this helps. Smile | :)

Nick Parker

Not everything that can be counted counts, and not everything that counts can be counted. - Albert Einstein

C# Office Addins

Chris Ormerod4-Dec-02 13:27

Chris Ormerod

4-Dec-02 13:27

Can anybody please help on a problem I am having?

My problem is that I need to be able to get the name of the application that my AddIn has been loaded into (Word, Excel etc.). I assume I use the application object that gets passed into the OnConnection method, but I am unsure how to get the reference to the "Name" property.

Does anybody have any samples or references that might help me in my endeavours?

Have a look at my website: http://www.chrisormerod.cjb.net

Re: C# Office Addins

Kannan Kalyanaraman4-Dec-02 19:03

Kannan Kalyanaraman

4-Dec-02 19:03

Chris Ormerod wrote:
Does anybody have any samples or references that might help me in my endeav

Hi Chris,

There are lot of references / articles on msdn on how to go about writing addins using managed code.
For starting take a look at this
Creating Office Managed COM Add-Ins with Visual Studio .NET[^]
Also have a look at this [^]
article, which might help you with your specific problem.
Hope this helps.

Cheers
Kannan

tray icon

grv5754-Dec-02 12:49

grv575

4-Dec-02 12:49

Is it possible to have text on the tray icon (notifyicon)? Want to do one of those %cpu usage tickers...

Re: tray icon

David Stone4-Dec-02 12:56

David Stone

4-Dec-02 12:56

Do you mean a tooltip or actual text in the systray?

I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past.
-Chris Maunder

Microsoft has reinvented the wheel, this time they made it round.
-Peterchen on VS.NET

Re: tray icon

grv5754-Dec-02 21:00

grv575

4-Dec-02 21:00

Actual text.

Re: tray icon

Kannan Kalyanaraman4-Dec-02 19:07

Kannan Kalyanaraman

4-Dec-02 19:07

Yes it is very much possible Smile | :)

Have a look at this[^] article.
Hope this helps.

Cheers
Kannan

TreeNode selection Helppppp

Nicholas Naddaf4-Dec-02 8:37

Nicholas Naddaf

4-Dec-02 8:37

Hi Guys
I am trying to make TreeNode is selected when I right click it, but I couldn't I used to do that in VB but in C# in not working,
I can do it when I left click it not when I right click
any help pleasee....

Re: TreeNode selection Helppppp

Chris Austin4-Dec-02 8:46

Chris Austin

4-Dec-02 8:46

Fayez,

If you post you code mabey we could provide better help.

Chris

Fill me with your knowledge, your wisdom, your coffee.

Re: TreeNode selection Helppppp

Nicholas Naddaf4-Dec-02 8:50

Nicholas Naddaf

4-Dec-02 8:50

my is not working.

private void tvwLeft_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
if(e.Button == MouseButtons.Right)
{
TreeView box = sender as TreeView;
}
}
}

I wanna make the node that I right click on it to be the selected node.

Re: TreeNode selection Helppppp

Nicholas Naddaf4-Dec-02 9:27

Nicholas Naddaf

4-Dec-02 9:27

I got it

private void tvwLeft_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{
if(e.Button == MouseButtons.Right)
{
TreeView box = sender as TreeView;
tvwLeft.SelectedNode = box.GetNodeAt(e.X, e.Y);
}
}

Listbox header column bitmaps

MariaWard4-Dec-02 8:36

MariaWard

4-Dec-02 8:36

Has anyone figured out how to add a bitmap to a listbox header column in C#?

Maria Ward

Re: Listbox header column bitmaps

Nick Parker4-Dec-02 9:03

Nick Parker

4-Dec-02 9:03

MariaWard wrote:
Has anyone figured out how to add a bitmap to a listbox header column in C#?

Sure, you should be able to do something like this with a image list:

listView1.HeaderImageList = headerImageList;
listView1.SetHeaderIcon(0, 0);

Take a look at Carlos H. Perez's article on C# Sorted ListView[^] for more of an example. Smile | :)

Nick Parker

Not everything that can be counted counts, and not everything that counts can be counted. - Albert Einstein

That AppUpdater thing from GotDotNet

Tom Welch4-Dec-02 6:39

Tom Welch

4-Dec-02 6:39

Anyone using it?

AppUpdater[^]

I am having a few problems with it and GOTDOTNET appears to have broken their message boards.

PROBLEMS:

1. Kinda works when debugging, however it always tells me there is an update available - even when server has the same version as client.

2. Fails miserably in Release mode.

I have an UpdateVersion.xml on the server that says the next version is 2.0.0.0 and in the /2.0.0.0/ directory. However, the program downloads the 1.0.0.0 version from the /1.0.0.0/ directory. On top of that, it puts the update in a /1.0.0.0_1/ directory on the client. Which is curious because it downloads the UpdateVersion.xml file from the server that contains the 2.0.0.0 information. The log file just keeps repeating "Successfully updated version 1.0.0.0"

WTF | :WTF:

--
If it starts to make sense, you're in a cult.

Re: That AppUpdater thing from GotDotNet

Nathan Tran4-Dec-02 6:46

Nathan Tran

4-Dec-02 6:46

Hi,

If you log into irc on Efnet and go to #ms.net you can ask either ^CareBear or Wilco about this since they've dissected this example and even made their own variant.

Nathan.

Clientside UserControl

Peter Kiss4-Dec-02 2:45

Peter Kiss

4-Dec-02 2:45

Hi!

I have a real problem. (Sorry for my english.)
I want to make a client side usercontrol like an activexobject
with C#. ( Client has framework too)
There are several examples on the net
(http://www.mastercsharp.com/article.aspx?ArticleID=70&&TopicID=14
...etc).

!!!BUT!!!

Never worked any of them!
I open the website, and the control seems like to be a simple textarea!
I suggested, there was a problem withinternet options.
But all of them (Local intranet zone, and internetzone are allowed for everything,IIS settings are more than correct for enableaing everything to do with the site. And there is no control.)

Please help me! Maybe the settings of the trusted assemblies of the framework are bad??? or what's wrong with that?

( some enviromental:
.NET studio 7.0.9466
framework 1.0.37.05
IE 6.2800.1106 /SP1;Q328970
Win2k server 5.00.2195 SP3)

Time getting to be to late! Please Help Me!!!

Agyklon

Re: Clientside UserControl

John Rayner4-Dec-02 7:34

John Rayner

4-Dec-02 7:34

Security is your problem. The default security setup on a .NET install assigns no permissions to code downloaded from the Internet (specifically the permission group Nothing). Your options are:

Reconfigure the security on your machine (not really recommended)
Add your site into the list of Trusted Sites

You can configure your security settings by opening the .NET Framework Configuration console (under Programs / Administrative Tools on my Win2K box) and then open Runtime Security Policy / Machine / Code Groups / All_Code / Internet Zone, click on Edit Code Group Properties and go to the Permission Set tab. Here you can choose what permissions to allow code downloaded from the Internet. For a really good explanation of all this, check out Don Box's excellent MSDN Magazine article[^].

Adding your site to the list of Trusted Sites is done through Tools / Inernet Options / Security from Internet Explorer.

Either way there's going to some setup needed on machines accessing your site. Sorry.

I seem to recall that the default security policy changed in SP1. Not entirely sure of this though. And I don't really know much about what happened in SP2.

Re: Clientside UserControl - without success

Peter Kiss6-Dec-02 5:09

Peter Kiss

6-Dec-02 5:09

Hi.
It's me again, Peter.

I've tried an other lot of couple variations of settings,
at the adminstration tool, without any success. Cry | :((

I've rebuilded the code.
The site is trusted as well,as the code is trusted.
I haven't any more idea.

Maybe I should ask the Microsoft for it. Or have you done a real working example before?
I haven't seen any example before, what works. Unsure | :~

well..

Please help if you have done some working client side usercontrol!
Please tell me the steps where I was fault.

(Sorry for my english Eek! | :eek:

)

Agyklon

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