Re: Somewhat embarrassed: how do I get the dotnet framework? - C# Discussion Boards

Vijay Kanda8-Dec-12 14:08

8-Dec-12 14:08

I am creating a REST Service project (just for learning purpose) and using Bing Map... This is what I want to accomplish...I am sending my current location (Latitude and longitude) to the service and I want to find out all the nearest Mac Donalds (for example) within 1 mile range from my current location and the distance and the time it will take me to get each Mac Donalds... I know there are BING MAP APIs which I can use to accomplish ...
But I never used BING map or rest service before... so can anyone please tell me the Bing Map method/API names which take latitude and longitude as argument and retrun the info that I mentioned above.

Thanks.

Re: Using Bing map or google geocoder

Simon_Whale8-Dec-12 23:43

Simon_Whale

8-Dec-12 23:43

Have a look at Sacha Barber's his zombie article covers most of what you are after.

You can find the article here on CP. I would post a link but I'm writing this on a phone

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Re: Using Bing map or google geocoder

Vijay Kanda9-Dec-12 10:30

Vijay Kanda

9-Dec-12 10:30

Simon,
Thanks... really appreciate it... I could not find the article which you mentioned... please let me know the url when you have a chance...

Thanks again.

Re: Using Bing map or google geocoder

Simon_Whale9-Dec-12 12:07

Simon_Whale

9-Dec-12 12:07

Zombie Explorer : A N-Tier application from top to bottom[^]

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Somewhat embarrassed: how do I get the dotnet framework?

Septimus Hedgehog8-Dec-12 0:11

Septimus Hedgehog

8-Dec-12 0:11

Guys,

Create a console application. Select the project name in the solution explorer and Alt-Enter or right-click the properties and select the Application tab. Change the Target Framework to say 3.5 or something else other than 2.0. Paste this line into the Main method:

Console.WriteLine("Version=" + Assembly.GetExecutingAssembly().ImageRuntimeVersion);

and run it. I was sort of expecting to see it display the target framework I selected. Instead it displays v.2.0.50727 even though my target framework was set to 3.5. Obviously, I've misunderstood that line of code. Does anyone know what I can do to get the target version I selected? I don't want to do anything as a result of getting it so I just want to display it. Blush | :O

"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).

Re: Somewhat embarrassed: how do I get the dotnet framework?

OriginalGriff8-Dec-12 1:54

OriginalGriff

8-Dec-12 1:54

Odd. I pasted your code into my app, and it gave me

Version=v4.0.30319

Which is what I would expect for a V4.0 C# app.

Are you sure you compiled and ran the right version?
Have you tried a full rebuild?

If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.

Re: Somewhat embarrassed: how do I get the dotnet framework?

Septimus Hedgehog8-Dec-12 9:31

Septimus Hedgehog

8-Dec-12 9:31

OG, I did indeed a clean and a full rebuild. Eddy Vluggen's reply after yours might well be the thing that decides what gets returned. I'll rebuild it in VS2012 and see what pops out of the woodwork as my VS2008 only lists upto 3.5.

"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).

Re: Somewhat embarrassed: how do I get the dotnet framework?

Eddy Vluggen8-Dec-12 2:44

Eddy Vluggen

8-Dec-12 2:44

PHS241 wrote:
Instead it displays v.2.0.50727 even though my target framework was set to 3.5.

.NET 2.0 would report the 2.0 framework, but 3.0 and 3.5 are "extensions" to the 2.0 runtime. 4.0 has a new runtime again, so that will report back version 4.

--edit;
There's a distinction between the target-framework, and the supported runtime. If it's a desktop-application, than you'll have an app.config file in there, and an "appname.exe.config" file in your Debug folder.

See MSDN[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

modified 8-Dec-12 11:40am.

Re: Somewhat embarrassed: how do I get the dotnet framework?

Septimus Hedgehog8-Dec-12 9:33

Septimus Hedgehog

8-Dec-12 9:33

Thanks Eddy. I'll research the config setting in more detail.

"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).

need help please

Gondzer7-Dec-12 23:58

Gondzer

7-Dec-12 23:58

for (int i = 0; i < 5; i++)
{
   i = int.Parse(Console.ReadLine());
}
Console.Write(i);
Console.ReadKey();

how to get console to print all of the numbers entered (5 numbers)? when i debug this it says that the name 'i' does not exist in current context.

Re: need help please

Mycroft Holmes8-Dec-12 1:02

Mycroft Holmes

8-Dec-12 1:02

Put the console.write and console.readkey INSIDE the for next loop. Move the } down 2 lines.

Never underestimate the power of human stupidity
RAH

Re: need help please

Gondzer8-Dec-12 1:09

Gondzer

8-Dec-12 1:09

i've tried that, it just writes the numbers straight after the entering, i want it to write all 5 AFTER i've entered the fifth number.

Re: need help please

Mycroft Holmes8-Dec-12 1:41

Mycroft Holmes

8-Dec-12 1:41

And that make no sense at all, you would have to put the numbers into a container (array/List<>) and then loop through the container and print them!

Never underestimate the power of human stupidity
RAH

Re: need help please

vr9999999998-Dec-12 1:04

vr999999999

8-Dec-12 1:04

problem in this code is that 'i' is only defined for 'for loop ' to make it run u have to define i before for loop
ex:
int i = new int();
for (i = 0; i < 5; i++)
{
i = int.Parse(Console.ReadLine());
}
Console.Write(i);
Console.ReadKey();
it will not give any error but don't give u the result u want it should be like this..
static void Main(string[] args)
{
int i = new int();
int []arry=new int[5];
for (i = 0; i < 5; i++)
{
arry[i] = int.Parse(Console.ReadLine());
}
for (i = 0; i < 5; i++)
{
Console.Write(arry[i]+"\n");
}

Console.ReadKey();
}

Re: need help please

Gondzer8-Dec-12 1:17

Gondzer

8-Dec-12 1:17

ok, I thought I could do it without the arrays, but thanks anyway

Re: need help please

OriginalGriff8-Dec-12 2:03

OriginalGriff

8-Dec-12 2:03

Just to add to what the others have said - you don't want to do it like that anyway!

for (int i = 0; i < 5; i++)
{
   i = int.Parse(Console.ReadLine());
}

Since i is both the loop control variable and the place you store the value the user entered, if the user enters 4 or above as his first number, it will exit the loop immediately.
You need to separate these two functions into two variables, as well as using an array or List<int>

BTW: It is considered a bad idea to use "magic numbers" such as "5" in your code - when you move to an array, it is too easy to later change one and not the other, causing your application to fail, or crash:

int[] inp = new int[5];
for (int i = 0; i < 5; i++)
   {
   inp[i] = int.Parse(Console.ReadLine());
   }

would be better as:

const int elements = 5;
int[] inp = new int[elements];
for (int i = 0; i < elements; i++)
    {
    inp[i] = int.Parse(Console.ReadLine());
    }

That way, you only have to change the number of elements in a single place, and it all works perfectly.

And as a final thing, if your user enters an alphabetic character instead of a digit, your program will crash. You should always check your user input - they do enter rubbish quite often! Laugh | :laugh:

[edit]Typos - OriginalGriff[/edit]

If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.

Re: need help please

Jibesh9-Dec-12 22:03

Jibesh

9-Dec-12 22:03

i wonder how this programs builds without any error?

there are few things you need to check here
1.the variable i is accessible only inside the loop and its local to that loop never accessible outside the loops.
2. the indexer variable i is modified against your input which may alter the loop execution
3. Console.Write is outside the loop so if variable i is acceible outside the loop it will print only the last entered value not all

try modifying your code.
define a new variable to store the read line
and move the Console.Write inside the loop and see the difference

Jibesh.V.P
India

Insert Data to Master/Detail table in Sqlserver 2005 from C# with Foreign key in Detail table

ahmed_one7-Dec-12 20:31

ahmed_one

7-Dec-12 20:31

I need some help to make a Order Form in C#. My development environment is:

Microsoft Visual Studio 2010 Ultimate Sql Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables=Orders and OrderDetails)

I've create a Form for order dataentry, which contain Textbox for OrderID, Combobox for Customer, DateTimePickers for OrderDate and ShippedDate and a DataGridView which contains Cokumns OrderID=ReadOnly, ProductID, UnitPrice & Quantity:

In the form load event I've the following code:

private void Inv2_Load(object sender, EventArgs e)
    {


        SetComb();
        connectionString = ConfigurationManager.AppSettings["connectionString"];
        sqlConnection = new SqlConnection(connectionString);

        qryOrd = "Select OrderID, CustomerID, OrderDate, ShippedDate from Orders";
        qryOrdDet = "Select OrderID, ProductID, UnitPrice, Quantity from OrderDetails";

        sqlConnection.Open();
        sqlDataMaster = new SqlDataAdapter(qryOrd, sqlConnection);
        sqlDataDet = new SqlDataAdapter(qryOrdDet, sqlConnection);

        //SET MASTER INSERT/UPDATES
        command = new SqlCommand("INSERT INTO Orders ( CustomerID, OrderDate, ShippedDate) VALUES (@CustID, @OrdDt, @ShipDt) SELECT SCOPE_IDENTITY();");

        command.Parameters.Add("@OrdID", SqlDbType.NVarChar, 15);
        command.Parameters.Add("@CustID", SqlDbType.VarChar, 15);
        command.Parameters["@CustID"].Value = cmbCust.SelectedText;

        command.Parameters.Add("@OrdDt", SqlDbType.DateTime);
        command.Parameters["@OrdDt"].Value = dtOrdDt.Text;

        command.Parameters.Add("@ShipDt", SqlDbType.DateTime);
        command.Parameters["@ShipDt"].Value =dtShipDt.Text;



        sqlDataMaster.InsertCommand = command;
        //string id = command.ExecuteScalar().ToString();

        command = new SqlCommand("UPDATE Orders SET CustomerID = @CustID, OrderDate = @OrdDt, ShippedDate = @ShipDt WHERE OrderID = @OrdID");

        command.Parameters.Add("@OrdID", SqlDbType.NVarChar, 15, "OrderID").Value = txtOrdID.Text; 
        command.Parameters.Add("@CustID", SqlDbType.VarChar, 15, "CustomerID").Value = cmbCust.Text;
        command.Parameters.Add("@OrdDt", SqlDbType.DateTime).Value = dtOrdDt.Text;
        command.Parameters.Add("@ShipDt", SqlDbType.DateTime).Value = dtShipDt.Text;
        sqlDataMaster.UpdateCommand = command;


        //SET DETAILS INSERT/UPDATES
        commandDet = new SqlCommand("INSERT INTO OrderDetails (ProductID, UnitPrice, Quantity) VALUES (@PrdID, @Up,@Qty)");

        //commandDet.Parameters.Add("@OrdID", SqlDbType.NVarChar, 15, "OrderID").Value = txtOrdID.Text; ;  
        commandDet.Parameters.Add("@PrdId", SqlDbType.NVarChar, 5, "ProductID");
        commandDet.Parameters.Add("@Up", SqlDbType.VarChar, 50, "UnitPrice");
        commandDet.Parameters.Add("@Qty", SqlDbType.VarChar, 20, "Quantity");
        sqlDataDet.InsertCommand = commandDet;

        commandDet = new SqlCommand("UPDATE OrderDetails SET ProductID = @PrdID, UnitPrice = @Up, Quantity = @Qty WHERE OrderID = @OrdID");
        commandDet.Parameters.Add("@OrdID", SqlDbType.NVarChar, 15, "OrderID").Value = txtOrdID.Text; ;  
        commandDet.Parameters.Add("@PrdId", SqlDbType.NVarChar, 5, "ProductID");
        commandDet.Parameters.Add("@Up", SqlDbType.VarChar, 50, "UnitPrice");
        commandDet.Parameters.Add("@Qty", SqlDbType.VarChar, 20, "Quantity");
        sqlDataDet.UpdateCommand = commandDet;

        sqlComBldMaster = new SqlCommandBuilder(sqlDataMaster);
        sqlComBldDet = new SqlCommandBuilder(sqlDataDet);

        dt = new DataTable();
        dtDet = new DataTable();


        dt.Clear();
        dtDet.Clear();


        sqlDataMaster.FillSchema(dt, SchemaType.Source);
        sqlDataDet.FillSchema(dtDet, SchemaType.Source);

        dtDet.Columns["OrderID"].AutoIncrement = true;
        dtDet.Columns["OrderID"].AutoIncrementSeed = -1;
        dtDet.Columns["OrderID"].AutoIncrementStep = -1;
        ds = new DataSet();
        ds.Tables.Add(dt);
        ds.Tables.Add(dtDet);
        ds.EnforceConstraints = false;



        DataRelation rel = new DataRelation("OrdersRel", ds.Tables["Orders"].Columns["OrderID"], ds.Tables["OrderDetails"].Columns["OrderID"]);
        ds.Relations.Add(rel);

        bs = new BindingSource();
        bsDet = new BindingSource();

        bs.DataSource = ds;
        bs.DataMember = "Orders";

        bsDet.DataSource = ds;
        bsDet.DataMember = "OrderDetails";


        dgInvDet.AutoGenerateColumns = false;

        dgInvDet.Columns["ProductID"].DataPropertyName = "ProductID";
        ProductID.DataSource = dm.GetData("Select * from Products order by ProductName");
        ProductID.DisplayMember = "ProductName";
        ProductID.ValueMember = "ProductID";
        dgInvDet.Columns["UnitPrice"].DataPropertyName = "UnitPrice";
        dgInvDet.Columns["Quantity"].DataPropertyName = "Quantity";   

        dgInvDet.DataSource = bsDet;



    }


public void SetComb()
    {
        cmbCust.DataSource = dm.GetData("Select * from Customers order by CompanyName");
        cmbCust.DisplayMember = "CompanyName";
        cmbCust.ValueMember = "CustomerId";
        cmbCust.Text = "";



    }

"Dm.GetData" is the Data Access class method created for the purpose of just retrieving reocrds...

And in the Save button click event:

private void btnSave_Click(object sender, EventArgs e)
    {


     dt.EndInit();
    rec = sqlDataMaster.Update(ds.Tables[0]);
    rec += sqlDataDet.Update(ds.Tables[1]);
     //recDet = sqlDataDet.Update(dt);

     ds.AcceptChanges();


     MessageBox.Show(rec + " record(s) applied...." );

     ds.EnforceConstraints = true;

    }

What I need is to save the Data to Sql Server in respective table (Orders and OrderDetails) which my code can't seems to do it and it shows error that Foreign Key cannot be null...Because OrderDetails table also needs OrderID which is Foreign Key, and I am unable to understand how can I get the OrderID, as it is Auto generated after data is inserted in Database.

Please help me on this problem to save the data in database with this foreign key issue...

Any help will be much appreciated.

Thanks

Ahmed

Re: Insert Data to Master/Detail table in Sqlserver 2005 from C# with Foreign key in Detail table

Eddy Vluggen8-Dec-12 2:49

Eddy Vluggen

8-Dec-12 2:49

ahmed_one wrote:
and I am unable to understand how can I get the OrderID, as it is Auto generated after data is inserted in Database.

You could select the last identity[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: Insert Data to Master/Detail table in Sqlserver 2005 from C# with Foreign key in Detail table

ahmed_one8-Dec-12 22:55

ahmed_one

8-Dec-12 22:55

Thanks for reply,

My problem is OrderID is not generated because of error that child table is not saved..the whole save procedure is failed because of this and compiler shows the error.

Re: Insert Data to Master/Detail table in Sqlserver 2005 from C# with Foreign key in Detail table

Eddy Vluggen8-Dec-12 23:59

Eddy Vluggen

8-Dec-12 23:59

ahmed_one wrote:
My problem is OrderID is not generated because of error that child table is not saved..

Save the Order first, fetch the identity, save the child-records.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Continuous listening of COM port for detecting MODEM??

shubhamjoshi7-Dec-12 19:59

shubhamjoshi

7-Dec-12 19:59

How will i continuous listen to COM for detecting modem.
if a modem is added or removed it should inform you that Modem installed or removed at COM45 etc.

I have tried to use a thread and check the com count but i am unable to know which com is modem.

If there is any specific class for this pls help me fr the code asap???

Re: Continuous listening of COM port for detecting MODEM??

vr9999999998-Dec-12 1:08

vr999999999

8-Dec-12 1:08

u can use timer .

Re: Continuous listening of COM port for detecting MODEM??

Mycroft Holmes8-Dec-12 1:42

Mycroft Holmes

8-Dec-12 1:42

You can use a keyboard!

Never underestimate the power of human stupidity
RAH

Re: Continuous listening of COM port for detecting MODEM??

Andy41111-Dec-12 1:51

Andy411

11-Dec-12 1:51

I'm not sure if I understand you: You want to iterate through all COM-Ports to detect, if a modem is connected?

You can open each COM-Port, send the command "AT" and wait if you get an "OK" as answer. Then you know, that there is a modem.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.