retrieve data from sql server without using details or grid view.
i have a table in the SQL server called NewsTable which inculde the following fields: "titlename","bywho","datetime"."news"
anyway i need to retrieve the data from this table to my web page to appear this way ==> i am using C# by the way
TitleName
posted by bywho on datetime
News
I'm trying to make a dropdown list with data available based on the users login name. Heres what I have as my SQL Query in the SQLDataSource:
SELECT Client_Name, Client_ID FROM Client WHERE (Client_Name LIKE '%@Client_Name%')
So say if the login username is "User1" but the database client name is "User1 Steel" I want the dropdownlist to pull "User1 Steel" as the display and Client_ID as the value from the dropdown list.
how can we retrive records from sql-server between two dates. Dates are specied using DateTime datatype of C#. Also the stored date in sql is of Datetime type.
View 5 RepliesI am following this article [URL]
The code from the article is:
[Code]....
After commenting the lines in bold..I can upload word files too...The article also has
GenerateBrochureLink method...which generates link..but when i click the link to download my word file.i get some zip file...with xml.
How can i download the word file which i have uploaded with the view brochure link in gridview.
I want to retreive some data from an SqlDataSource using it's Selected event I've tried
DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty)
but here it's going into in infinite loop and then it gives me an StackOverflowException error in ASP.Net Development Server (my dev machine) and if I publish to IIS it requires me an user name and password to connect to server and gives an InternetExplorer error "Sys.WebForms.PageRequestManagerServerErrorException. An unknown error ... status code returned was 400. The SqlDataSource is in an UpdatePanel. Maybe this is why I get this.
I'm developing a web application with ASP.net and Sql Server 2005.
How i can retrive data from database on every seconds basis?
For your information , I have a Server application which will update hardware status (every seconds) into database and
my web client need to retrieve and display out the latest status (every seconds)
how one would retrive a value stored among several values in a single database field?
For example, the MS Customize CreateUserWizard walkthrough [URL] adds the ability to save the users preference for subscribing to a newsletter and allowing their info to be shared as 1 value in the comment column of the membership database. The result ofaspnet_Membership.Comment is Subscribe=TRUE&ShareInfo=FALSE.
My question is if Subscribe=TRUE&ShareInfo=FALSE is in one field of the database, how would you retrieve just the Subscribe=TRUE value from the field and use it to send a newsletter to the proper users while ignoring the ShareInfo=FALSE value?
I want to retrieve the data from the last record of a table. For eg: I have sorted the data in my table and want the value from the last record? How can I do that?
Is there a way to check that "saving" data to a table was successful and then do something after that?
How can i retrieve the data in linqdatasource in code behind?i have a dynamic database design with column storing the datatype eg. text, int, date.i need to retrieve the value in order to populate the control and bind it.
View 5 RepliesI need to retrieve data based on 3 different selections(current year, 5 years, 10 years). If the user select current year, then I need to pull data with the most up to date year, if the user selects 5 years, then I need to pull data for 5 years from the most up to date year in database. I am trying to accomplish this in sql due to using object DataTables in asp.net 3.5. I am able to do this with separate queries but I need to accomplish this with one query. I was going to use CASE statements but not really sure if I am approaching this correctly.
View 9 RepliesIs there any method by which we can retrieve random data from a dataset or rather directly from a table.
For example, I have around 30 questions in my table, I just wanted to display 20 among them and that too in a random order without the same item repeating. Can we achieve this using SP or through some Dataset manipulation?
I have a page in my website where there is very little code-behind. I only have two lines of code in Page_Load() and the rest of the code is declarative ASP.NET code. I have a FormView control which uses a SqlDataSource to get some order information. The SqlDataSource calls a stored procedure called usp_GetOrderDetails, here's the code for the SqlDataSource:
[Code]....
<truncated>
What I want is to grab the screenshotId from the SqlDataSource when the usp_GetOrderDetails stored proc gets called and populate it into a field on the page called screenshotId. I then want to use this screenshotId to get an image from the database based on Id. populating the screenshotId field. How do I do this - do I need to have something like OnDataBound or something like that?
I need to retirve data from two tables...when i click a value in dropdown list, i need to retrieve values from two tables based on that id( which i have selected in dropdown)..so when i have written query ( "Select assign_issue.issue_assigned_to, assign_issue.created_on,assign_issue.last_Date,
issue_register.issue_desc,issue_register.issue_Priority from assign_issue INNER JOIN Issue_register ON assign_Issue.Issue_ID = issue_register.Issue_ID where issue_register = '" + ddlissueid.selecteditem.text + "'")..query is executing ..when it comes to dr = cmd.executereader()..Dr is unable to read..it is showing false when i trace..unable to read into while loop.
object og = GridView_EmployeeTimeSheet.DataSource;
System.Data.DataTable dt = new System.Data.DataTable();
dt = (System.Data.DataTable)og;
But getting null in og(object) and at run time Gridview is showing its required data...
I am in need to retrieve data from data base and display a field based on the drop down is selected
View 2 RepliesHow to retrieve the data from the session (Dataset) and save it into a database
[code]...
I try to use the ADO.net to retrive the basic data in details view or gride view of logged In person using 3-tire architecher. I don't want to use LINQ.
EmployeeBLL
EmployeeDLL
and basic information. after login user while click on the basic information page he will able to see his details only. do i need to bound the details in DLL class file if it is so giude me through sample page coding or or we can join the remote support using team viewer so you can guide me from the web also.
How a pdf file will save in database sqlserver(2008) and Reteriving all file(s)them in pageload() in required page? in C#
View 1 RepliesHow to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I have table called "Logs". It has username, sitename, actiondate and lastupdate columns.
From this, I hve created tempLogs (Temp table) using condition where lastupdate >= somedate.
Once I get records in my temp table, I then want to retreive all the records again from "logs" table corresponding to same
username, sitename?
How would I do that.
BTW: Join will not work.
I have a label control in my from. from database i need the values to the label
View 1 Replieshow do you retrieve a particular record in a table plus x number of records that comes after it, assuming it is ordered in a particular way?I want to retrieve 3 records, and I want record where Row_A = 2 to be the first record, and the next 2 more records that follows it, assuming it is ordered by Row_A.
View 2 Repliesusing MS sql management studio, how can I edit one existing trigger?
when I right click it 'modify' option is disabled?
How about the way to retrieve the contents of the trigger from the DB?
When I attempt to store the current time of 'DateTime.Now' in a column defined as time in a table within an SQL database, I get an error message that says: Cannot implicitly convert type 'System.DateTime' to 'System.Timespan'.
I have no trouble storing the current date of 'DateTime.Today' in a column defined as date, but this column will not also store time along with the date. The date column has properties that indicate it has a data and system type of date with a Length of 3 and a Numeric Precision of 10. The time column has properties that indicate it has a data and system type of time with a Length of 5, a Numeric Precision of 16 and a scale of 7. Did I define the time column incorrectly for storing the time of day?
