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.
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.
I have a gridview which is present inside a repeater. I have been successful in displaying the data inside the grid view. Now I want to fetch data from the gridview. But i have not been able to fetch the data from the grid view.
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.
name | phno. | emp_name(in dropdown) | buttonfield
wen user comes on this page this grid comes filled but then I need to select 1 emp_name from dropdown and click button(in last column) corresponding to that row. then on clicking that row button it should fetch that toq Primary Key and dropdown corresponding id. how? Wen I m fetching its fetching row index as 0 though it is no.4 record as per database(coz my records are in desc.order). I mean its giving row index as per grid and not as per my actual table(primary key).
I want to find a control in gridview using client id of the control as the id is changing dynamically. I am getting the client id but it is not getting assigned in a variable whether of string type or object type.
My application has GRID VIEW control, which displays, Folder Name and Folder Path. While rendering in the webpage, i want to display only the Folder Name. For this, i set the visible property to false. Now iam able to display only Folder Name column.
Now the problem is, though iam hiding the Folder path column, i want to retrieve, the Folder path, when user clicks on submit button. Iam getting empty value for the hidden column.
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
This is my code and i am only able to edit the one data under the category school.But what i nd is to edit the other categories like the name,email...etc..how do i modify my code in the update command.Another thing is to delete the data how do i do that?
I have a List View lstViewAB , by the above code i m trying to find the text on the lblMobile for those which are checked (checkbox). But the problem is that the text of label lblMobile is fetched of 1,3,5 rows only and for 2,4,6 rows it shows text "".
(coded in VB)i have Gridview which consists of textbox and dropdownlist. Now i want watever text is input in textbox and selected in dropdownlist, it should be inserted in my database..
i have code but it doesnt work...
to test it i have used label..to check whethher it shows selected information on button click...
but i want the selected or written value to be inserted in database on button click..
I want to show daily collection of the mandli on the google map info window. .According to date input ....so I want to how can I fetch the data from two different table..
User enter date in the textbox and click search button that is my scenario. ..
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
I have created a simple application to edit data in an access database using gridview but its not working , the results are shown correctly , but when i click update nothing happens..
a webpage have gridview,the button in gridview allocates locations to an order, if the location is not selected by the dropdownlist in gridview.I am using stored procedure for automatic allocation of locations. i dont know where the problem is but the program allocates same location to different order which should not be happening.I could not understand where i am wrong so thought to take advice of all the expertsplease here is aspx page:-
I have a nested gridview which has been working fine. Now I need to turn the inner gridview off based on some condition: a IF block is added to the existing RowDataBound event of the outer gridview. Now I'm getting "the Object reference not set to an instance of an object" error. What should be the proper way to go about this? The code:
[code]....
In addition, is there a way to "switch" columns of the inner gridview? For example, column 1 is "City", column 2 is "Price". If user selects to sort by "Price", I woud like column 1 be "Price" and column 2 be "City". Is this has to be done programmatically or if there's other way?
I have a dropdownlist outside the gridview control. My griview control also have dropdownlist in the first column. I want to populate the dropdownlist inside the gridview control for all rows when the selected item is changed in the outside dropdownlist.
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
i want to find data from excel sheet using c# my excel sheet like this
Sr. No. Store Code Store Name City State 1 3062 C.G.Road. Ahmedabad Gujarat 2 3103 Iscon Mega Mall 2 Rajkot Gujarat 3 3113 New Gandhi Nagar Ghaziabad Delhi 4........................
How can I fetch the first two information from it into my aspx page? for example I want to read the first two timings.. Should I use xmlReader or what?