Retrieve the model and price of the car by using parameters
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
1
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
public class car
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{
Label1.Text = "please enter a numeric ID!";
}
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
}
I want to display the car model and price in Label1 when button is clicked according to Id entered in the TextBox1.
aspx markup:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="car_database.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
enter id to retrieve the model and the price of the car :
<asp:TextBox runat="server" ID="TextBox1" />
<br />
<asp:Button runat="server" ID="btn" OnClick ="BtnView" />
<br />
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</div>
</form>
</body>
</html>
But the code does not work - I get some error:
public class car must have return type
TextBox1.Text and Label1.Text have errors:
An object reference is required for the non-static field method or property
c# asp.net
sql-server visual-studio express edited Nov 17 '18 at 10:49
marc_s
584k13011241271
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
add a comment |
1
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
public class car
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{
Label1.Text = "please enter a numeric ID!";
}
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
}
I want to display the car model and price in Label1 when button is clicked according to Id entered in the TextBox1.
aspx markup:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="car_database.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
enter id to retrieve the model and the price of the car :
<asp:TextBox runat="server" ID="TextBox1" />
<br />
<asp:Button runat="server" ID="btn" OnClick ="BtnView" />
<br />
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</div>
</form>
</body>
</html>
But the code does not work - I get some error:
public class car must have return type
TextBox1.Text and Label1.Text have errors:
An object reference is required for the non-static field method or property
c# asp.net
sql-server visual-studio express edited Nov 17 '18 at 10:49
marc_s
584k13011241271
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
1
protected BtnView(object sender, EventArgs e)should beprotected void BtnView(object sender, EventArgs e)
– Rahul
Nov 16 '18 at 12:31
Start with the basics: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…. Your code has a couple of issues. A button click method in a class, a class T without a return...
– VDWWD
Nov 16 '18 at 12:34
add a comment |
1
1
1
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
public class car
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{
Label1.Text = "please enter a numeric ID!";
}
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
}
I want to display the car model and price in Label1 when button is clicked according to Id entered in the TextBox1.
aspx markup:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="car_database.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
enter id to retrieve the model and the price of the car :
<asp:TextBox runat="server" ID="TextBox1" />
<br />
<asp:Button runat="server" ID="btn" OnClick ="BtnView" />
<br />
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</div>
</form>
</body>
</html>
But the code does not work - I get some error:
public class car must have return type
TextBox1.Text and Label1.Text have errors:
An object reference is required for the non-static field method or property
c# asp.net
sql-server visual-studio express edited Nov 17 '18 at 10:49
marc_s
584k13011241271
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
public class car
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{
Label1.Text = "please enter a numeric ID!";
}
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
}
I want to display the car model and price in Label1 when button is clicked according to Id entered in the TextBox1.
aspx markup:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="car_database.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
enter id to retrieve the model and the price of the car :
<asp:TextBox runat="server" ID="TextBox1" />
<br />
<asp:Button runat="server" ID="btn" OnClick ="BtnView" />
<br />
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</div>
</form>
</body>
</html>
But the code does not work - I get some error:
public class car must have return type
TextBox1.Text and Label1.Text have errors:
An object reference is required for the non-static field method or property
c# asp.net
sql-server visual-studio express c# asp.net
sql-server visual-studio express edited Nov 17 '18 at 10:49
marc_s
584k13011241271
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
edited Nov 17 '18 at 10:49
marc_s
584k13011241271
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
edited Nov 17 '18 at 10:49
marc_s
584k13011241271
edited Nov 17 '18 at 10:49
marc_s
584k13011241271
edited Nov 17 '18 at 10:49
marc_s
584k13011241271
584k13011241271
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
asked Nov 16 '18 at 12:28
Reem AbdulazizReem Abdulaziz
175
175
1
protected BtnView(object sender, EventArgs e)should beprotected void BtnView(object sender, EventArgs e)
– Rahul
Nov 16 '18 at 12:31
Start with the basics: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…. Your code has a couple of issues. A button click method in a class, a class T without a return...
– VDWWD
Nov 16 '18 at 12:34
add a comment |
1
protected BtnView(object sender, EventArgs e)should beprotected void BtnView(object sender, EventArgs e)
– Rahul
Nov 16 '18 at 12:31
Start with the basics: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…. Your code has a couple of issues. A button click method in a class, a class T without a return...
– VDWWD
Nov 16 '18 at 12:34
1
1
protected BtnView(object sender, EventArgs e) should be protected void BtnView(object sender, EventArgs e)– Rahul
Nov 16 '18 at 12:31
protected BtnView(object sender, EventArgs e) should be protected void BtnView(object sender, EventArgs e)– Rahul
Nov 16 '18 at 12:31
Start with the basics: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…. Your code has a couple of issues. A button click method in a class, a class T without a return...
– VDWWD
Nov 16 '18 at 12:34
Start with the basics: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…. Your code has a couple of issues. A button click method in a class, a class T without a return...
– VDWWD
Nov 16 '18 at 12:34
add a comment |
2 Answers
2
active
oldest
votes
1
Couple of mistake I see
protected BtnView(object sender, EventArgs e)
{
Should be
protected Void BtnView(object sender, EventArgs e)
{
....
}
Also, Label1.Text = "please enter a numeric ID!"; should be this.Label1.Text = "please enter a numeric ID!"; considering Label1 is the Label control instance name
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
@ReemAbdulaziz that's cause of theLabel1.Text = ""changed that as suggested in answer for all references
– Rahul
Nov 16 '18 at 12:54
add a comment |
0
Remove the class public class car, the code must be in the WebForm1 class to have access to its controls.
Try like this:
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{ Label1.Text = "please enter a numerac ID!"; }
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53337942%2fretrieve-the-model-and-price-of-the-car-by-using-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Couple of mistake I see
protected BtnView(object sender, EventArgs e)
{
Should be
protected Void BtnView(object sender, EventArgs e)
{
....
}
Also, Label1.Text = "please enter a numeric ID!"; should be this.Label1.Text = "please enter a numeric ID!"; considering Label1 is the Label control instance name
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
@ReemAbdulaziz that's cause of theLabel1.Text = ""changed that as suggested in answer for all references
– Rahul
Nov 16 '18 at 12:54
add a comment |
1
Couple of mistake I see
protected BtnView(object sender, EventArgs e)
{
Should be
protected Void BtnView(object sender, EventArgs e)
{
....
}
Also, Label1.Text = "please enter a numeric ID!"; should be this.Label1.Text = "please enter a numeric ID!"; considering Label1 is the Label control instance name
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
@ReemAbdulaziz that's cause of theLabel1.Text = ""changed that as suggested in answer for all references
– Rahul
Nov 16 '18 at 12:54
add a comment |
1
1
1
Couple of mistake I see
protected BtnView(object sender, EventArgs e)
{
Should be
protected Void BtnView(object sender, EventArgs e)
{
....
}
Also, Label1.Text = "please enter a numeric ID!"; should be this.Label1.Text = "please enter a numeric ID!"; considering Label1 is the Label control instance name
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
Couple of mistake I see
protected BtnView(object sender, EventArgs e)
{
Should be
protected Void BtnView(object sender, EventArgs e)
{
....
}
Also, Label1.Text = "please enter a numeric ID!"; should be this.Label1.Text = "please enter a numeric ID!"; considering Label1 is the Label control instance name
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
edited Nov 17 '18 at 10:50
marc_s
584k13011241271
584k13011241271
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
answered Nov 16 '18 at 12:35
RahulRahul
63.4k124584
63.4k124584
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
@ReemAbdulaziz that's cause of theLabel1.Text = ""changed that as suggested in answer for all references
– Rahul
Nov 16 '18 at 12:54
add a comment |
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
@ReemAbdulaziz that's cause of theLabel1.Text = ""changed that as suggested in answer for all references
– Rahul
Nov 16 '18 at 12:54
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
The second error still exists: an object reference is required for the non-static field method or property
– Reem Abdulaziz
Nov 16 '18 at 12:48
@ReemAbdulaziz that's cause of the
Label1.Text = "" changed that as suggested in answer for all references– Rahul
Nov 16 '18 at 12:54
@ReemAbdulaziz that's cause of the
Label1.Text = "" changed that as suggested in answer for all references– Rahul
Nov 16 '18 at 12:54
add a comment |
0
Remove the class public class car, the code must be in the WebForm1 class to have access to its controls.
Try like this:
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{ Label1.Text = "please enter a numerac ID!"; }
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
add a comment |
0
Remove the class public class car, the code must be in the WebForm1 class to have access to its controls.
Try like this:
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{ Label1.Text = "please enter a numerac ID!"; }
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
add a comment |
0
0
0
Remove the class public class car, the code must be in the WebForm1 class to have access to its controls.
Try like this:
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{ Label1.Text = "please enter a numerac ID!"; }
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
Remove the class public class car, the code must be in the WebForm1 class to have access to its controls.
Try like this:
using System;
using System.Data.SqlClient;
namespace car_database
{
public partial class WebForm1 : System.Web.UI.Page
{
string connstring = "Data Source=.\SqlExpress; Initial Catalog=carsale; Integrated Security=True";
protected BtnView(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connstring);
try
{
myConnection.Open();
string query = "select model ,price from car where Id =@carid";
SqlCommand mycmd = new SqlCommand(query, myConnection);
int carid1;
if (!int.TryParse(TextBox1.Text, out carid1))
{ Label1.Text = "please enter a numerac ID!"; }
else
{
mycmd.Parameters.Add("@carid", System.Data.SqlDbType.Int);
mycmd.Parameters["@carid"].Value = carid1;
SqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
Label1.Text = "Model:" + reader["model"] + "<br/>" + "price:" + (string)reader["price"];
}
else
{
Label1.Text = "no car has this id ";
}
reader.Close();
}
}
catch (Exception ex)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = ex.Message;
}
finally
{
myConnection.Close();
}
}
}
}
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
answered Nov 16 '18 at 14:02
Sergiu MuresanSergiu Muresan
3596
3596
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53337942%2fretrieve-the-model-and-price-of-the-car-by-using-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
protected BtnView(object sender, EventArgs e)should beprotected void BtnView(object sender, EventArgs e)– Rahul
Nov 16 '18 at 12:31
Start with the basics: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…. Your code has a couple of issues. A button click method in a class, a class T without a return...
– VDWWD
Nov 16 '18 at 12:34