C# Discussion Boards - CodeProject

meeram3956-Dec-07 1:11

6-Dec-07 1:11

Hi,

Please find below an sql query which I have used for one of my projects. Replace the columns and fields with yours and check whether it will suits with your requirement:

insert into stalericstemp1(RIC_Name, No_of_Days, Last_Update_Date, Next_Update_Date, PE_Fid1, HeadEnd_Fid1383, Location_Fid836, CTBTR_BKDG, Ric_Added_Date, Record_Entry_Date, StaleRic, Message, Updated_Date, File_no) select * from StaleRicsTemp where next_update_date > '11/25/2007' and next_update_date < '12/03/2007'

order by ric_name

The * in the select query of second table contains exactly the same field and datatype of first table. Please let me know if it helps you.

Smile | :)

Meeram395

Re: problem with sql insert using c#

Le centriste6-Dec-07 2:10

Le centriste

6-Dec-07 2:10

It looks like you are missing a parenthesis just before the SELECT.

-----

You seem eager to impose your preference of preventing others from imposing their preferences on others. -- Red Stateler, Master of Circular Reasoning and other fallacies

If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

God is the only being who, to rule, does not need to exist. -- Charles Baudelaire

How to make Multilingual TextBox in C#.NET

D i x y5-Dec-07 23:54

D i x y

5-Dec-07 23:54

Hi How to make Multilanguage supportive textbox in C#.net

Re: How to make Multilingual TextBox in C#.NET

Skippums6-Dec-07 10:20

Skippums

6-Dec-07 10:20

I have used a RichTextBox in the past, and simply required that the end user has the microsoft language pack installed. That way, the OS deals with the language exclusively (changing keyboard input and the like), which makes this kind of operation transparent to your application.

-Jeff

Show a PDF file in a MDI application of C#

BinName5-Dec-07 22:58

BinName

5-Dec-07 22:58

Hello everybody, I encounter a problem and need your help.

In a MDI application of C#, I want to show a PDF file in a child form. I have added a PDF browser to the child form and change it to pulic, just like below:
public AxAcroPDFLib.AxAcroPDF pdfBrowser;

When the MDI load, my code likes below:

Code:

private void MDIFrm_Load(object sender, EventArgs e)<br />
        {<br />
            ChildFrm myChildFrm = new ChildFrm();<br />
            myChildFrm.pdfBrowser.LoadFile("C:\\dev\\linux-i18n-intro.pdf");<br />
            myChildFrm.MdiParent = this;<br />
            myChildFrm.Show();<br />
        }

However,I can not see the PDF content in the Child form,but if I set the ChildFrm as the strartup object,it will show PDF correctly.

Could anyone give some suggestions?
Thanks very much!
Birch

Re: Show a PDF file in a MDI application of C#

CKnig5-Dec-07 23:22

CKnig

5-Dec-07 23:22

I can only guess:

maybe the pdfBrowser loads an empty file on Form_Load?
Anyway: you should not put the pdfBrowser on a public property - better give the path to the constructor and set it in the form.

Anyway he problem seems to be with the pdfBrowser - maybe try using the webbrowser-control to show your files?

DataGridview help

sindhutiwari5-Dec-07 22:56

sindhutiwari

5-Dec-07 22:56

hi,
My aim is to print the datagridview text in to a textbox on clicking it .. i have done this before unfortunately i am not able to recollect it so if any one knows this please do inform me
REGARDS
SINDHU TIWARI

its me sid

Re: DataGridview help

dan!sh 5-Dec-07 22:59

dan!sh

5-Dec-07 22:59

just write the concerned code in cell click event

Until you realize this message has nothing to say, its too late to stop reading

Re: DataGridview help

suyuan19845-Dec-07 23:07

suyuan1984

5-Dec-07 23:07

I have encountered similarly problem ,please give me some code for this question

my english is very bad!

Re: DataGridview help

Gopal.S5-Dec-07 23:31

Gopal.S

5-Dec-07 23:31

Here is the code snippet:

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
}

Gopal.S

How to change the initial value of DataSet.CaseSensitive (in .NET 2.0, it is false by default)

shintaerp5-Dec-07 22:12

shintaerp

5-Dec-07 22:12

I have written many methods that using DataSet.
Now, I realise that I need the property 'CaseSensitive' of every DataSet instance to be 'true'. I don't want to change every source file to make it. Is there any simple way to make each DataSet instance created with 'CaseSensive = true'? e.g. envirment setting

I am using Visual Studio 2005 (.NET 2.0).

Thank you.

C# and microthreads - more info wanted

Geert Masureel5-Dec-07 22:10

Geert Masureel

5-Dec-07 22:10

Hi all,

I recently found out about microthreads and I'm looking for more info on this topic (for implementation in C#) !

Any one knowing links to existing classes or articles ? Please let me know !

Thanks in advance !

Greetz,

Geert

TCP Class - Send Function

Programm3r5-Dec-07 21:25

Programm3r

5-Dec-07 21:25

Hi all,

I'm sending some data over TCP/IP and when I make use of a special character like ~ (tilde) it displays on my TCP/IP server as +AH4-

This is the code:

client.Client.Send(System.Text.Encoding.UTF7.GetBytes(richTextBoxSendData.Text));

Many Thanks in advance
Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: TCP Class - Send Function

CKnig5-Dec-07 23:27

CKnig

5-Dec-07 23:27

well seems your TCP/IP server don't understand UTF7 - try ASCII!
(System.Text.Encoding.ASCII.GetBytes(...)

Re: TCP Class - Send Function

Programm3r6-Dec-07 0:32

Programm3r

6-Dec-07 0:32

Thanks for the response, I'll give it a shot

Regards

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Regarding parameterizedthreadstart???

Ron.S5-Dec-07 21:24

Ron.S

5-Dec-07 21:24

Hello All,

I have a situation here, where in, i have to pass a ref object to a method that has to be called within a thread. how to pass that ref object within the parameterized thread.

Public void methodname(ref string Strname)
{
..
..
..
}

parameterizedthreadstart prmThst = new ParameterizedthreadStart(mehthodname(ref StrName)
thread thnew = new thread(prmthSt);

this is throwing error..

Help is required..

Thanks and Regards

Bharath.S Ron

Re: Regarding parameterizedthreadstart???

CKnig5-Dec-07 23:26

CKnig

5-Dec-07 23:26

no you hate to put it that way:

<br />
ParameterizedThreadStart prmThst = new ParameterizedThreadStart(methodname);<br />
Thread thNew = new Thread(prmThst);<br />
<br />
thNew.Start(ref StrName);<br />

About Combobox's ValueMember and DisplayMember

Zerox MXI5-Dec-07 20:07

Zerox MXI

5-Dec-07 20:07

When attaching a datasource to a combobox, one can choose to specify its display and value member. For instance...

class PhoneContact
{
... // omitted

public string Name { get { return this.name; } set { this.name = value; }
public string Number { get { return this.number; } set { this.number = value; }
}

PhoneContact[] arr;

combobox1.DataSource = arr;
combobox1.DisplayMember = "Name";
combobox1.ValueMember = "Number";

I wanted the drop down list to show a combination of Name and Number concatenated together but the show just the number in the textbox field of the combobox. How do I do that?

drop down list will show like this,

Name1, Number1
Name2, Number2
..., ...

And after you select one of them, it only shows number in the textbox field and not the concatenated one.

Rationale:

You have a list of numbers in your phone book, I decided to allow the user to choose one of the numbers from the phonebook in a lookup manner via the combobox. Or if the number does not exist, one can key in any number not from the phonebook into the combobox textbox field. However, the combobox will only show the value from a single field specified by DisplayMember, if I had made "Number" as the display member, a drop-down list of numbers will be meaningless to the end user when he can't even tell who the number belongs to. And if I put the DisplayMember as "Name", somehow, the end user would not be able to verify if the number associated to the name is correct or wrong.

And ideas? Thanks

Re: About Combobox's ValueMember and DisplayMember

CKnig5-Dec-07 20:13

CKnig

5-Dec-07 20:13

This is very easy in your example: just add a property - let's say

<br />
public string DisplayValue<br />
{ get { return Name + ", " + Number; } }<br />

to your PhoneContact class and use

<br />
combobox1.DisplayMember="DisplayValue";<br />

that's it.

Re: About Combobox's ValueMember and DisplayMember

Zerox MXI5-Dec-07 20:23

Zerox MXI

5-Dec-07 20:23

Yes I've tried that myself,

the only catch is that after you have selected one of values in that concatenated form from the drop down list, the textbox field is populated with "Name, Number", where what I would liked was just the number itself in the textbox field.

Eventually, what I need is just the number value where for some reason can't just get from SelectedValue property.

In a case where no number exists in the drop down list, SelectedValue property will be null or empty if some other number was entered into the textbox field of the combobox.

string number = string.Empty;

If (combobox1.SelectedValue == null)
number = combobox1.Text;
else
number = combobox1.SelectedValue.ToString();

And that's exactly why after the selection from the drop down list, I only want a number and not the concatenated string of "Name, Number" to be in the number variable.

Re: About Combobox's ValueMember and DisplayMember

CKnig5-Dec-07 23:30

CKnig

5-Dec-07 23:30

then use

<br />
number = combobox1.Text.Substring(0,combobox1.Text.IndexOf(','));<br />

in the case where SelectedValue == null !

Re: About Combobox's ValueMember and DisplayMember

Zerox MXI6-Dec-07 3:10

Zerox MXI

6-Dec-07 3:10

Hmmm... never thought of that... I appreciate this... thanks a million.

how to export datagridview contents to excel

Nitin Raj5-Dec-07 19:56

Nitin Raj

5-Dec-07 19:56

I have to export the data present in the datagridview to Microsoft Excel. It is a window application using c#. Does anyone know how to do it. Please help.

Thanks

Re: how to export datagridview contents to excel

DKalepu5-Dec-07 22:49

DKalepu

5-Dec-07 22:49

Hi,

you can go through this link

http://nishantpant.wordpress.com/2006/11/02/exporting-data-to-excel-from-a-windows-forms-net-application/[^]

Regards.

Strength is life, Weakness is death.

--- Swami vivekananda

How To : coerce a ref to an enum into a ref to an int.

urbane.tiger5-Dec-07 18:59

urbane.tiger

5-Dec-07 18:59

I have a method in a common base class thus :

protected bool SetFlag(bool _new, ref int _flags, int _flag, string _pName)
{
bool __cancelled = false;
bool __old = ((_flags & _flag) == _flag);
if (!__old.Equals(_new)
{
if (!(__cancelled = this.RaisePropertyChanging(__old, _new, pName)))
{
_flags = (_new) ? _flags | _flag : _flags & ~flag;
this.RaisePropertyChanged(__old, _new, pName);
}
}
return __cancelled;
}

In derivatives of the common base I want to use SetFlags as is shown in the example at the end of this post, but I get a message telling me that it can't cast a ref to an AmbientState to an int etc.

If I give SetFlag a Type argument then I can only constrain it to a class(reference type) or struct(value type), but in that case I get compile errors stating that bitwise operations cannot be performed on T objects, ie structs.

The content of _flags (ambientState in the example) must be changed BEFORE PropertyChanged handlers are invoked.

I have a work-around - The _flags parameter is not passed by reference and I've added a delegate method argument to SetFlag that gets invoked between the "flags = ...." and the "this.RaisePropertyChanged...." statements, the delegate looks like

private void saveFlags(int _flags) { this.ambientState = (AmbientState) _flags; )

But like all workarounds its ugly and necessitates documenting why the delegate exists etc.

Rgds PhilD -- Sample usage of SetFlags follows

public class MyClass : CommonBase
{
AmbientState ambientState = AmbientState.ZeroValue;

public bool Morning
{
get { return ((this.ambientState & AmbientState.Morning) == AmbientState.Morning); }
set { this.SetFlag(value, (int) ref this.ambientState, AmbientState.Morning, "Morning"; }
}
[Flags]
private enum AmbientState : int
{
ZeroValue = 0x0

Morning = 0x1
Afternoon = 0x2
Evening = 0x4
Night = 0x8

ClearSky = 0x10
CirrusSky = 0x02
etc
}
}

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