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 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
i want fetch data from temp table in sql server stored procedur like below code
[Code]....
primary key is of uniqueidentifier in dataTable
I have One DataTable Having 500 Records, want to Fetch Top 10 Record. how to do it
View 2 Replies[Code]....
View 2 RepliesEquivalent 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 have a code that read all data from sqldatasource and store it in exel file. my problem is,when the program run when i click on button,the message pop up to open or save, so by click on open or save we can either save it in exel file or open and look in exel file.
i want withought poping any message,it store the file directly to the specific folder without infomring the user.
here is my code
string attachment = "attachment; filename=Contacts.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
How to Fetch Rows based on Values in a Session Variable
View 4 Repliesi hav a gridview ... now i need to add certain number of rows... say 5 rows .... which would b blank .. the rows consist of itemtemplate of textboxes.. here is the grid ...
[Code]....
now i am binding this gridview with certain data say :
[Code]....
now the problem is if the row contains 2 data originally ... then it alwz shows up with only two rows with binded data... but what i want is 2 (databinded rows ) + 5 (empty rows with textbox ) = 7 grid view rows .... now how to do it ... after i hav binded the textbox with data already....with some empty columns corresponding to the above code ?
I want design a page where the end user enters information on my page and related information is fetched from the another website on my web page.
For example: Capturing City and state name from USPS.com
End user Task : Enter zipcode and click button 'Fetch'
My page perform few task
1. opens usps site backend
2. Enters the zipcode
3. Captures city name and state as temporary value from the usps
4. Displays the same in labels present in my home page.
how can i find the value in the field which contain "," and remove it in sql e.g:
the field is: 11,12,13
how can i find 12 and remove it becomes=> 11,13
if the field is 12,13,14==> 13,14
if the field is 9,10,11,12 ==> 9,10,11
if the field is 12 only ,then result is empty
To write a join query with or condition. It means a query has two inner join, here it is possible to fetch the records, if one inner join is true and other is false. I got a record when only two join conditions are true.
View 1 RepliesI am working with asp.net 2008 and sql server 2005 . I get a situation where i have to delete data after 30 days. a suitable query how to do the same. I have go through different query but nothing going right for me.
View 2 RepliesI'm using SQL sever 2005 and 2008 expressHow Can I create a DB backup in a specific folder??I use Management Studio but I'd like to automatically create backup without use tools
View 5 RepliesWe have a ASP.NET 3.5 application where we want each user to have their own database. Everyone uses the same web application, but the database their data is kept separate from all others. So every customer has his own database. All database structures are identical, so the only thing the application has to do is connect to the right one when the user logs in.
I envision that we look up a connectionstring to their data at the time they log in and set it globally for that session. With Linq, the connection is handled automatically though, in the background, based on the setting in the web.config file. Unlike SQL Server where you set it each time you use it, with Linq it is hidden in the .NET generated class files.
How/Can I Set the try, catch statment to catch a specific Error. For example i am getting the following error:
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '='., [SqlException (0x80131904): Incorrect syntax near '='.]
Basicly The = is part of my SQL string which points to a table that currently doesent exist. I want something like catch ex as SqlException (0x80131904) or catch ex as SqlException = "0x80131904" or even catch ex as System.Data.SqlClient.SqlException = "Incorrect syntax near '='." I just want something so i can put "table doesnt exist" in the error message without having to use:
catch ex as System.Data.SqlClient.SqlException
As i have other code on my page that could result in a different type of sqlExeption.
how can i split the frist word in sql if the field contain ',' otherwise, only show the data value.
if the field is 'A,B,C'
I would like to select A as a result.
How to start at a specific record and returning only the next 5 records with T-SQL command
[Code]....
That is my concatenated SQL statement but it obviously does not work because it only looks at the top 5 records in the entire table instead of what I intended which would be to look at the top 5 records starting with the record where PostNumber equals the value of lastPost. I have been searching for a T-SQL statement that will allow me to do this but I can't find one.
i am trying to create an asp.net service where it can delete specific records from the databas, this is by code so far:
View 1 Repliesi 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 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.
how can i write a sql to execute the file at specific time sql server database.
View 3 RepliesAnyone know how to write a select statement to where it returns results that have a specific character count? I want to return all results that have 5 characters.
View 1 RepliesI have a query on datagrid .../(using asp.net 2.0 Version C# support by Linq Method) I use datagrid and one of column i place a dropdownlist (DropDownList1) and I fillup the data from DataGrid1_ItemDataBound After filling the data I want to select the value and pass to varibale via a hreaf to another page but no such value to be select. How to fetch value of dropdownlist on to next webpage.
View 3 Replies