|
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
|
|
|
|
|
that code has been done. just i want to retrieve the single value from the table
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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'
|
|
|
|
|
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
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 
|
|
|
|
|
|
My pleasure 
|
|
|
|
|
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.
|
|
|
|
|
That's what I thought also.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
http://www.stimulsoft.com/ReportsNet.aspx
|
|
|
|
|
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:
<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?
|
|
|
|
|
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 
|
|
|
|
|
How about using a serializable object as the datasource for the grid then serialize the object?
|
|
|
|
|
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
|
|
|
|
|
|
And to be safe you really need to fully test it.
|
|
|
|
|
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.
|
|
|
|
|
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. 
|
|
|
|
|
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......
|
|
|
|
|
Have you tried setting the PictureBox's SizeMode property to Zoom??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
