C# Discussion Boards - CodeProject

DataGrid showing multiple columns in C# 2003 [modified]

4-Jul-09 2:45

You can look at something like Substring[^]

User group: Scottish Developers
Blog: Can Open... Worms? Everywhere!
Quote: Man who stand on hill with mouth open wait long time for roast duck to drop in.

Viper-Eyes4-Jul-09 2:08

Viper-Eyes

4-Jul-09 2:08

Hello Guys :

i really in a deep trouble an tried many way to solve it but couldn't find a solution.

1st am getting my data from xml file....when my application load the dataset reads the data from the xml file.

in the xml file i have two tables : (Product) and (ProductInfo)

tables product consist of (ID"Pk",Type).
and productInfo consist of (ID,Description,Brand,PructType"Fk").

there is a relation between those two tables.

now the problem is i want to show the table (ProductInfo) in the Daragrid but get the type from the Product Table.in other words i want to show coulmns from multiple tables in 1 Datagrid and in 1 view through the relation.i mean i want the Datagrid to view (ID,Description,Brand,Type)
the first 3 from ProductInfoTable an the last one from the Product table.

to be exact i want to do something like the "JOIN" function in SQL Server.

i did that before but i was using SQL Server Database and made View and selected teh coulmns i needed from different tables and the view were like another new table but with the two tables data....and i selected the datasource infor my datagrid that View and with table styles i hid what i wanted to hid.but even now tablestyles not working.....any help or idea will be apprciated.

modified on Saturday, July 4, 2009 8:21 AM

Http Header code (example 200,404,..)

Nafiseh Salmani3-Jul-09 22:33

Nafiseh Salmani

3-Jul-09 22:33

I want to determine HTTP header code of a URL by C# code. How could I get that?

I use the following code :

<br />
public Dictionary<string, string> GetHTTPResponseHeaders(string Url)<br />
        {<br />
            Dictionary<string, string> HeaderList = new Dictionary<string, string>();<br />
<br />
            WebRequest WebRequestObject = HttpWebRequest.Create(Url);<br />
            WebResponse ResponseObject = WebRequestObject.GetResponse();<br />
<br />
            foreach (string HeaderKey in ResponseObject.Headers)<br />
            {<br />
                HeaderList.Add(HeaderKey, ResponseObject.Headers[HeaderKey]);<br />
                textBox1.Text += HeaderKey + ": " + ResponseObject.Headers[HeaderKey]+"      " ;<br />
            }<br />
            ResponseObject.Close();<br />
<br />
            return HeaderList;<br />
}<br />

but It does not contain of HTTP header Code!

Colin Angus Mackay4-Jul-09 1:08

4-Jul-09 1:08

Nafiseh Salmani wrote:
WebResponse ResponseObject = WebRequestObject.GetResponse();

This should be cast to an HttpWebResponse if the Url you are passing uses HTTP or HTPS as the protocol.

HttpWebResponse responseObject = (HttpWebResponse)WebRequestObject.GetResponse();

You will then find a StatusCode property which contains the detail you want.

User group: Scottish Developers
Blog: Can Open... Worms? Everywhere!
Quote: Man who stand on hill with mouth open wait long time for roast duck to drop in.

Nafiseh Salmani4-Jul-09 1:36

Nafiseh Salmani

4-Jul-09 1:36

Thanks! But it just determine "OK" not the code!! I need the code number exactly!!

How could I get code number?!!!!

Henry Minute4-Jul-09 1:46

Henry Minute

4-Jul-09 1:46

Read the documentation!! here[^]

StatusCode is an enumeration, 'OK' = 200. Just write yourself a method to return a string of the numbers based on the value of StatusCode.

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.”

Colin Angus Mackay4-Jul-09 2:18

4-Jul-09 2:18

Henry Minute wrote:
Read the documentation!! here[^]

Documentation has a use? I thought it was just a jolly for technical writers to get paid to do something no one reads! Wow! Didn't I learn something today. Roll eyes | :rolleyes:

User group: Scottish Developers
Blog: Can Open... Worms? Everywhere!
Quote: Man who stand on hill with mouth open wait long time for roast duck to drop in.

Henry Minute4-Jul-09 3:28

Henry Minute

4-Jul-09 3:28

Of course, I don't use it myself...... Big Grin | :-D

Nafiseh Salmani4-Jul-09 4:17

Nafiseh Salmani

4-Jul-09 4:17

Thanks alot of both of you!! Smile | :)

I would try to read documentation carefully before asking something like this. WTF | :WTF:

Get Error Number in C#

Anubhava Dimri3-Jul-09 22:19

3-Jul-09 22:19

Hi All,
How can i get the error number in c#.

If you can think then I Can.

DaveyM693-Jul-09 22:37

DaveyM69

3-Jul-09 22:37

Error number of what?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Anubhava Dimri4-Jul-09 1:33

4-Jul-09 1:33

IN VB WE CAN CHECK ERROR NO. BY USING

ON ERROR GOTO ERR
ERR:
MSGBOX (ERR.NUMBER)

NOW HOW CAN IT POSSIBLE IN C#

If you can think then I Can.

Colin Angus Mackay4-Jul-09 2:31

4-Jul-09 2:31

STOP SHOUTING - It is rude!

User group: Scottish Developers
Blog: Can Open... Worms? Everywhere!
Quote: Man who stand on hill with mouth open wait long time for roast duck to drop in.

Anubhava Dimri4-Jul-09 2:37

4-Jul-09 2:37

ok colin

If you can think then I Can.

DaveyM694-Jul-09 5:09

DaveyM69

4-Jul-09 5:09

In C# we do this by putting the code below where the On Error Goto would be inside a try block. The Err label is replaced by catch block(s). In addition we have an optional finally block that is run after either have completed:

try
{
    // code that may throw an exception
}
catch(Exception ex)
{
   // an exception is now in ex so you can examine this to get details,
   // show detailed MessageBox etc...
}
finally
{
   // this will run regardless of whether an exception was thrown or not.
   // useful to close/dispose of objects etc...
}

More details here[^].

Henry Minute4-Jul-09 0:00

Henry Minute

4-Jul-09 0:00

Which error do you want the number for? I've had most of them in my time, so I might be able to let you have it.

OriginalGriff4-Jul-09 0:42

OriginalGriff

4-Jul-09 0:42

Just give him a copy (they aren't DRM after all). You might need it again - I know I will need mine! Laugh | :laugh:

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Anubhava Dimri4-Jul-09 1:34

4-Jul-09 1:34

MY REPLY IS POSTED PLEASE CHECK

If you can think then I Can.

Colin Angus Mackay4-Jul-09 2:33

4-Jul-09 2:33

THERE'S NO NEED TO SHOUT - WE CAN HEAR YOU FINE. It is also rude to use all caps.

User group: Scottish Developers
Blog: Can Open... Worms? Everywhere!
Quote: Man who stand on hill with mouth open wait long time for roast duck to drop in.

0x3c04-Jul-09 0:46

0x3c0

4-Jul-09 0:46

Have you tried looking at the GetLastError API method? I think that there's a managed wrapper around that which may help (Marshal.GetLastWin32Error I think)

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Anubhava Dimri4-Jul-09 1:37