C# Discussion Boards - CodeProject

ACorbs12-Nov-04 19:40

12-Nov-04 19:40

this.SetStyle(System.Windows.Forms.ControlStyles.DoubleBuffer, true);
this.SetStyle(System.Windows.Forms.ControlStyles.AllPaintingInWmPaint, true);

this.UpdateStyles();

Re: Flicker-free control resizing ???

TyronX22-Dec-04 10:54

TyronX

22-Dec-04 10:54

I have the same problem and there doesn't seem to be any kind of solution for this available.

Double Buffering with that SetStyle thingy didn't work.

Create application setup

Member 87345212-Nov-04 6:51

Member 873452

12-Nov-04 6:51

I want to install DotNetFramwork befor my application automatically in my setup because as you know the DotNetFramwork must be installed for C# programs

Re: Create application setup

MoustafaS12-Nov-04 12:27

MoustafaS

12-Nov-04 12:27

Do u want to do it by your C# program or what there is no way for that cuz that program won't start the only way for this is the pc that the program will be on it to have the .NET framework installed or In the README file give them instructions to download it and give them the link to the direct download

ByMindOnlyYouCanDoIt

Command Parameter Issue

RB@Emphasys12-Nov-04 5:48

RB@Emphasys

12-Nov-04 5:48

So Im calling a sproc with various required parameters. It returns a value through one of its parameters, so, I added the following to lines to my command object setup;

oCommand.Parameters.Add(new SqlParameter("@Return_ValueMsg", SqlDbType.VarChar, 255));
oCommand.Parameters["@Return_ValueMsg"].Direction = ParameterDirection.ReturnValue;

But...., I keep getting this exception when I try to execute the command,
{"Procedure 'glpImportJEFromProcurement' expects parameter '@Return_ValueMsg', which was not supplied." }

Any Idea's?

Thanks,
Ryan

Re: Command Parameter Issue

Richard Deeming12-Nov-04 6:27

Richard Deeming

12-Nov-04 6:27

ParameterDirection.ReturnValue is for the integer value returned from the stored procedure via the RETURN statement. Use ParameterDirection.Output instead.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Re: Command Parameter Issue

RB@Emphasys12-Nov-04 7:54

RB@Emphasys

12-Nov-04 7:54

ahh thanks!, i just have been staring at this too long.

DataBind problem

webhay12-Nov-04 3:18

webhay

12-Nov-04 3:18

i made tow combobox one of them filled in page load and the other one fill when the user select a value form the First one but i got this error:

"The Column prefix 'System.Data' does not match with a table name or alias name used in the query"

and this my code:

the First Combobox:

SqlConnection cnn    = new SqlConnection();<br />
			cnn.ConnectionString = DB.ConnectionSTR(DB.Current_DB());<br />
			SqlCommand cmd = cnn.CreateCommand();<br />
			cmd.CommandType = CommandType.Text;<br />
			cmd.CommandText = "Select Client_ID,Client_Name From Client";<br />
			SqlDataAdapter da = new SqlDataAdapter();<br />
			<br />
			DataTableMapping TblMap;<br />
			DataColumnMapping ColMap;<br />
			TblMap = da.TableMappings.Add("Client","Client");<br />
			ColMap = TblMap.ColumnMappings.Add("Client_ID","Client_ID");<br />
			ColMap = TblMap.ColumnMappings.Add("Client_Name","Client_Name");<br />
			da.SelectCommand = cmd;<br />
			DataSet ds = new DataSet();<br />
			da.Fill(ds,"Client");<br />
<br />
			cboClient_Name.DataSource = ds;<br />
			cboClient_Name.DisplayMember = "Client.Client_Name";<br />
			cboClient_Name.ValueMember   = "Client.Client_ID";

The Seconde combobox:

<br />
SqlConnection cnn    = new SqlConnection();<br />
			cnn.ConnectionString = DB.ConnectionSTR(DB.Current_DB());<br />
			SqlCommand cmd = cnn.CreateCommand();<br />
			cmd.CommandType = CommandType.Text;<br />
			cmd.CommandText = "Select MSA_ID,MSA_Effective_Date From MSA Where Client_ID="+cboClient_Name.SelectedValue.ToString()+"";<br />
			SqlDataAdapter da = new SqlDataAdapter();<br />
			<br />
			DataTableMapping TblMap;<br />
			DataColumnMapping ColMap;<br />
			TblMap = da.TableMappings.Add("MSA","MSA");<br />
			ColMap = TblMap.ColumnMappings.Add("MSA_ID","MSA_ID");<br />
			ColMap = TblMap.ColumnMappings.Add("MSA_Effective_Date","MSA_Effective_Date");<br />
			da.SelectCommand = cmd;<br />
			DataSet ds = new DataSet();<br />
			da.Fill(ds,"MSA");<br />
<br />
			cboClient_Name.DataSource = ds;<br />
			cboClient_Name.DisplayMember = "MSA.Client_Name";<br />
			cboClient_Name.ValueMember   = "MSA.Client_ID";

Re: DataBind problem

Skynyrd12-Nov-04 3:59

Skynyrd

12-Nov-04 3:59

You are not including MSA.Client_ID and MSA.Client_Name in ur MSA SQL select command. Those DataColumns dont exist in the MSA DataTable and therefore u cannot databind to them.

Re: DataBind problem

webhay12-Nov-04 4:58

webhay

12-Nov-04 4:58

Thanks about your Help

but i change it to :
cmd.CommandText = "Select MSA_ID,Client_ID,MSA_Effective_Date From MSA Where Client_ID="+cboClient_Name.SelectedValue+"";

but it give me the same error

please help

Re: DataBind problem

Skynyrd12-Nov-04 10:16

Skynyrd

12-Nov-04 10:16

Ok, I haven't seen your code so I'm not sure if this is your problem, but it does sound like it is:

Whats probably happening is that u are databinding the second combobox in the form's contructor or in any other method that runs before the Load event and thus the second combobox's databinding is active when u start filling the first combobox. The Fill method is triggering ur probable SelectedIndexChanged event on ur first Cbo and thats whats causing the problem. U cant have that event happening while ur first dataset is filling. Your sqltextcommand will not build right because it cant read a loading datatable: thats why ur getting the error "The Column prefix 'System.Data' does not match with a table name or alias name used in the query". It's because SelectedValue is probably giving u the type of the ValueMember ("System.Data.DataViewManagerListItemTypeDescriptor") because it can't read anything else at that point.

Solutions:

Link the SelectedIndexChanged event manually in the LoadForm event handler (not through designer which links it in the constructor) , AFTER ur first cbobox code.

Best soltion: If ur sure that u only want the event to happen when a user commits a change in the first cbobox, then use the SelectionChangeCommitted event. U can link this one from the designer as it will only fire when a user changes the selected index. It wont fire with a code induced change.

Check and seee if this fixes the problem.

P.D. Recheck the code in ur second cbobox, ur databinding the wrong ComboBox....i think.

Re: DataBind problem

webhay18-Nov-04 4:04

webhay

18-Nov-04 4:04

Hi Skynyrd ,

Thnaks your soultions working very good ...
i used SelectionChangeCommitted event

may you help me to understand why the selectedvalue dosnt work

regards
ha Big Grin | :-D

Online Database?

The underdog12-Nov-04 3:13

The underdog

12-Nov-04 3:13

I was wondering
is it possible to use a online database in a local application?
And yes how?
Is it also possible to use a My SQL database in a progam and again yes how?
Could someone help me please
im trying for months now

The_Underdog

Re: Online Database?

Colin Angus Mackay12-Nov-04 7:15

Colin Angus Mackay

12-Nov-04 7:15

The underdog wrote:
is it possible to use a online database in a local application?

What do you mean by "online database"? Surely a database has to be online in order to work? Do you mean "remote"? (as in on another machine). If so, then do you mean within the same network or across the internet?

The underdog wrote:
how?

Assuming you mean remote then the connection string will usually give the name of the server, or the location of the database. I would thing that file-bases databases (like Access) wouldn't work too well in the this scenario. But I've never tried other than a few connections in a LAN environment.

The underdog wrote:
Is it also possible to use a My SQL database in a progam and again [if] yes [then] how?

Yes, You can use the MySql Connector[^] for .NET. Or you can use the ODBC driver and connect via that.

Do you want to know more?

C# form_load event

Phil Finlay12-Nov-04 3:05

Phil Finlay

12-Nov-04 3:05

I am attempting to protype an application in C#. The program has three forms, in one of them (MapScr_Load) I want to call an initialization function from the form_load event handler. I put a breakpoint in the form_load handler but it is apparently never getting called. In a different form (ReadScr_Load) everything works as expected. Any ideas why this might be?

Phil Finlay

Re: C# form_load event

Skynyrd12-Nov-04 4:09

Skynyrd

12-Nov-04 4:09

Are you only instancing a new MapScr_Load form? or are u calling its Show() or ShowDialog() methods?

Load events only happen just before a form pops up on screen and u have to call the Show() or ShowDialog() methods.

Re: C# form_load event

Phil Finlay12-Nov-04 5:47

Phil Finlay

12-Nov-04 5:47

Thanks for your reply. I think I am doing things right. Here are the relevant lines of code:
// From the Settings_Scr.cs
:
:
private void GoToMapScreen_Click(object sender, System.EventArgs e)
{
MapScr MAPobj = new MapScr();
if (ESRImap.Checked) // a radio button
{
MAPobj.ESRIMap = true;
}
else
{
MAPobj.ESRIMap = false;
}
MAPobj.ShowDialog();
}
:

// From the MapScr.cs
:
:
this.Load += new System.EventHandler(this.MapScr_Load);
:
:
private void MapScr_Load(object sender, System.EventArgs e)
{
if (ESRIMap) // a breakpoint on this line never gets called
{
InitializeESRIMap();
}
else
{
InitializeMapPoint();
}
}

Phil F.

Re: C# form_load event

Skynyrd12-Nov-04 10:26

Skynyrd

12-Nov-04 10:26

1. Does ur MapScr get to show onscreen when u run the app?

2. Where is the "this.Load += new System.EventHandler(this.MapScr_Load)" instruction located?

If its not in InitializeComponents() are u sure the constructor u are calling is running that method?

Try putting a breakpoint in that instruction and see if it ever gets called. Ur code seems perfect so the only logical explanation is that the instruction linking the eventhandler is not running somehow.

Re: C# form_load event

Phil Finlay15-Nov-04 9:15

Phil Finlay

15-Nov-04 9:15

Thanks again for your reply.

MapScr does display.
"this.Load += new System.EventHandler(this.MapScr_Load)" is located in the InitializeComponents()and a breakpoint on it does stop the execution, but still no luck on executing MapScr_Load.

Since this is a prototype application I am going to put a button on the screen to display the appropriate map and try and figure out what is happening to MapScr_Load later when I have more time to devote to it.

Thanks again,

Phil Finlay

Phil Finlay

RichTextBox and DetectUrls

benjymous12-Nov-04 1:51

benjymous

12-Nov-04 1:51

I have a rich text box, have set DetectUrls to true and have functionality on it's LinkClicked event, and everything works nicely for common types of url like http:// file:// ftp:// and so on

the problem is that it only seems to detect a certain built in set of protocols, whereas ideally I'd like to to be able to display [anything]://[anything else] as a clickable url

(The reason is we use alienbrain [similar to sourcesafe] which lets you copy/paste links to files in the database [ as alienbrain://path/to/file/in/database ] - office apps detect these as urls happily (so you can email links around to files) but I'd like my rich text control to be able to have the same such links

--
Help me! I'm turning into a grapefruit!
Phoenix Paint - back from DPaint's ashes!

Re: Recursion (Can someone walk through cheese?)

benjymous12-Nov-04 0:44

benjymous

12-Nov-04 0:44

Here's how I'd approach something like this

Give each cube a Visited property - set all of them to False initially

Create a member function something like this

Visit( target )
{
  this.Visited = true;

  if this == target
    You've found a route through!
    exit
  endif
  

  for each of the 6 neighbour
    if neighbour.visited == false 
      if neighbour.filled == false 
        neighbour.Visit( target )
      endif
    endif
  endfor

}

then assuming "Start" is the starting cube, and "End" is the ending cube, just call

Start.Visit( End )

As this looks like homework to me, I've written basic pseudocode, so you'll have to actually implement it yourself (and work out how to keep track of the successful route) Smile | :)

--
Help me! I'm turning into a grapefruit!
Phoenix Paint - back from DPaint's ashes!

Re: Recursion (Can someone walk through cheese?)

Sebastian Schneider12-Nov-04 1:58

Sebastian Schneider

12-Nov-04 1:58

NP. I prefer implementing this myself anyway.

And yepp, what you did should solve the problem: Keep track of the already visited cubes.

Darn Big Grin | :-D

Cheers
Sid

I'd like to use IPicture class using C#

Anonymous12-Nov-04 0:37

Anonymous

12-Nov-04 0:37

Dear Sir,

I am thinking about how to use IPicture class using C#.
I am developing the tool using one component.
This component have a function to draw picture.
But this interface have IPicture.
I try to look for how to get IPicture.

If you know it, please tell me.

regards,
yu-yu

Creating a table from code

vog_ro12-Nov-04 0:31

vog_ro

12-Nov-04 0:31

I am trying to create a table from inside the code of a windows application written in c#.

The table will be created in a .mdb file for example.

I found out a way using ADOX but the example was poorly written and i didn't understood much(and it s not working either.. Smile | :)

...)

So can anyone help me?

I thank u in advance. Big Grin | :-D

Re: Creating a table from code

David Salter12-Nov-04 2:33

David Salter

12-Nov-04 2:33

If you've already got the database, you should be able to create a table using ADO and shouldn't need ADOX.

You can create a table by issuing a "create table ..." command to the database.

Store your favourite bookmarks online: my-faves.co.uk

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