C# Discussion Boards - CodeProject

Re: how to retrieve a single value from datatable

Eddy Vluggen22-Jan-12 3:41

Eddy Vluggen

22-Jan-12 3:41

mschotamaster wrote:
sql2008

I have a table

Aight, first you'd need a Sql-statement to select the value you're interested in. Something like this

SQL

SELECT [connType]
  FROM [Login]
 WHERE [Id] = @Id

mschotamaster wrote:
i want to fetch connType value of the logged user to do like this

Open a

<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx">SqlConnection</a>[<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx" target="_blank" title="New Window">^</a>]

(using a correct connectionstring[^]), create a

<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx">SqlCommand</a>[<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx" target="_blank" title="New Window">^</a>]

, put the Sql-statement in the CommandText property, add the parameter, open the connection, and catch the result from the ExecuteScalar[^]-method.

Bastard Programmer from Hell Suspicious | :suss:

Re: how to retrieve a single value from datatable

mschotamaster22-Jan-12 3:48

mschotamaster

22-Jan-12 3:48

Yes that i want. thanks

Re: how to retrieve a single value from datatable

Eddy Vluggen22-Jan-12 3:49

Eddy Vluggen

22-Jan-12 3:49

My pleasure Smile | :)

Re: how to retrieve a single value from datatable

Luc Pattyn22-Jan-12 4:05

Luc Pattyn

22-Jan-12 4:05

if the user is logged in as you say, you must already have read the table to identify him, so you already know how to obtain data from a table.

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: how to retrieve a single value from datatable

Richard MacCutchan22-Jan-12 5:06

Richard MacCutchan

22-Jan-12 5:06

That's what I thought also.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

how made a factor i c#

Alireza_Nasr21-Jan-12 7:49

Alireza_Nasr

21-Jan-12 7:49

hi I have on the form a datagrid that user information is entered as a factor. Now I want to print the invoice. It is this good? Is how do I do?

Re: how made a factor i c#

Dave Kreskowiak21-Jan-12 14:11

Dave Kreskowiak

21-Jan-12 14:11

Your question made no sense at all as written. You haven't given any coherent details about what you've done, how you've done it or what your code is supposed to do beside print an invoice.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: how made a factor i c#

Nathan Stiles23-Jan-12 10:46

Nathan Stiles

23-Jan-12 10:46

http://www.stimulsoft.com/ReportsNet.aspx

Create XML file with C#

RivasBoy21-Jan-12 7:26

RivasBoy

21-Jan-12 7:26

I developed an application in C # where I have 4 text boxes and a datagrid with 4 columns and multiple rows and a button.

The button should generate an xml file.

I can create the xml file and write the data from text boxes, but not the DataGrid.

Anyone can help me?

At this moment i have this code:

In the button action

XmlTextWriter writer = new XmlTextWriter("teste.xml", Encoding.GetEncoding("ISO-8859-1"));
Writer.Formatting = Formatting.Indented;

// for the textboxes:

WriteStartElement("textbox1");
WriteElementString(textbox1.text);
WriteEndElement();
WriteStartElement("textbox2");
WriteElementString(textbox2.text);
WriteEndElement();
WriteStartElement("textbox3");
WriteElementString(textbox3.text);
WriteEndElement();
WriteStartElement("textbox4");
WriteElementString(textbox4.text);
WriteEndElement();
WriteStartElement("textbox4");
WriteElementString(textbox4.text);
WriteEndElement();

For the datadridview xml output strutured shoud be like this:

XML

<Tabela>
<Tabela-Linha numero="1">
<Id>01</id>
<Nome>Teste1</Nome>
<Cargo>xxx</Cargo>
<Extensao>500</Extensao>
</Tabela-Linha>
<Tabela-Linha numero="2">
<Id>02</id>
<Nome>teste2</Nome>
<Cargo>xxxx</Cargo>
<Extensao>501</Extensao>
</Tabela-Linha>
</Tabela>

Can anyone help me?

Re: Create XML file with C#

Eddy Vluggen21-Jan-12 11:24

Eddy Vluggen

21-Jan-12 11:24

How about foreaching the

<a href="http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.rows.aspx">Rows</a>[<a href="http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.rows.aspx" target="_blank" title="New Window">^</a>]

collection of the grid, writing the contents of all the

<a href="http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.columns.aspx">Columns</a>[<a href="http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.columns.aspx" target="_blank" title="New Window">^</a>]

using the method you already used?

object value = dataGridView1.Rows[RowIndex].Cells[ColumnIndex].Value;

Bastard Programmer from Hell Suspicious | :suss:

Re: Create XML file with C#

Nathan Stiles23-Jan-12 10:48

Nathan Stiles

23-Jan-12 10:48

How about using a serializable object as the datasource for the grid then serialize the object?

.NET Framework 4.0 and 2.0

MAW3020-Jan-12 11:23

MAW30

20-Jan-12 11:23

Does .NET Framework 4.0 have every thing in it that .NET Framework 2.0 has. If I have a program that worked on .Net Framework 2.0 will it necessarily work on .Net Framework 4.0.

Regards,
Michael

Re: .NET Framework 4.0 and 2.0

Richard Andrew x6420-Jan-12 11:54

Richard Andrew x64

20-Jan-12 11:54

Here's a link that addresses your concerns:

.NET Framework 4 Migration Issues[^]

The difficult we do right away...
...the impossible takes slightly longer.

Re: .NET Framework 4.0 and 2.0

jschell20-Jan-12 12:42

jschell

20-Jan-12 12:42

And to be safe you really need to fully test it.

Re: .NET Framework 4.0 and 2.0

Shameel20-Jan-12 18:57

Shameel

20-Jan-12 18:57

Microsoft has a very good track record when it comes to backward compatibility. So, it must work barring some minor issues. Check the link in the first answer for known issues.

Re: .NET Framework 4.0 and 2.0

PIEBALDconsult21-Jan-12 3:12

PIEBALDconsult

21-Jan-12 3:12

Mostly, but some things have been obsolesced, which makes developing for multiple versions difficult.

One example:

            Reader = new System.Xml.XmlReaderSettings() 
            {
                ValidationType = System.Xml.ValidationType.Schema
            ,
# if DotNet_2_0 || DotNet_3_0 || DotNet_3_5
                ProhibitDtd = false
# endif

# if DotNet_4_0
                DtdProcessing = System.Xml.DtdProcessing.Parse
# endif
            ,
                XmlResolver = new System.Xml.XmlUrlResolver()
                {
                    Credentials = System.Net.CredentialCache.DefaultNetworkCredentials
                }
            } ;

And unfortunately there are no built-in macroes defined for the version so you have to define your own. Mad | :mad:

Size Image in PictureBox

Steve Harp20-Jan-12 9:40

Steve Harp

20-Jan-12 9:40

Hi Guys,

I have a PictureBox control in a WinForms application where I need to display the image at the maximum height allowable by the screen size without changing the image's height to width relationship.

The Picture box is docked to the right of the form. Setting the image height is easy enough but calculating the width is problematic as screen pixels aren't square.

How can I calculate the width with the image displayed to it's maximum height without distorting the image? I don't know the actual screen measurements; only the resolution.

Thanks......

Re: Size Image in PictureBox

Dave Kreskowiak20-Jan-12 10:29

Dave Kreskowiak

20-Jan-12 10:29

Have you tried setting the PictureBox's SizeMode property to Zoom??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Size Image in PictureBox

Richard MacCutchan20-Jan-12 22:06

Richard MacCutchan

20-Jan-12 22:06

I don't think you can unless the height to width ratio of the picture box exactly matches that of the image. Your resulting image will either be distorted or too wide/narrow for the picture box. This article[^] explains the issue and offers a solution which may help you; the code is C++ but should be easy to understand.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: Size Image in PictureBox

Luc Pattyn20-Jan-12 22:41

Luc Pattyn

20-Jan-12 22:41

PictureBoxSizeMode.Zoom will perform an isotropic rescale such that the image fits one or both dimensions of the PB without clipping.
MSDN explains it rather well here[^].

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: Size Image in PictureBox

Richard MacCutchan20-Jan-12 23:04

Richard MacCutchan

20-Jan-12 23:04

Thanks; isn't it just so easy in C#?

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: Size Image in PictureBox

Steve Harp23-Jan-12 5:33

Steve Harp

23-Jan-12 5:33

Thanks. The solution shown in the C++ article shows how to size the image and then it's just a matter of setting the PictureBox ClientSize to the image size. This seems to size the image correctly and maintains the ratio.

Re: Size Image in PictureBox

Richard MacCutchan23-Jan-12 6:35

Richard MacCutchan

23-Jan-12 6:35

And, as Luc pointed out above, the PictureBox looks after things automatically.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: Size Image in PictureBox

Luc Pattyn23-Jan-12 16:07

Luc Pattyn

23-Jan-12 16:07

Yeah, it's about the only useful feature it offers.
I can't understand why people insist on painting on top of a PB, then find it difficult to correlate mouse location with picture pixels.

Big Grin | :-D

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: Size Image in PictureBox

Richard MacCutchan23-Jan-12 23:07

Richard MacCutchan

23-Jan-12 23:07

Probably because they don't make proper use of the documentation.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

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