How To Fetch Multiple Data
Jan 19, 2010Can I fetch data which is in an output from an ASP script and then process it and do mathematical algorithms?
View 1 RepliesCan I fetch data which is in an output from an ASP script and then process it and do mathematical algorithms?
View 1 RepliesI have 1 listbox named lbCountry
i have inserted each selected value from listbox into database by following code:
[code]....
now i dont know how to fetch data from database and fill listbox with multiple selected value.
i have a details table which include detailid, custname, address, classification , pincode, telephone, remarks and classification table contain classification id & classification.i want to insert detailid & corresponding classificationid to a new table detail_classification. How to write stored procedure for that?
View 1 RepliesI use below code in SP to count row of table and show it in label
ALTER procedure [dbo].[showMessage]
as
begin
SET NOCOUNT ON
select (select COUNT(id) from Message) as Message
,(select COUNT(id) from MessageM) as Messagem
end
[CODE] ...
Now I want define other label that shows total of these two table rows .I mean if in Message Table has 7 row and MessageM tabel has 8 row so
LblNMR =7 and LblRM =8
Now I want define LBLMAIN that in this label show LBLMAIN=15 total of 2 tabel Rows
How I can do it ?
here are few ways listed to get data from sql:
execute reader
execute nonquery
execute reader
give input parameter --> fetch output parametrr from stored proc.
any other way?
I have a [URL]I want to fetch QOT_ID from URL .
View 5 RepliesI've to read Excel data from my Asp.net 3.0 VB code. My Excelsheet format is like
Company Name (Heading)
Company Address
Date:
Blank Space
Column Heading
Branch name
Data
Data
& after data
Total
Grand Total
I've to read data After branch name upto Total. Even I've to fetch data from certain columns only.
I want to fetch data from JDEdwards and put it in Microsoft Sql Server 2005, how it is possible ?
View 1 RepliesHow to fetch data from textbox inside a gridview
View 2 RepliesI am trying to delete a row of the child gridview through a link button template field but how do I fetch the datakeys of the child gridview ?
In the code window there is no intellisense for child gridview as it is generated on runtime with respect to parent.
Am using two web application and one web service. My doubt is, am sending the dataset from my first application to Web service. After sending the dataset to my web service, i like to fetch the dataset using second application from the web service. How shall i fetch the dataset by using second application.
Note:
1) sending the dataset from first application to web service.
2) web service receives the dataset from the first application.
3) second application want to fetch the dataset from the web service which was sent by first application.
Is it possible to have a webapp/webservice to fetch data from my pc?? Can anyone give me an idea if it is possible....
View 1 RepliesI need to fetch CSV file from a webserver every few minutes.
Here's what I am planning to do:
I will create a webservice "GetCSV.asmx" which will get CSV file from that webserver.
I will create another webservice "RegularCall.asmx" which will call "GetCSV.asmx" every few minutes.
Is my approach correct? Is there a better way of doing this?
I am using ASP.NET web application and JSON webservice for this.
NOTE: There will be NO user intervention and the solution I am looking for is similar to scheduling a task on the server.
I have a dataset that has two datatables.
In the first datatable I have EmpNo,EmpName and EmpAddress
In the second datatable I have Empno,EmpJoindate, EmpSalary.
I want a result where I should show EmpName as the label and his/her details in the gridview
I populate a datalist with the first table, and have EmpNo as the datakeys.
Then I populate the gridview inside the datatable which has EmpNo,EmpJoinDate and EmpAddress.
My code is some what as below
[Code]....
Now I have a problem, I have to bind the Details of the corresponding Employee to the gridview. Whereas the above code will display all the details of all employees in the gridview.
If we use IEnumerable we give a condition where(a=>a.eno=EmpNo), and bind that list to the gridview.
How do I do this in datatable.
I modified the program as below
Igor, instead of datarelation,(my TL did not approve of it) I used IEnumerable
[Code].....
i'm trying to fetch data from xml in the sql query.
DECLARE @xmlDelete xml
SET
@xmlDelete =
'<DocumentElement>
<row FSFF_FeesItemID="185" FSI_ID="104" />
<row FSFF_FeesItemID="187" FSI_ID="104" />
<row FSFF_FeesItemID="187" FSI_ID="105" />
</DocumentElement>'
;
WITH
r_set AS
(
SELECT
T1
.c1.value('(./FSFF_FeesItemID/text())[1]',
'int')
AS [id1]
,
T1
.c1.value('(./FSI_ID/text())[1]',
'int')
AS.......................................
Im doing selling properties website with vb.net and just begin to use datalist
I have 2 pages, first is datalist that show all available properties with brief information, 2nd is another datalist that show full description about a particular property that the user wan to view.
I got few questions here:
1) I set the selecommand on the property name, but instead of viewing it on the same page, i wan to redirect to the details page to show all the informtion. How do i do that in the code behind? I include an onclick event to use Response.Redirect in the property name which is a linkbutton, but result in "XML page cannot be displayed" when click on it.
2) My primary key is set to imageID which to indicate the particular property details to show when user wan to view the full information. But how do i assign the image ID to the session?
i have a database and database have 3 tables... i want the table data show in asp:table not in grid view....
like in frid view we a doing simple wizard mode to fetch data from database... But in my query i want show data in <asp:Table> ..
asp:TableCell>
<fetech
data from sql
server table>
[Code]....
fetch data from Nested gridview checkbox on Click button event which is present outside the gridview. I did try by creating an object of child gridview on button1_click but cannot fill the value from Gridview2 into my int i. Below mentioned is the Code i am using. The database I am using is Oracle. ==== Code =====
protected void Button1_Click(object sender, EventArgs e)
{
OracleConnection con = new OracleConnection();
[code]...
how can i fetch the data from different tables stored in database on the value selected of dropdownlist..for ex.
DropDownlist1.selectedValue=="HEG01"
then the data from that table will be fatched from the databse and entries are displayed in gridview.
DropDownlist1.selectedValue=="RES01"
then the data from that table will be fatched from the databse and entries are displayed in gridview.
how to put sql database table to webpage in xml file format
View 1 RepliesI have a small problem I want to fetch some data from sql table. Table looks like as
sno acno amnout cash
1 A-100 5000 withdrawal
2 A-101 7000 Deposit
3 A-100 8000 Deposit
4 A-101 6000 Deposit
5 A-101 1000 withdrawal
And i want to records something like this:
acno Deposit withdrawal
A-100 8000 5000
A-101 13000 1000
my data base is oracle and i'm fetching simple data id, desc from table into a data set. But i'm getting only id and my desc field is showing blank.
my table is like this id number, desc nvarchar2(100)
I am having dataset.xsd file which contain table-1 and thousands of record.The table contains rollno,name,mark and soon.If i give rollno means it automatically select name dfrom the table .How to perform this operation?
View 1 RepliesHow can we gather data from other site. One of the site has a search option, when we provide a value the related values are displayed. i have a list of 800 values for which i need the data. Is there a program or tool which i can use to automate this process. I have the list of inputs in excel and it is a one word code.
View 3 RepliesI am using following oracle query and using executescalar() to fetch data
sql = "select username from usermst where userid=2"
string getusername = command.executescalar();
But It is showing me error "System.NullReferenceException: Object reference not set to an instance of an object"
This error comes when there is no row exist in database for userid=2