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:

Databases :: What Is The Bare Minimum Oracle 10g Install

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

Databases :: Fetching The Data From Book1.xlsx File?

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

Forms Data Controls :: Fetching Data From Two Access Databases In One Gridview?

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

Databases :: Fetching Data From Oracle Data Base In Application?

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

Web Forms :: How To Set Maximum And Minimum Value Of RangeValidator From Database

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

SQL Server :: Error While Fetching From Database?

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

User Controls :: Redirect To Page After Fetching Its URL From Database

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

Web Forms :: Reduce Image Size While Fetching From Database

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

Data Controls :: Fetching Values Of Same Field From Database In Different TextBox

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

Web Forms :: Fetching Of Files Saved In Database Using Generic Handler Is Slow

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

Databases :: Update MySQL-database / Database Doesn't Get Updated

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

Databases :: SQL Server Database Dependency In Oracle Database?

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

Databases :: How To Connect DB2 Database

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

Databases :: Use MVC 2 With MySQL Database?

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

Databases :: Connection To MySQL Database

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:-

&#65279;<%@ 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

Databases :: Decrease The Database Size From 40 GB?

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

Databases :: How To Connect Mysql Database

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

Databases :: How To Connect From A Web Application To Db2 Database

Feb 17, 2011

How do I connect from a web application to db2 database?

View 3 Replies

Databases :: How To Connect Mysql To Database

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

Databases :: Use Oracle Database With Mvc 2 Web Application?

Oct 2, 2010

how i can use Oracle database with asp.net mvc 2 web application?

View 3 Replies

Databases :: C# With Sql Database Bounding Data?

Feb 17, 2010

I have a query which return rows with specific fields

View 1 Replies

Databases :: Uploading MySql Database To A Server?

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

Databases :: Inserting The Record In Tp Oracle Database Using Vb?

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

Databases :: How To Retrieve Images And Document In Database

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







Copyrights 2005-15 www.BigResource.com, All rights reserved