C# Discussion Boards - CodeProject

Re: Empty DataSet??? [modified]

NaNg152412-Jun-06 5:17

NaNg15241

2-Jun-06 5:17

so how from Schema I can add Data?

Re: Empty DataSet???

Dustin Metzgar2-Jun-06 5:27

Dustin Metzgar

2-Jun-06 5:27

I don't understand your dilemma here. You want to see the XML structure of your dataset, but you're not willing to put data in it to do that. How are you trying to use this XML? If you write the schema and data from the DataSet, then another DataSet that reads that XML and schema will have the same structure and data as the original. Otherwise, I really don't see what you're trying to do.

Ms Project Ole Db

Philippe Generet2-Jun-06 0:50

Philippe Generet

2-Jun-06 0:50

Hello all,

I've developed a little module of timesheet and within i use a ole db connection to a ms project file.
MsProject 2003 ==> Microsoft.Project.OLEDB.11.0 ole db provider.

On my pc, everything works fine BECAUSE I'VE MS PROJECT 2003 INSTALLED ON IT.
But i try to put it on the server (win 2000 sp 4 enterprise ) :
The 'Microsoft.Project.OLEDB.11.0' provider is not registered on the local machine.

Can anyone help me ?

Thanks a lot.

Re: Ms Project Ole Db

Emma Burrows2-Jun-06 2:53

Emma Burrows

2-Jun-06 2:53

Philippe Generet wrote:
On my pc, everything works fine BECAUSE I'VE MS PROJECT 2003 INSTALLED ON IT.
But i try to put it on the server (win 2000 sp 4 enterprise ) :
The 'Microsoft.Project.OLEDB.11.0' provider is not registered on the local machine.

At the risk of sounding obvious, I would say you need to either install Project on your server, or find out if there's some other way of installing the provider (though a quick look on Google didn't return anything). As a general rule, programming with Office applications seems to require them to be installed on the server.

Urgent

Shiv52-Jun-06 0:47

Shiv5

2-Jun-06 0:47

Dear All,

How do i set the Database object security from the frontend for the SQLServer with User Interface

Like If you create new login , What are all the privilege i need to give to that user

I m going to do this using Front End using C# with SQLServer.

With GreatRegards,
Siva

Re: Urgent

Colin Angus Mackay2-Jun-06 1:45

Colin Angus Mackay

2-Jun-06 1:45

Shiv5 wrote:
Urgent

Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?

Shiv5 wrote:
How do i set the Database object security from the frontend for the SQLServer with User Interface

What do you mean by your use of the proper noun "User Interface"? Do you mean using Enterprise Manager? Or did you mean "user interface" (adjective + noun combination)?

Shiv5 wrote:
Like If you create new login , What are all the privilege i need to give to that user

What do you want the user to be able to do? What do you want them not to be able to do?

Shiv5 wrote:
I m going to do this using Front End using C# with SQLServer

What is this proper noun "Front End"? Is it a new IDE? I'm gussing you mean you want to write a program in C# that will create a new user and assign privileges to that user. Is that correct?

You can run just about any SQL code through a SqlCommand object. If you can write in in Query Analyzer you can run it through a SqlCommand object (Just remember every time you see a GO in query analyzer that is new SqlCommand.

The SQL commands that you need are likely to be:
* sp_grantlogin[^]
* sp_grantdbaccess[^]
* GRANT {SELECT / UPDATE / INSERT / DELETE / EXECUTE} ON {object} ON{security account}[^]

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

Re: Urgent

led mike2-Jun-06 6:57

led mike

2-Jun-06 6:57

Colin Angus Mackay wrote:
Perhaps a little planning would be helpful?

ROTFLMAO

How to handle toolbar control?

maaran2-Jun-06 0:34

maaran

2-Jun-06 0:34

i have one toolbar control. it contain two buttons.
when i click any one of these two buttons,the same click event is fired in code behind.
How can i handle click event for two buttons indivually.

Re: How to handle toolbar control?

Darren_2-Jun-06 0:43

Darren_

2-Jun-06 0:43

Just put some code in your event to read the button text for example:

private void Button_Click(object sender, EventArgs e)
{
Button button = (Button)sender;

if (button.Text == "button1")
{
// do this for button 1
}
else if(button.Text == "button2")
{
// do this for button 2
}
else {}
}

Alternativly you can add seperate Event handlers for the differnt buttons. There are many ways to do it.

Re: How to handle toolbar control?

Dan Neely2-Jun-06 2:09

Dan Neely

2-Jun-06 2:09

private void OnToolbarButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)<br />
{<br />
	switch (this.ToolBar1.Buttons.IndexOf(e.Button))<br />
	{<br />

help about Ascii code and text box

Mairaaj Khan2-Jun-06 0:19

Mairaaj Khan

2-Jun-06 0:19

Hi,
is there any way or method to find out the Ascii code of the character that is typed in the text box.
Actually, i'm trying for a textbox that only accept numeric values/symbols (that is 0 to 9). Because i don't want to let my user to enter any character or special symbol except decimal point.
if anybody have any idea than please do let me!

With Thanks.

Re: help about Ascii code and text box

Darren_2-Jun-06 0:32

Darren_

2-Jun-06 0:32

Add an Event handler to the text box

this.textBox1.KeyDown += new System.EventHandler(this.textBox1_Keydown);

This allows 0-9 and backspace.

private void textBox1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
if(!Char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
{
e.Handled = true;
}

}

Re: help about Ascii code and text box

Mairaaj Khan2-Jun-06 1:14

Mairaaj Khan

2-Jun-06 1:14

Thanks a lot Darren Marshall!

its as simple as was in VB 6

Thanks and

Best Regards.

Google talk Call

Rahul.RK1-Jun-06 23:30

Rahul.RK

1-Jun-06 23:30

Hi..

I want to make an application in C#.Net to call user of google talk through

login by my google account..

Is there any apis.

If code or apis are there please give it to me.

Rahul Kulkarni

Re: Google talk Call

Darren_1-Jun-06 23:36

Darren_

1-Jun-06 23:36

There is no Google Talk API, the only way you can control things is to write a program that uses the Windows API to control the Google Talk window. i.e send mouse clicks etc etc. Which is pointless if your at the computer because you can just use the Google Talk app.

Control panel application in vc#.net

aloktambi1-Jun-06 22:43

aloktambi

1-Jun-06 22:43

i want to make one application in vc#.net which launch from windows control panel . i dont know how to make in vc#.net . i know that in VC++ we use CplApplet for this . can you help me in developing application in vc#.net

Re: Control panel application in vc#.net

Darren_1-Jun-06 23:04

Darren_

1-Jun-06 23:04

You can call the API just the same in C# but you need to include the System.InteropServices; namespace. I think this article might be what your looking for:

http://www.developerfusion.co.uk/show/4451/1/[^]

Re: Control panel application in vc#.net

aloktambi2-Jun-06 22:16

aloktambi

2-Jun-06 22:16

i am not gettiing much from this link. can you please give me some code for use windows APIs in C# like how to use CPlApplet in C#

Extending a Panel

rajeshkdb1-Jun-06 22:22

rajeshkdb

1-Jun-06 22:22

I am extending an panel. Now my problem is , when i click on the panel it should get selected. I can any no of control to this custom panel. do i need to subscribe to all the mouse events such mouse down and set the focus to the panel in order to get selected.

In the custom panel, how can i aceive drag and drop in the panel Assume that i have inherited from a panel and i have internally divided the panel into 4 parts and now i place a control on 1 part and the user should be able to drag the control at 1 and place it 4. Can anybody sugges me how to acheive this.

Thanks 4 answering
Regards,
Rajesh

Switching Panels on a Form with Control.Remove Control.Add

Darren_1-Jun-06 21:52

Darren_

1-Jun-06 21:52

Hi guys,

I have a single form to control my application and rather than use multiple windows it switches out the main panel depending on what view the user wants.

My problem is that its not very effective and wondered if you can point me in the right direction to get a flicker free app.

Should i go with this idea or is there anotehr solution?

Add all panels to the Form at run time (shouldent be a problem since there are only 3-6) Show the current panel while Hide the rest. While having a seperate thread update the 'main' and sleeping panels every say 1/2 second.

Thanks,

Darren

Re: Switching Panels on a Form with Control.Remove Control.Add

Darren_1-Jun-06 22:18

Darren_

1-Jun-06 22:18

Code is like this:

public void ShowHome()
{
this.Controls.Remove(currentPanel);
currentPanel = new App.Main.MainPanel();
this.Controls.Add(currentPanel);
currentPanel.BringToFront();
}

public void ShowSecond()
{
this.Controls.Remove(currentPanel);
currentPanel = new App.Main.SecondPanel();
this.Controls.Add(currentPanel);
currentPanel.BringToFront();

}

what i was thinking from my previous post was to add all panels at runtime and just .Hide() and .Show() them but have a second thread update them all periodically.

Re: Switching Panels on a Form with Control.Remove Control.Add

stancrm1-Jun-06 23:26

stancrm

1-Jun-06 23:26

There are 2 ways to do it:

1. Use this.SuspendLayout() before your code and this.ResumeLayout(false) after your code.
2. Use Visible = true or false to Show or Hide panels.

Re: Switching Panels on a Form with Control.Remove Control.Add

Darren_1-Jun-06 23:31

Darren_

1-Jun-06 23:31

Yeah i tried using .Hide() .Show() (not sure if that works the same as Visible and sets the same flag) but trouble is the panels generate content on specific things so if something has changed and i switch to the new panel the panel hasn't updated if you see what i mean.

Any ideas?

Re: Switching Panels on a Form with Control.Remove Control.Add

Darren_2-Jun-06 0:23

Darren_

2-Jun-06 0:23

Ok i tried quite a few things but i think i have a new solution:

Im going to create a TemplatePanel Abstract class that derives the Panel class and contains a Update() method, of which any app panels must derive.

Then i will run a thread that periodically calls the Update() method for all panels if the application is not minimised.

If anyone has another solution then please let me know,

Thanks

Darren

Which method is used to get IP's of nodes on LAN?

amber hussain1-Jun-06 21:25

amber hussain

1-Jun-06 21:25

How We can get information about the nodes attached on LAN programatically ven v r on server?Is there any method already present in C#?

thanks in advance

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