Databases :: Fetching The Minimum Value From The Database?
Oct 11, 2010
MySqlCommand cmd4 = new MySqlCommand("select emp_name from employee_details where emp_category='" + cat[j] + "' and no_ofcassigned=(select MIN(no_ofcassigned) from employee_details)", AL.con);
MySqlDataReader reader2 = cmd4.ExecuteReader();
string emp=null;
while (reader2.Read())
{
emp = reader2[0].ToString();
}
reader2.Close();
i am using the above code to fetch the employee name from the datatable according to the minimum value in the column 'no_ofcassigned' in specific category but here if i have more than 3 employees with the same no_ofcassigned is there then the query is not
View 1 Replies
Similar Messages:
Oct 6, 2010
I am re-loading the Oracle 10g client on my .NET development machine. This Oracle client install is not the most intuitive and I just would like to know what the bare minimum client install is to run my ASP.NET project and what selection do I need to make at the beginning of the install process?
View 1 Replies
Sep 24, 2010
I am trying to fetching the data from Book1.xlsx file. The program is not working and throws an exception. check the code and tell me where I am doing the mistake?
[Code]....
The exception is:
An error: The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
View 5 Replies
Dec 28, 2010
I have two databases (DB1 & DB2) from which i wish to build a single table/gridview output, ideally i want to be able to sort the table by using any data.
However i cannot seem to figure out how to have more than one datasource per Gridview, and if i have more than one Gridviews then i can't sort all the data by any of the columns.
This is a oneway street, i do not want to update the databases from the webfront end.
Here is a Trimmed Down Version of what i have
[code]....
View 5 Replies
Jun 8, 2010
I am fetching data from oracle data base in asp.net application. To achieve this functionality i have used Oracle.DataAccess dll . In my developement enviorment it working fine.
But once I deployed this code on IIS 6.0 it is stopped working and I checked my log and found connection not get established . Then I make sure Oracle.DataAccess.dll present in to bin folder also I try to put this dll in side GAC, but still my code is not working on deployed server.
View 1 Replies
May 7, 2015
I want to set a Range Validator on a TextBox to prevent someone from entering max and min value greater than is available in DB table.
Both min and max Value saved in DB has datatype Double.
<asp:TextBox ID="WaterLvl" runat="server" MaxLength="10"></asp:TextBox>
<asp:RangeValidator ID="RangeValidator1" runat="server" MaximumValue=" " MinimumValue=" " Type="Double" Text="Value out of range" ErrorMessage="Value out of range" ControlToValidate="WaterLvl" ForeColor="Red"></asp:RangeValidator>
View 1 Replies
Jan 22, 2011
Following error is thrown from the live application every now and then
[Code]....
now able to able to replicate the issue on test server. what could be the reason of the above error?
View 1 Replies
Jun 17, 2013
I have House_info Table in database
Id Name Behcode Password T_name
1 Sara 1111 1212 Store
2 Jack 2222 4545 Estate
and I have Admin.aspx page in this page I have EnterBTN Button and 2 Textbox TxtBeh and TxtPass here users enter Behcode and Password and when they click on EnterBTN Button it go to other page below is EnterBTN Event code
protected void EnterBTN_Click(object sender, ImageClickEventArgs e)
{
string data = Server.UrlEncode(Txtbeh.Text);
SqlCommand _cmd = new SqlCommand("EnterStore", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[code]....
here if users enter correct Behcode and password it go to Manager.aspx page...I want if users enter correct behcode and password if their T_name was =Store it go to Manager.aspx page And if their T_name was Estate it go to Estate.aspx page.
View 1 Replies
Feb 25, 2016
I have stored images in folder each images is more than 700kb so datalist binding process became slow.so it is possible that while loading record and corresponding images from folders Can I reduce the image size or compress images so that record fetching become faster.In database i m stroing image path and image is stored in directory.
View 1 Replies
Oct 8, 2013
I have one page on which there are 6 labels and six text box for subject apart from this there are 2 to 3 other text box and label for studnt information. i want to do in such a way that if i enter student enroll no i get his/her name ,dept,sem,all subjects on 6 labels and marks related to subject in text box. In table there are fields
Marks_Entry
Student_Enroll Student_Name Sem Program subject Marks
1 sss 1 BCA Basic Communication Skills 75
1 sss 1 BCA Mathematical Foundation 85
[code]...
now when i am entering roll no in form then student name ,program, sem is fetched but in label 1 to label 6 same subject name that is 1st subject name is copied and in text box also first marks are fetched in all textboxes..my c# code on student enroll textbox is this
protected void txtEnroll_TextChanged1(object sender, EventArgs e) {
conn.Open();
qry = "SELECT * FROM Marks_Entry WHERE Student_Enroll_No = '" + txtEnroll.Text + "'";
SqlCommand cmd = new SqlCommand(qry, conn);
SqlDataReader dr = cmd.ExecuteReader();
[code]...
how can i get different values from database
View 1 Replies
Jul 8, 2013
I have used [URL]....
above method to save and retreve files from sql server database. I have uploaded around 50-60 images as jpg. But it taking so much time to get display online. but it's working faster when accessing from local database.
There's the page where images are displaying [URL]....
Is the speed for images retreiving from sql database is slower as compared to retrieving images from folder..?
.vb code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
scroll = fillbannerpics()
End If
End Sub
[CODE]..
View 1 Replies
Mar 26, 2010
protected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I use VS 2010, ASP.NET
View 3 Replies
Feb 27, 2010
I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 Replies
Dec 6, 2010
i want to connect Db2 database with my .net application.how to fetch data from my DB2 database through my Asp.net application then how to genrate crystal report through this data.
View 2 Replies
Jun 15, 2010
I want to use MVC 2 with MySQL database. Is it possible?because my shared hosting limits the size of SQL Server database, but there is no limit on Size of MySQL database.MySQL seems to take less disk space than SQL Server database which is costly on the Internet.
View 1 Replies
May 15, 2010
I did all the instructions which are in the following link: [URL] in order to do a connection between MySQL database and ASP.NET but I did not successed. Sometimes, it told me that I have a mistake in the <asp: button> and sometimes it told me that I did a mistake in calling (addImage) method. And this is my whole code:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="HW5._Default" %>
<script>
public class DataAccess
{
private string _strConn =
@"Driver= {MySQLODBC 3.51 Driver};SERVER=localhost;DATABASE=test1;";
private OdbcConnection _objConn;
public DataAccess()
{
this._objConn = new OdbcConnection(this._strConn);
}
// This function adds the Images to database
public string addImage(timestamp id, byte [] data,string extension)
{
string strSql = "SELECT * FROM File";
DataSet ds = new DataSet("Image");
OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql,this._objConn);
OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP);
tempAP.Fill(ds,"Table");
try
{
this._objConn.Open();
DataRow objNewRow = ds.Tables["Table"].NewRow();
objNewRow["Extension"] = extension;
objNewRow["Data"] = buffer;
objNewRow["ID"] = id;
ds.Tables["Table"].Rows.Add(objNewRow);
// trying to update the table to add the image
tempAP.Update(ds,"Table");
}.....................................
View 4 Replies
Jan 8, 2010
I have one desktop application which is maintain all information related to laws of high court. we have stored lots of data in my application and now
our database size is almost 40 GB.
So my application runs quite slow.
How can i reduce the database space on my hard disk.
View 3 Replies
Jun 11, 2010
how to connect mysql database in asp.net?
I am install mysql 5.0 then i install sqlyog.
After that i create the database sample in mysql with the help of sqlyog.
I want to connect the database in asp.net & display it on gridview.
[Code]....
How we set the connection string in mysql for use on aspx page?
View 1 Replies
Feb 17, 2011
How do I connect from a web application to db2 database?
View 3 Replies
Mar 15, 2010
I have the following piece of code in my web.config file.. I am trying to connect to a MySQL database. The code compiles fine and when I am ruuning the website I come across this error - 'Keyword not supported: 'server'.':
[Code]....
View 7 Replies
Oct 2, 2010
how i can use Oracle database with asp.net mvc 2 web application?
View 3 Replies
Feb 17, 2010
I have a query which return rows with specific fields
View 1 Replies
Jan 7, 2010
I have few questions regarding MySql database.
First one will be: I've installed MySql, Query broswer, and ODBC connector (not sure what this one does. Can anyone explain?)
Now, when im dragging a new DataGridView into the form, and try to connect it to a MySql database, i can't seem to find MySql in the databases list... why is that?
Second question, assuming everything works fine, how can i upload the database to a server and use it there?
I can think of two problems trying to do this : (1) Im not sure where my Database files are stored at... (for some reason, they are not found in MySql/Data... this folder is completly absent)
(2) While working with ACCESS, all i had to do is to point the .aspx page that did the connecting to the location of the .mdb file, but now, each time i want to reach my database, i need to send the page to the server (localhost). How will i create a connection to my database, when its on another server, in the code page ? (small code example would be nice).
View 4 Replies
Mar 22, 2010
i am inserting a record into oracle database using vb.net,there is a password field by using md5 i am generating it and taking tht value as string(ex: "16D78A6B10D631C8C86397C35A3CCD57") now my requirement is i should insert it into database(oracle) & in database that field is "RAW" how to do this?and the error msg is
Type of value has a mismatch with column typeCouldn't store in Col_Pass Column. Expected type is Byte[].
View 1 Replies
Jun 9, 2010
i can view the images from the database (datatype = binary) but the problem is the .doc and pdf is not appearing at the page...
[Code]....
View 5 Replies