DataSource Controls :: Get The Record Data Value From SqlDataSource Control And Store It As String?
Jan 26, 2011
I have one SqlDataSource control as DataSet with enable caching in one page aspx. Filtering is applied to this SqlDataSource control, so that the page always returns one record data.
My question: How to get the record data value from SqlDataSource control (one record data value) and store it as String variable?
I know this sounds odd. I have a SQL DB that I am pulling data from. I have to some math functions to get a percentage. So I am pulling all the data in my code and building a data table with the results. I am then trying to pass this into a chart control that I have, but it fails because the data source is not correct for the chart control. I know that the chart control will accept a SQLDataSource control as a data source because a built a example with it before using it in my project.So my question is how can I use the Data Table as a data source for a SQLDataSource Control? Or is there a way I can pull the data from my DB andapply the math needed in a stored procedure or something similar that I could create the procedure on my SQL server then add a SQLDataSource control to my page and use the stored procedure as the source for the SQLDataSource Control.
My insert is adding a record to the database in the call to the stored procedure in SQL Server, but a -1 is returned - Shouldn't it return 0 if the insert/update was successful?
I get the Erorr: Input String was NOT a correct format.
The first three controlparameters are STRINGS and they work fine.
However the last two populate the controlparameter from text boxes that can only accept numbers and decimal point.
First the text boxes for {3} and {4} string parameters in the SQL filterexpression: [Code]....
And then the SQLDatasource control parameters[Code]....
The last two control parameters are the ones is question as they feed {3} and {4} parameters in the filter expression, NOTICE how I set the type="double".The data input is expected to be like 152.25 or 3.6 or 4 etc,So why am I getting this error: [Code]....
I have a gridview and a SQLDataSource control. In my gridview I have 2 commandfields "Edit" and "Delete"
The "Edit" command field works as expected. Using the "Delete" command field I get the error below.
Server Error in '/DataControls' Application.
The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
I am going to use DetailsView control for the first time and before using it I thought I would like ask this question. Instead of using the SqlDataSource Object/Class Can i have my class to most of the functionality?In short I donot want to use the in build Sql Data Source control rather would prefer to write my own. Is it possible (I know it must be!) to write the custom SqlDataSource class.
what is the disadvantages of using SqlDataSource Control? apart from flexibility and more control on the retrieved data ;why most of the web developer prefer using code behind (db connection) instead of SqlDataSource Control?
i have a website with a gridview, i bind the SqlDataSource Control that i use for my Gridview with a StroredProc. but the storedproc has to get a value which is from a textbox so that the gridview can display a record.
after I pass querystring parameter to page,page works as expected,but after that when I change my control parameter(dropdownlist selected value how can I set querystring to null or empty...
In my online web-application User is inserting new records and when user enters record system gets current datetime (using below query) and insert into table.
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
For some reason the select parameter pAddId is getting set to null and get the following error when the content page is loaded If I hard code the value it works RA-01036: illegal variable name/number Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Oracle.DataAccess.Client.OracleException: ORA-01036: illegal variable name/number
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.
I have a bound data field, a detailsview, one of the records I have formatted to currency in the item template. Yet when I go to delete a record, I get a error message "Input string was not in correct format". Take away the formatting and the page runs fine. I tried changing the datatype from int to money, it makes no difference.
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.