The type of a linq request - C# Discussion Boards

Re: file can be write on XP but can not on VISTA

Richard MacCutchan30-Sep-09 3:05

Richard MacCutchan

30-Sep-09 3:05

khosnur wrote:
i can write a file in the any drive of XP operating System but i can not on vista.

I just tried this on Windows 7 and it worked fine. Have you run it through the debugger to check the value of Application.StartupPath?

CD Burning in VISTA

Edward Topalian30-Sep-09 0:39

Edward Topalian

30-Sep-09 0:39

Hello there,
i'm trying to create a program that copies some files to the CD BLANK area.
i created the program working For Windows XP, but in Vista it is not working/
can anyone help me in that
thanks in advance

Re: CD Burning in VISTA

Christian Graus30-Sep-09 0:43

Christian Graus

30-Sep-09 0:43

There was a component called XPBurn, which worked in XP. If it's not supported in Vista, then you need to search the web for samples in Vista, assuming it's even possible in Vista.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: CD Burning in VISTA [modified]

User 21559730-Sep-09 0:57

User 215597

30-Sep-09 0:57

Using Image mastering API[^] might be help. If I am not wrong there was an article on CP about using IMAPIv2

Sohail

modified on Wednesday, September 30, 2009 8:50 AM

modified 21-Apr-21 21:01pm.

Crystal report color

antala30-Sep-09 0:27

antala

30-Sep-09 0:27

Hi.
I saved color in Mssql datatable from C# colordialog (colordialog.color.toArgb() & 0xFFFFFF )and i put the result in crystal report color formula but the result is not the color what i choose in colordialog window.
Why ? What's wrong ?
Excuse me for my English
THX.

Re: Crystal report color

Christian Graus30-Sep-09 0:42

Christian Graus

30-Sep-09 0:42

C# colors are ARGB, might Crystal Reports use RGB or BGR ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Find MIN value in binding?

kanchoette30-Sep-09 0:02

kanchoette

30-Sep-09 0:02

If I want to locate the minimum value for a column in a datatable I would use something like:

int minArrangementID = (int) debtorDataSet.PaymentArrangements.Compute("MIN(PaymentArrangementID)", "PaymentArrangementID > 0");

How can I find the minimum value within a binding please?

The type of a linq request

teycir29-Sep-09 23:50

teycir

29-Sep-09 23:50

Hi;
I'm calling stored procedures using linq to sql to fill comboboxes from a database.
I have the method ConnectFilter() above that i want to refactor.
I started refactoring using FillComboWithData(ComboBox combo, string value, string display, DataClassesReferentielDataContext dc, XXXXX) above.
DataClassesReferentielDataContext is the Linq datacontext, it contains all the database mapped into objects.
By the way the stored procedures call many fields of many tables.
Here an example of a stored proc: P_ESS_Categorie_BIS.
I don't know how to enter the stored procedure as an argument (in place of XXXXX).
I think the argument should be an enumerable.
Thanks.

private DataClassesReferentielDataContext _dc = new DataClassesReferentielDataContext();
// The method I want to refactor
 private void ConnectFilter()
        {
            comboBoxCountryFilter.DataSource = _dc.P_ESS_Entite();
            comboBoxCountryFilter.ValueMember = "PAY_Code";
            comboBoxCountryFilter.DisplayMember = "PAY_Libelle";
            var statut = from s in _dc.TR_Statuts select s;
            comboBoxStatusFilter.DataSource = statut.ToArray();
            comboBoxStatusFilter.ValueMember = "STA_ID";
            comboBoxStatusFilter.DisplayMember = "STA_Libelle";
            comboBoxCategoryFilter.DataSource = _dc.P_ESS_Categorie_BIS((int) Selections.VueRefId);
            comboBoxCategoryFilter.ValueMember = "CAT_Code";
            comboBoxCategoryFilter.DisplayMember = "CAT_Libelle";
            comboBoxItPlanFilter.DataSource = _dc.P_ESS_ITPlan_BIS((int) Selections.VueRefId);
            comboBoxItPlanFilter.ValueMember = "ITP_Code";
            comboBoxItPlanFilter.DisplayMember = "ITP_Libelle";
            comboBoxGroupFilter.DataSource = _dc.P_ESS_GroupeProjet_BIS((int) Selections.VueRefId);
            comboBoxGroupFilter.ValueMember = "GRP_Code";
            comboBoxGroupFilter.DisplayMember = "GRP_Libelle";
            comboBoxSponsorFilter.DataSource = _dc.P_ESS_Sponsor_BIS((int) Selections.VueRefId);
            comboBoxSponsorFilter.ValueMember = "SPO_Code";
            comboBoxSponsorFilter.DisplayMember = "SPO_Libelle";
            comboBoxThemaFilter.DataSource = _dc.P_ESS_ThematiqueProjet_BIS((int) Selections.VueRefId);
            comboBoxThemaFilter.ValueMember = "THE_Code";
            comboBoxThemaFilter.DisplayMember = "THE_Libelle";
            comboBoxPersonFilter.DataSource = _dc.P_TR_Personne_Liste_Filtre();
            comboBoxPersonFilter.ValueMember = "PER_ID";
            comboBoxPersonFilter.DisplayMember = "PER_NomUT";
        }
 
 
// The refactoring
  private void FillComboWithData(ComboBox combo, string value, string display, DataClassesReferentielDataContext dc, XXXXX)
        {
            combo.DataSource = _dc.P_ESS_NatureProjet_BIS((int)Selections.VueRefId); // The proc call i want to enter as an argument of FillComboWithData
            combo.ValueMember = value.Trim();
            combo.DisplayMember = display.Trim();
        }

ALTER PROCEDURE  [dbo].[P_ESS_Categorie_BIS]  
	 @Vue_Referentiel numeric(10,0)
AS
BEGIN
 
SELECT [CAT_Code]
      ,[CAT_Libelle]
  FROM [TR_Categorie] 
WHERE     ([TR_Categorie].VUR_Id = @Vue_Referentiel) 
order by [CAT_Libelle]
END

Go to line !

amir-haghighi29-Sep-09 23:27

amir-haghighi

29-Sep-09 23:27

Hi . I can not good speak english . if in vs 2008 pressed ctrl + G keys and insert line number and click ok button , mouse cursor to go in the that line number . how go to line in richtextbox in my program ?

Re: Go to line !

Christian Graus30-Sep-09 0:37

Christian Graus

30-Sep-09 0:37

amir-haghighi wrote:
. I can not good speak english . i

That's fine. I'm sure whatever language you speak natively, I can't speak as well as you speak English.

amir-haghighi wrote:
how go to line in richtextbox in my program ?

You can't, because the line numbers no longer exist when your code is compiled, the code does not exist in remotely the form you created it at that time. Also, it's not possible to jump execution to a random spot in the code, even the VS debugger cannot do that, it can only jump within the current method, and within the current try block. What you're asking is basically impossible, there is no chance of you being able to do it.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Go to line !

Henry Minute30-Sep-09 0:45

Henry Minute

30-Sep-09 0:45

Take a look at the answer in this[^] thread on MSDN.

If you ignore the bit about selecting the RichTextBox from a Tab, you should be able to work it out.

[Edit]
Just found this code:

public void GoToLineAndColumn(int Line, int Column)
{
    Cursor.Current = Cursors.WaitCursor;

    int Offset = 0;
    int i = 0;

    foreach (String L in Lines)
    {
        if (i < Line - 1)
        {
            Offset += L.Length + 1;
        }
        else
        {
            break;
        }

        i++;
    }

    Select(Offset + Column - 1, 0);

    Cursor.Current = Cursors.Arrow;
}

Lines is RichTextBox.Lines property

You might also need the ScrollToCaret method, as I cannot remember if the Select(int, int) automatically brings it into view.
[/Edit]

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Textbox input validation

teknolog12329-Sep-09 23:18

teknolog123

29-Sep-09 23:18

Hi all,
Could someone please tell me how to write code for the below situation?

When entering numbers into a text box
input 126 => output 1,26
input 1234 => output 12,34

It shouldn't accept letters and should allow me to leave textbox empty

Thanks in advance

Re: Textbox input validation

stancrm29-Sep-09 23:24

stancrm

29-Sep-09 23:24

http://en.csharp-online.net/MaskedTextBox[^]

Re: Textbox input validation

teknolog12329-Sep-09 23:58

teknolog123

29-Sep-09 23:58

As I only seek for a simple validation, I thought I could have a piece of code instead of using a custom control.

I'm sure it is a valuable reference for future needs. Thanks anyway
I still need a simple code to do it

Re: Textbox input validation

Calla30-Sep-09 2:34

Calla

30-Sep-09 2:34

Use the KeyUp Event to validate what's written in the TextBox and then alter the text.
But you'll have to write the code for it yourself.. Hmmm | :|

How to create a Zip Folder with C#.Net

Rahad Rahman29-Sep-09 23:06

Rahad Rahman

29-Sep-09 23:06

i have a folder which name is Test in D: Drive , now want create Test.zip ,How it Posible

Re: How to create a Zip Folder with C#.Net

stancrm29-Sep-09 23:21

stancrm

29-Sep-09 23:21

Use a

http://www.icsharpcode.net/OpenSource/SharpZipLib/[^]

Re: How to create a Zip Folder with C#.Net

Paramhans Dubey29-Sep-09 23:26

Paramhans Dubey

29-Sep-09 23:26

Hi,
You can use System.IO.Compression namespace to do that. You can find lot of help on msdn site for that.

Regards,
Paramhans Dubey

Re: How to create a Zip Folder with C#.Net

Paramhans Dubey29-Sep-09 23:27

Paramhans Dubey

29-Sep-09 23:27

Have a look at this

Compress Zip files with Windows Shell API and C#[^]

How to stop MSSQL database server with C#.net

Rahad Rahman29-Sep-09 22:39

Rahad Rahman

29-Sep-09 22:39

How to stop MSSQL database server with C#.net

Re: How to stop MSSQL database server with C#.net

Manas Bhardwaj29-Sep-09 22:44

Manas Bhardwaj

29-Sep-09 22:44

Check this[^].

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: How to stop MSSQL database server with C#.net

Mirko198029-Sep-09 22:44

Mirko1980

29-Sep-09 22:44

You can use the ServiceController class to do this.

socket over the internet?

Tridip Bhattacharjee29-Sep-09 22:34

Tridip Bhattacharjee

29-Sep-09 22:34

can anyone please tell me that how two machines can communicate with each other over the internet with socket programming.
i know it is possible by webservice but i want to know that how to communicate over the internet with socket programming.
if possible then please give me a small sample code.

thanks in advance.

tbhattacharjee

Re: socket over the internet?

SeMartens29-Sep-09 22:37

SeMartens

29-Sep-09 22:37

Hi,

have a look here:

Sockets in C#[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Retrieve timetable from website to send out as SMS

sheateng29-Sep-09 21:54

sheateng

29-Sep-09 21:54

I need help on how to get the timetable from this website so that I can arrange it to send it out in SMS format.

http://utptt-ex.petronas.com.my/Reporting/Individual?identifier=8182&B1=View+Timetable&objectclass=students&idtype=id&width=100&periods=1-30">

My project can retrieve the XML from the website, but I don't know how to get the input because it's in table format.

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