|
tadhg88 wrote:
but when any of the three cells are null the entire name is returned as null
That is by design. Any operations you carry out on a NULL value will return NULL. You will have to manually extract each field from the DB, check if they are NULL in your C# program, and accordingly perform the concatenation.
HTH! 
Cheers,
Vikram.
http://www.geocities.com/vpunathambekar
Google talk: binarybandit After all is said and done, much is said and little is done.
|
|
|
|
|
IsNull[^]
You select becomes
select ISNULL(p.firstName,'') + ' ' + ISNULL(p.MiddleName,'') + ' ' + ISNULL(p.LastName,'') as Name
from ...
|
|
|
|
|
Hi
I want to set the File Access (e.g. FileAccess.Read
) attribute in my C# program. I found the System.IO.File.SetAttributes() Function but it seems not to be the right thing.
I also do not want to use the FileStream constructor.
Is there another way?
Thanks
|
|
|
|
|
Can you be more descriptive on what "it seems not to be the right thing" means? Keep in mind these are just access level permissions. NTFS will have another level that will alter the behavior.
|
|
|
|
|
I work with a file in my program. But I want to avoid that the file is modified outside of my application by another user. So I thought to make it write protected would be a solution. Do you have another recommendation?
Thanks!
|
|
|
|
|
Hi,
is there an example, how to download a (msi) file from a web-site (via http) to the local harddisk in C#?
Thanks!
Ariadne
|
|
|
|
|
Use HttpWebRequest[^] to issue the request for the MSI file, this will be returned in a HttpWebResponse[^] object. You can then stream the data to the local disk.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Thanks Colin,
I did this:
<br />
myReq=HttpWebRequest)WebRequest.Create("http://www.xyz.ch/file.msi");<br />
myResponse = myReq.GetResponse();<br />
ReceiveStream = myResponse.GetResponseStream();<br />
FileStream frStream = new FileStream(ReceiveStream, FileAccess.Read);<br />
FileStream fwStream = new FileStream(Application.StartupPath+"file.msi",FileMode.Create,FileAccess.Write);<br />
But this does not work: ReceiveStream is not System.IO.Stream
Ariadne
|
|
|
|
|
If I recall correctly, you need to pass the ResponseStream to a StreamReader. You can then read the contents of the stream to a byte array and then write the array that to your output file stream. The response stream will tell you how large you need to make the byte array (of course, you can always make it smaller and retrieve the information in chunchs by using multiple reads)
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Yes Colin, the canonical way works! thanks.
Ariadne
|
|
|
|
|
have you tried the WebClient class?
WebClient w = new WebClient();
w.DownloadFile(address_str,file_str);
//if you want to hold the file only in memory, try
// w.DownloadData() //for parameters check msdn
this is maybe a lot simpler than working with HttpWebRequest objects 
best regards
j.
|
|
|
|
|
Yes much more easy! thanks.
I now use this WebClient version
Ariadne
|
|
|
|
|
how do i remove the beggining of a string up to a forward slash "/"?
|
|
|
|
|
string newstring = oldstring.Substring(oldstring.IndexOf('/')+1);
What this basically does:
- find the index of the first occurence of '/' and take the next char (+1)
- take a substring from the original string beginning at the index right after the index of the first backslash
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Hi.
I have a textbox and it has been setup to look like a textarea.
When I type in text, something like:
AAAAAAAAAAAAAA
AAAAAAAAAAAAAA
BBBBBBBBBBBBBB
BBBBBBBBBBBBBB
CCCCCCCCCCCCCC
CCCCCCCCCCCCCC
I have an insert button and I add it the database. When I display it on a page, then it all looks like:
AAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCC
How do I code it so that it displays the break tags on the aspx page? In classic ASP I did it as follows:
Replace(objRs("Description"), Chr(10), Chr(10) & " <br>")
I just need to know how to do this in C#, or if there is a better way to do it.
Regards,
ma se
|
|
|
|
|
Use string.Replace()[^]
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
How do I get the ASP Chr(10) the same as in C#?
Regards
|
|
|
|
|
|
Hi everybody, I'm new here and I'm a newbye with C#. This is my problem. I have to build a class that can dynamically create an XML file where tags are chosen by user through a graphical interface.
Data to store in the XML file are car engine data. There are a table format dataset and some single variables such as oil temperature ecc. Has someone a tip to help me in this work?
Thank you
|
|
|
|
|
As most of your variables are in a table, you can store the table in a DataSet, and add the few single variables in a one-record-table in the same DataSet. The method for converting the two tables to XML is already part of the framework:
DataSet.WriteXml[^]
_________________________________
Please inform me about my English mistakes, as I'm still trying to learn your language!
|
|
|
|
|
First of all, thanks for your reply. I know how to bind a DataSet with a table stored in an XML file, but I have other problems. I have to build table in xml in the way the user wants, interactively (is it the correct word? ).
Then I have to show the table data in a datagrid, but I've to make possible only to change values already present and making impossible to add row and columns. Is it possible?
Thank you again for your help and sorry for my bad english.
|
|
|
|
|
Why can't you the XMLDocument[^] class? You could add remove node or attributes just as you like.
_________________________________
Please inform me about my English mistakes, as I'm still trying to learn your language!
|
|
|
|
|
Hi,
I am quite new with C# and I do not know how to do this, so if somebody could help me a bit.
I have data in datagrid, which i have selected from db. At first, I want to insert it again to database, not update. ( I want to save the original data ). How can I insert it? updating is quite simple but I do not know how to insert it.( I can not figure out how to refer to datagrids cells in insert statement. )
The data is from one table only, but has foreing keys in it.
Can anyone help me?
|
|
|
|
|
can anyone help me with next problem:
one window("conditional parent") opens another("conditional child") with show method. forms are independent. then c_child opens another window("modal dialog") with showdialog() and wait for user input. the problem is that c_parent locks too, whereas i need in to be still working. i know that its possible to do, cause when i open messageBox or OpenFileDialog with showDialog only child is being locked. any ideas how to implement that?
I know one solution - m_dialog should be opened with show, and assign handle to c_child.Activate event, but its inconvenient, couse i need to put call of m_dialog.show and handling results in different methods.
|
|
|
|
|
Is the parent form also locked, if you call the ShowDialog method with c_child as the owner window?
modal_window.ShowDialog(this);
_________________________________
Please inform me about my English mistakes, as I'm still trying to learn your language!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
