I am using C#, Asp.net and my Ms Sql server table name is getdetail which contains id(int),name(nvarchar(20)) fields and the table data are 101, bob. Now i want to fetch the name value and assign it to the string datatype variable and show that value in the page.
View 1 RepliesI 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 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
In oracle we can do this by using rowid.
select * from tableName where rowid = (select max(rowid) from tableName);
but i don't know equivalent of rowid in sql server.
I want to fetch data from two table buut i m realy confused.
just i want recent two users in my site but problem is there that two users releted information stored in other table .
I also used join query to fetch that data but proper result not get .
Equivalent of recordset.Edit, Movefirst,NoMatch of vb6 in vb.Net? I want to fetch records from single table of database(Sql server 2005) and collect in collections. How can we do that by dataset and dataadapter ? We want to fetch not to display.
View 1 RepliesI need to fetch the data from a table with Alias name in oracle.
example: select f1 'Field Name1',f2 'Field Name2' from sometablename;
i want fetch data from temp table in sql server stored procedur like below code
[Code]....
primary key is of uniqueidentifier in dataTable
I am project where I am having 2 tables namely sales_master & sales_transaction.
how to populate data in crystal report so that master records are not duplicated.
For ex. Date , Customer name & etc. should not be repeated again..
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]....
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.
Can I fetch data which is in an output from an ASP script and then process it and do mathematical algorithms?
View 1 RepliesI want to fetch data from JDEdwards and put it in Microsoft Sql Server 2005, how it is possible ?
View 1 RepliesI am trying the new feature of .NET 4.0 - url routing but not able to fetch information passed in the url. Following is the code :
GLOBAL.ASPX.CS
protected void Application_Start(object sender, EventArgs e)
{
SetRouting(RouteTable.Routes);
}
private void SetRouting(RouteCollection routeCollection)
{
routeCollection.MapPageRoute("Company",
[Code]....
Now the property mentioned above returns null even when i use Client/Google in the url. When i reset IIS and do it for first time, it returns value. Otherwise it gives null.
Inside a repeater there's a list of addresses ..when address link button is clicked, the address is shown inside of text boxes above repeater with all text boxes greyed out and an Edit button is rendered on the page OUTSIDE the repeater and below the text boxes..Now how do I edit this address ?
I need the AddressID of the address that has been clicked inside the repeater...
when Address link is clicked,DisplayAddress command event is fired inside of repeater's ITemCommand so what I did was assigned "AddressID" generated(when Adress link was clicked inside repeater) to a globally decalred string variable and tried to use that inside my Edit Button's click event so as to fill the Datasource(Method used to fill data source requires AddressID) and do stuff...didnt work
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 RepliesAm 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 RepliesThere is a string in which email addresses are there like
as@as.com;df@fd.com;gh@df.com
I want that it will pick email address one by one and fill it to 'To' and send message one by one.
I 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 was just wondering what is the best way to fetch gridview data using row databound event of gridview. I am previously used to Eval but read its not recommended as it uses reflection.
View 1 RepliesI want to fetch output as string. I want to run webpage from my code like [URL]after running i want to keep whole values in a string and again in next step i want to search all anchor href values from the string. But initially how will get domain ouput as string ASP.net.
View 1 RepliesI want to fetch website title and images from URL. as facebook.com doing. How I get images and website title from third party link.?
View 4 Replies