How to Join Two Table in Dataset and show in Gridview Joined Both Tables... - C# Discussion Boards

24-Nov-09 20:18

Hi, I have a decimal number. I need to convert this decimal value to exponential value. I have a vb.net code to convert from decimal to exponential value is Format(100000, #.0#E-##) . When I run this code in vb.net it returns 1.0E5

I need the same expression for the c#.
I am using the following code String.Format("{0:E}", 100000) and its returns 1.000000E+005, but I need 1.0E5. The same for the another value String.Format("{0:E}", 0.000597), I need 5.97E-4 but it is returning 5.970000E-004. Does anyone let me know the right expression Confused | :confused:

Pankaj

dan!sh 24-Nov-09 21:53

dan!sh

24-Nov-09 21:53

Use string.Format("{0:0.0E+00}", 1000000);.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Pankaj Saha24-Nov-09 23:35

24-Nov-09 23:35

Thanks for your replay. When I run

string.Format("{0:0.0E+00}", 0.000597);
its return 6E-04 but I need 5.97E-4. I do not want to round the number.

Pankaj

Pankaj Saha24-Nov-09 23:56

24-Nov-09 23:56

I have done some small changed in the expression and got the near of correct result

string.Format("{0:0.0E2}", 0.000597);

then its returns 5.97E-004. Can we remove 00 after the E ?

Pankaj

Pankaj Saha25-Nov-09 0:33

How to Join Two Table in Dataset and show in Gridview Joined Both Tables...

25-Nov-09 0:33

Got one solution

string.Format("{0:#.0#E-00}", 1000000);

Pankaj

Shaik Haneef24-Nov-09 20:08

Shaik Haneef

24-Nov-09 20:08

I have two table Employee and EmployeeAddress and Both Cotain ID filed with integer, I want to Join both in DataSet How can i do it ???

select * from Employee, EmployeeAddress where Employee.ID= EmployeeAddress.ID

I want to do the the above sql operation in my Dataset & need to display in girdview

My Dataset Contain two Table one is for Results of Employee another table contains details of EmployeeAddress. How can Provide First Table as Primary and Second Table as Forign Key

I tried that

Dataset objds=new Dataset();
......
......

//Analyse that Dataset contain two tables of data now then How can I provide relation and need to give to Gridview

objds.Relations.Add("Relation",objds.Tables[0].Column["ID"],objds.Tables[1].Column["ID"]);

Gridview1.Datasource = objds;
Gridview1.DataBind();

But it showing only First Table Data only I want to Join both tables as one and need to show in Gridview How can do It ?

Regars,
Shaik Haneef
sk.haneef@gmail.com

Re: How to Join Two Table in Dataset and show in Gridview Joined Both Tables...

dojohansen25-Nov-09 1:17

dojohansen

25-Nov-09 1:17

I don't think the GridView supports this, but you can try adding databound columns at design-time, this might permit you to bind some columns to the first table and some to the second. I doubt it tho.

Re: How to Join Two Table in Dataset and show in Gridview Joined Both Tables...

Mycroft Holmes25-Nov-09 3:06

Mycroft Holmes

25-Nov-09 3:06

Make sure that ID refers to the correct ID in both tables, on if then will be the ID for address and the other will be the ID for the customer. There should be a CustomerID on the address table!

You need to have done some study during your course, surely!

Never underestimate the power of human stupidity
RAH

Re: How to Join Two Table in Dataset and show in Gridview Joined Both Tables...

Gerry Schmitz25-Nov-09 3:20

Gerry Schmitz

25-Nov-09 3:20

Use LINQ to DataSet to query and join the 2 tables. The query result can be bound to the Grid or used to create a new DataTable for binding to.

Serial Port Communication

Sifar - 024-Nov-09 18:51

Sifar - 0

24-Nov-09 18:51

Hi All,

I have an appliation that communicates with a hardware device attahced with the system. So far, the device had been attached using USB so the application was determining the PORT using Port Name.

Now, the newer device have 9-pin serial port. How can I now determine the Port number? I don't want to iterate through all the ports and send any command and analyse the response to determine the required Port.

Any suggestion or hint would be greatly helpful...

Regards,
-SIFAR.

Re: Serial Port Communication

TAFIN24-Nov-09 20:46

TAFIN

24-Nov-09 20:46

use class "serialport".

SerialPort serialport1 = new SerialPort();

use this class and using this obj u can read port no....
ok.

TANIM
TAFIN Thumbs Up | :thumbsup:

Re: Serial Port Communication

Sifar - 024-Nov-09 22:13

Sifar - 0

24-Nov-09 22:13

Thanks TAFIN.

I am aware about that class. My problem is how to determine the exact Port Number to which the device is attached without iterating through all the ports.

Regards,
-SIFAR.

Re: Serial Port Communication

Gideon Engelberth25-Nov-09 2:51

Gideon Engelberth

25-Nov-09 2:51

There really is no way to determine that without iterating. Unless you make the user pick the port manually.

adding column in a listview

TAFIN24-Nov-09 18:20

TAFIN

24-Nov-09 18:20

hey!!
im in a prob.i am trying to add some column and items in a list view.
but cant add a column even.Here is a code snippet. i am novice in C#. plz help.
Thanks in advance.

TANIM
Bangladesh

private void Form1_Load(object sender, EventArgs e)
        {
            
            ColumnHeader columnHeader1 = new ColumnHeader();
            //columnHeader1.Text = "TANIM";
            listView1.Columns.Add(columnHeader1);
            //listView1.Columns.Add("TANIM", -2, HorizontalAlignment.Left);
            
           
        }

Abhijit Jana24-Nov-09 18:35

Abhijit Jana

24-Nov-09 18:35

Try This

listView1.View = View.Details;
listView1.Columns.Add("Column Name", 50, HorizontalAlignment.Left);

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Mycroft Holmes24-Nov-09 18:40

Mycroft Holmes

24-Nov-09 18:40

Along with Abhijits answer you need to be aware that the SubItems need to be added for each item. It is possible to have say 5 columns and only 3 subitems for an item. The missing subitems are null and may generate an exception.

TAFIN24-Nov-09 20:38

TAFIN

24-Nov-09 20:38

Thanks!!!

carlecomm26-Nov-09 14:29

carlecomm

26-Nov-09 14:29

Give this a try:

ListViewItem lst1 = new ListViewItem(str, 0);
listView1.Items.Add(lst1);

modified 27-May-14 5:11am.

Remembering Variables

johntwebb24-Nov-09 17:34

johntwebb

24-Nov-09 17:34

Hi, I have a program that opens an option form. For the options someone can basically list prices for various objects. I need to know how these prices can be remembered even after the program is shut down. I don't want to keep having to set the prices every time I run the program. Right now, I have a class which takes the prices and multiplies that by the quantity of an item. In that class I have static decimals. In the option form's button click I save a value to the class's static variables. Then I call those from the main form.

Thanks for your help!

PIEBALDconsult24-Nov-09 17:56

PIEBALDconsult

24-Nov-09 17:56

I hear there's this new thing called a database... Roll eyes | :rolleyes:

(If the number of "objects" is small and steady, perhaps an XML file will suffice.)

Abhijit Jana24-Nov-09 18:04

Abhijit Jana

24-Nov-09 18:04

You can store it in any storage location like DataBase, TextFile . When program is restarting read the content from the storage location.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

johntwebb24-Nov-09 18:24

johntwebb

24-Nov-09 18:24

Yeah, I pretty much feel like an idiot. I use a database for my asp.net apps, but for some reason it never occurred to me to use it for a windows form app. Anyway, thanks for the answer.