Re: how to retrieve a single value from datatable - C# Discussion Boards

21-Jan-12 22:01

winforms sql2008
I have a table

SQL

Login(id(int),EmailId(varchar(35),connType(varchar))

where conntype has values like pop3 or imap. consider an user is loggedin. i want to fetch connType value of the logged user to do like this

SQL

if(conntypeValue == imap)
{
 //code for imap connection
}else
{
//code for pop3 connection
}

how can i do it

modified 22-Jan-12 4:10am.

Richard MacCutchan21-Jan-12 23:01

21-Jan-12 23:01

//code for imap connection

What exactly are you trying to do in here?

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

mschotamaster22-Jan-12 3:12

22-Jan-12 3:12

that code has been done. just i want to retrieve the single value from the table

Richard MacCutchan22-Jan-12 3:15

22-Jan-12 3:15

What value? What table? You need to provide some more details about your problem.

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

mschotamaster22-Jan-12 3:17

22-Jan-12 3:17

winforms sql2008
I have a table

Login(id(int),EmailId(varchar(35),connType(varchar))

where conntype has values like pop3 or imap. consider an user is loggedin. i want to fetch connType value of the logged user to do like this

if(conntypeValue == imap)
{
//code for imap connection
}else
{
//code for pop3 connection
}

how can i do it

i want to fetch connType column value from the table login where id = userid

Richard MacCutchan22-Jan-12 3:23

22-Jan-12 3:23

Brilliant! I asked you to explain your problem in more detail and you have just repeated your original question.

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

mschotamaster22-Jan-12 3:38

22-Jan-12 3:38

I want to connect with pop3 server or imap server on the basis of the account configured by the user. that account values are in the login table. when the user logged in. i want to fetch the value from the login table column servertype. if that value is pop3 the code of pop3 server connectivity will run.

Nathan Stiles23-Jan-12 10:45

Nathan Stiles

23-Jan-12 10:45

Login(id(int),EmailId(varchar(35),connType(varchar))

execute a scalar
select connType from Login where id = 5
or
select connType from EmailId where id = 'noone@example.com'

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:

mschotamaster22-Jan-12 3:48

22-Jan-12 3:48

Yes that i want. thanks

Eddy Vluggen22-Jan-12 3:49

Eddy Vluggen

22-Jan-12 3:49

My pleasure Smile | :)

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

Richard MacCutchan22-Jan-12 5:06

Re: how made a factor i c#

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?

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

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.

jschell20-Jan-12 12:42

jschell

20-Jan-12 12:42

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

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.