I have a sqldatasource control that I want to get the field values from as it is selecting. Is there any way to do this in the dsControl_Selecting event for each record without binding it to any control or formview? I would like to call dsControl.DataBind and retrieve the field values.
View 4 Replies
On my web pages I display the data as mm/dd/yyyy and that is how the user will enter the dates as well. But when I pass the textbox control that has the date in it as a parameter to the SQLDataSource control, I need it to be sent in the YYYY-MM-DD format for the AS400. Is there a way it can be changed in between?
View 7 RepliesMy ASP.Net 3.5 book just came in and I started reading the chapter on ADO.Net.
In the first portion of the chapter, it kind of hinted that writing code to access data was the old way (ie Creating a connection, command and datareader object and programmically binding the reader/dataset to a control).
It says that you should use one of the Data Source Controls, such as the SqlDataSource Control.
Is it best practice to start using Datasource Control like the the SqlDataSource Control or are these mainly for 'RAD'?
I'm putting the finishing touches on decent size ASP.Net application, I coded the Data Access Layer and I am wondering if I should have used the Data Source Controls but I always associated them with Rapid Application Development.
When I drag and drop an SQLDataSource control to my new web page it disappears after I set it up.
It exists in Source but I can't see it in Design. I'm doing the same thing I would do in VS 2005 and I can see the control in design view.
Why can't I see the control? I'm new to VS 2008 and .Net 3.5.
I use the sqldatasource control a lot with stored procedures. But this time I'm using some code I found online where I am defining the new sqldatasource in the code and using it. You can see this below. I am getting a NullReferenceException on the first SelectParameters line and not sure why. Do I need to add the parameters different?
Code:
Dim SqlDataSource As New System.Web.UI.WebControls.SqlDataSource()
SqlDataSource.ConnectionString = ConnectionString
SqlDataSource.SelectCommand = "MySprocName"
SqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
SqlDataSource.SelectParameters("Distance").DefaultValue = 25
SqlDataSource.SelectParameters("ZipCode").DefaultValue = "31410"
Dim arg As New DataSourceSelectArguments()
Dim dv As System.Data.DataView = DirectCast(SqlDataSource.[Select](arg), System.Data.DataView)
I have a query that I want to test the performance of when the query is included directly in the SqlDataSource versus when I call a stored procedure. Does anyone have suggestions on how I would be able to closely watch the actual steps here? I was thinking of turning on tracing and adding Trace.Write for each of the events that fire along the way. This doesn't seem efficient and I wanted to see if there was a better approach.
View 2 RepliesI have a SQLDataSource control that is calling a database stored procedure, and passing quite a large number of paramaters, and the stored proc returns records that populates a gridview control. When I walk through the code behind to determine the values being passed, is there any way that I can see exactly how the parameters are being formated and passed to the stored proc?
View 2 RepliesI have a checkbox template field in a grid view control. I want to execute some code when a checkbox is checked or unchecked - how do I do this? Which event is fired?
View 1 RepliesI have a doubt regarding displaying data in gridview. I have comma separated values in a particular field in my database. Will I be able to display the comma separated values from db table in a control in the Item template field of my gridview?
View 2 Repliesi have passed the values from clientside using querystring. Below link displaying like URL>..i want to encrpyt the following code
?id=vidhansabha&cat_name=Industries&email=rafi045@gmail.com&mobile=9786629228
I'm looking for the easiest way to bind data from a SqlDataSource to textboxes dropped in Visual Studio 2008.
For example, I have 4 textboxes currently that have Address, City, State, Zip. I also have a SqlDataSource on the page fetching the ID of the record and selecting those 4 fields based on ID.
How am I able to quickly bind each box to those particular fields selected? I would think this would be really straight forward - but seems it's not. Seems like the answer is funneled towards having to create a GridView or some type of control.
I am working on a form that I would like to display a dropdownlist or textbox to insert data into the same field.
Currently it is setup where the end user can use one or the other but not both. I am running into a problem getting with the insert parameters for the secondary control. In this case the textbox.
Is it possible to use and Or statment in my Insert Query? I have tried to no avail.
[Code]....
I have a datasource that is connected to a stored procedure and I need to do a postback on the web page but do not want the sqldatasource to do a databind. What I am doing is when I change a dropdown box to fill in some textboxes with specific dates, I do this on a postback so the textboxes are filled in with the dates. But the SQLDatasource control data binds again and shows new results in my gridview.
Is there any way to prevent this so I can just postback to fill in the textboxes?
I have a list of numbers I need to submit one at a time to a stored procedure to add to a table. I don't know any other way around this. The database for this is an AS400 so it's not like using mssql server. I have a connection string and use the SQLDatasource controls to select data because I can select a stored procedure with it to call. Now I need to do an update and if it was just one time of submitting information I would do it the same way. But I need to submit each number till I do them all. How can I do this? Do I still use a sqldatasource control and set the value to be pulled from like a session var and just loop through setting the session and then sqlds.databind over and over? I added a DBML but can't do that with the as400 stored procedures as far as adding them like I do mssql.
View 5 RepliesI hv a filed in db having 60 values. I want them to be displayed as checkbox values on my UI.but i want those checkboxes as 15 values in 1 column.15 in 2nd col.15 in 3rd col.and last 15 in 4th coln. how to do it?
View 3 RepliesI typically don't use the sqldatasource control but trying it out and can't seem to get the delete function working. It doesn't seem to be passing a parameter to my stored procedure. The error I get is: Procedure or function 'sp_DeleteCraigsListEntry' expects parameter '@craigslist_search_id', which was not supplied. Any thoughts?
Code:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="ds1" CellPadding="4" DataKeyNames="craigslist_search_id"
ForeColor="#333333" GridLines="None" >
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:CommandField DeleteText="x" ShowDeleteButton="True" />
<asp:BoundField DataField="craigslist_search_id" HeaderText="ID"
InsertVisible="False" ReadOnly="True" SortExpression="craigslist_search_id" />
<asp:BoundField DataField="craigslist_search_value" HeaderText="Search Value"
SortExpression="craigslist_search_value" />
<asp:BoundField DataField="craigslist_Search_entry_dt" HeaderText="Entry Dt"
SortExpression="craigslist_Search_entry_dt" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />............
When the data is retrieved through a stored procedure using the SQLDatasource control that is binded to a gridview control, I want to change some data that is in some of the columns. Can i do this in one of the events either in the gridview or data control? I know you can do some formatting on the aspx page side such as dates, etc. but was wondering if I can do it on the vb code side?
View 8 Repliesi have four radio buttons and one text box..i have to check the selected radio button value equals to the textbox value..
View 3 RepliesI have an SqlDataSource, which is filtered by two RadioButtonLists. The markup is as follows:
[Code]....
In my code-behind I add the filterexpression when the radiobuttonlists are changed
[Code]....
My problem is that while it works fine when changing the RadioButtonListProducts the filtering works nicely, there is a problem with the RadioButtonListStatus, that filters on the Boolean column, 'Godkendt'. It works nicely if its set to 'Alle' (No filtering on that parameter) but when set to anything else, no records are shown. I suppose the problem is in the filterexpression
[Code]....
Can a ASP.Net 4.0 Web Aplication use (or host) a silverlight control directly without first creating a Silverlight Application
View 4 Repliesi am using gridview where it fetches datas from sqldatasource, i want to made some calculations wit some fields from tables and then need to show in gridview. How to fetch single column values from sqldatasource. I only know this code which are used after displayed in gridview
Gridview1.Row.Cells[0].text.toString()
Im not sure why we have SiteMapProvider and SiteMapDataSource. I mean i know we can have different providers ( like XmlSiteMapProvider, SQLSiteMapProvider etc) but then why there is SiteMapDataSource added in between the Server Control and these Providers? why cant we directly assign SiteMapProvider to TreeView or Menu Control? The way it works right now Menu Control ->SiteMapDataSourve->SiteMapDataProvider
View 2 RepliesI wish to know if it is possible to directly reference a control's value within an SQL Command? I remeber seeing something that caught my attention at one time, but I can't seem to remember where I found it. I am just trying to see if this method could work without having to declare parameters. Here is a sample idea of what I am trying to use:
[Code]....
I have a details view that is bound to a sqldatasource. The datasource has some extra parameters besides the updated data on the screen, they are;
[Code]....
I am want to take the old values of the details view from the detailsview1_itemupdating event and add them as a parameter to my sqldatasource.
[Code]....
So how can I then add this as a parameter to my sqldatasource?
I was wondering if there is a way to generate the event handler of a control directly in the markup view and not in the design view.
View 6 Replies
