|
hello
i want code that display full records through age in .net by search option that like two textbox between the value 18-50.
please any budy help me for this logic.
saitwal
|
|
|
|
|
this query may help you
select * from table t
where t.age between @textbox1value1 and @textbox1value1
write a method such that it will accept the values from the textbox
and pass it to the query and read the values as shown
public DataTable GenerateReport( DateTime startDate, DateTime endDate)
{
SqlCommand cmd = new SqlCommand
{
Connection=place your connection string,
CommandText = "select * from table t where t.age between"+startDate+" and "+endDate
};
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
adapter.SelectCommand = cmd;
try
{
adapter.Fill(table);
}
catch (Exception ex)
{
throw new NPDSException("error in fetching data", ex);
}
return table;
}
|
|
|
|
|
ravithejag wrote: CommandText = "select * from table t where t.age between"+startDate+" and "+endDate
Have you never heard of SQL Injection[^]?
Never use string concatenation to build a query, not even for a quick sample. Use a parameterized command instead:
using (var connection = new SqlConnection("connection string here"))
using (var command = new SqlCommand("select * from table where age between @startdate and @enddate", connection))
{
command.Parameters.AddWithValue("@startdate", startDate);
command.Parameters.AddWithValue("@enddate", endDate);
var adapter = new SqlDataAdapter(command);
var table = new DataTable();
adapter.Fill(table);
return table;
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I am trying to access(Read) the Smart Card within my Asp.net C# web app. This is so the client can use smart card login instead of using a user name and password. All I need is to be able to read the data in the Identity of the smart card, especially the Subject which I parse and compare to the user account on my database. I am having trouble locating the classes and logic for reading this smart card. On one of our other systems, we use CAC login with the Active Card manager and that works correctly, but it will not work with the 90Meter Smart card. If anybody can help with this, I would appreciate it.
Thanks;
Bill
|
|
|
|
|
Hi,
Am sending mails to a group in outlook,the group consists of many users and when the user opens the mail i want to know which user is opened that mail and send it as a response. Currently am adding an image in the mail so on load of the image am calling some url where i can know that some user has opened the mail but i need email id as a parameter to the url. Could you please let me know how can we do this in outlook to get the user mail id. do we need to write any macro or anything??
Thanks
Ranjith.
|
|
|
|
|
This information can only be obtained if the user allows his Outlook system to send read response messages.
Use the best guess
|
|
|
|
|
kumar.ranjith.k wrote: Could you please let me know how can we do this in outlook to get the user mail id.
What is a user mail id?
|
|
|
|
|
|
Thank you..
for sharing this useful information but
is it working
|
|
|
|
|
Dear,
How to develop window application project in asp.net and what is suitable back end database. How to launch my application in internet.
Thank you in advance.
With regards
Varadharaj A
|
|
|
|
|
Varadha Raj wrote: How to develop window application project in asp.net
Can you elaborate more on what are you trying to do? Currently, above statement does not make much of a sense. Web application and Windows application are two separate things.
|
|
|
|
|
Is it Possible to develop windows application in asp.net...
What is the deference between web application and windows application.
Thanks
|
|
|
|
|
|
What is the best choice for desktop application development.
Please suggest front-end and back-end list..
I want to develop desktop application, that application may use my client in their own group data transaction in internet.
We already developed our desktop application in oracle and d2k platform...Now we want to change platform.
Thank you.
|
|
|
|
|
Windows desktop applications and Web applications are totally different and you cannot mix them together. If you are developing a system that will be used by remote clients then you will need to create a web application: start at the ASP.NET web site for tutorials and samples[^].
Use the best guess
|
|
|
|
|
Which is best and suitable to develop windows application. After development i want to deploy in internet.
Thanks
|
|
|
|
|
Web applications are deployed on internet.
Windows applications are generally downloaded from internet on system to work stand alone without need of network.
|
|
|
|
|
Then how is possible to run desktop application in internet ...more than the persons and various location...Please help me ..I want to develop my own desktop application that should be used in internet for my client..They will be used their own data transaction from various location. Please suggestion for that which is the best choice for front-end development and back-end. Pls mention.
Thank you.
|
|
|
|
|
Windows Form / Windows Application and Desktop Application are those application which run in windows operating system in desktop mode not in web mode having different structure than web and hence they are run through executable and after publishing your source code you can upload it to live server.
Desktop Application create through File => New project in Visual Studio .net and chose the language in which you want to develop most widely used are C# and VB .
The Best backend database for application is Microsoft SQL Server.But depend on Requirement you use oracle, mysql or attach any other oledb.
|
|
|
|
|
Thank you so much..
With Regards
Varadharaj A
|
|
|
|
|
|
I have a dataset returning the following values:
Name Region
Tom 1
Dick 3
Harry 3
Paul 2
I need to display each of them in different panels
for e.g. in panel for region 2 i need to display only Paul
in region 3 display Dick and harry
and display Tom in the panel for region 1.
Any idea how to do this?
I can create 3 different queries for each panel but i want to avoid that repetition.
|
|
|
|
|
You can use a repeater with gridview inside of the repeater's ItemTemplate and bind the gridview in the ItemDateBound Event of the repeater.
|
|
|
|
|
Hi,
actually I have bounded a dropdownlist in gridview in edit mode, but the problem is that whenever i try to select another value from dropdownlist, it auto select the first value.
I also used !IsPostBack property on page_load event but still it is not selecting the another items.
<pre lang="c#">
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList ddlCost_Code = DropDownList)e.Row.FindControl("ddlCost_Code");
BAL bl = new BAL();
DataTable dt_for_CostCode = null;
dt_for_CostCode = bl.Select_Cost_Code();
if (dt_for_CostCode.Rows.Count > 0)
{
ddlCost_Code.DataSource = dt_for_CostCode;
ddlCost_Code.DataTextField = "Cost_Code";
ddlCost_Code.DataValueField = "Proposalno";
ddlCost_Code.DataBind();
}
}
if (!IsPostBack)
{
try
{
Log_Booked_Info_Through_Booking_Table();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
}
</pre>
|
|
|
|
|
Ofcourse, it will select the first item, since you are just binding the dropdownlist, i do not see the code line which is making the particular item as selected. i mean, if you wanted to make 2nd item to selected then you could have written as below.
ddlCost_Code.DataSource = dt_for_CostCode;
ddlCost_Code.DataTextField = "Cost_Code";
ddlCost_Code.DataValueField = "Proposalno";
ddlCost_Code.DataBind();
ddlCost_Code.Items[2].Selected = true;
if you do not specify item to be selected, it will select the first item by default.
Vande Matharam - Jai Hind
|
|
|
|