I want to create a generic page which contains a gridview and sqldatasource. I want to put these two controls on .aspx (C#) page but bind them at runtime. It should have selectcommand, updatecommand, deletecommand and insertcommand. Stored procedures are created for that. Help is needed to make it. .
View 1 Repliesafter 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...
View 1 RepliesOnce sqldatasource has been setup, how does one bind web controls to the sqldatasource?
simple example binding 2-3 controls to a sqldatasource.
Two ddl inside gridview. on selecting first ddl1 fill next ddl2 by passing selected value as parameter by executing the sqldatasource select command in codebehind.code:
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent; //find the control in that DropDownList d1 = (DropDownList)gr.FindControl(ddl1); DropDownList d2 = (DropDownList)gr.FindControl(ddl2); SqliaDataSource.SelectParameters.Add("@name", d1.SelectedItem.Text.ToString()); dataView dv=(dataview) SqliaDataSource.select(DataSourceSelectArguments .Empty);
Error: There is no source code available for the current location. and Returns null value
i couldnt find a specific answer to this question, i am relatively new to .net :)
i have a gridview that is displaying data from a sqldatasource in my page_load event. i need to loop through the records and update each value of a particular column BEFORE being set into the GridView.
i have tried converting to a data set and looping through updating the values, however it seems that one i initially run my query the values get set right into the GridView and i can't update them after that.
Do I need to add one of the GridView functions like Databound and do the loop in there?
I am not able to figure out why I am getting the null error at SqlDataSource10.Insert(); I tried running through break points and i checked the Insert statement and it has all the required values .. but I get error saying it cannot insert null into NrNarrativeDays. I am working off a sample at this link..
http://www.aspdotnetfaq.com/Faq/How-to-insert-row-in-GridView-with-SqlDataSource.aspx
[Code]....
Datasource and Gridview code is below
[Code]....
I am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
I have an user control placed on a content page. The content correctly receives the session variables. In the user control I have the following
1. The pageload fires and the text box is correctly set.
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (Session["app_id"] != null)
{
txtAppId.Text = Session["app_id"].ToString();
}
</script>
2. I have datagrid in the usercontrol which has a binding variable tied to a control parameters as follows
<asp:SqlDataSource ID="SqlDataSourceMain" runat="server"
ConnectionString="Myconnectionstring"
ProviderName="MyProvider" SelectCommand="select
last_name,first_name
from applications
where (id = to_number(:pAppId))">
<SelectParameters>
<asp:controlparameter name="pAppId" controlid="txtAppId" propertyname="Text" />
</SelectParameters>
<SelectParameters>
<asp:controlparameter name="pAppId" controlID="txtAppId" propertyname="Text"
Direction="InputOutput" Type="Int32" ConvertEmptyStringToNull="True" />
I tried the following, same error
</SelectParameters>
<asp:SessionParameter
ConvertEmptyStringToNull="True"
DefaultValue="0"
Direction=" InputOutput "
Name="pAppId"
SessionField="app_id"
Size="integer"
Type="String" />
</asp:SqlDataSource>
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
I want to send multivalued parameter to SQLdatasource via gridview control.
My slect query is like
SELECT * FROM FRUITS
WHERE FruitID IN(@FruitIDs)
how can i achieve that?
Is Sqldatasource powerful? Is there any disadvantage using it over other controls?
And How to use Sqldatasource from code behind with datacontrols like gridview,detailsview and formview?
Is it possible to completely customize the gridview using sqldatasource from code behind?
VS2010/C#. I have a gridview bound to a SQL Server table with the default SELECT statement returning only a few rows. This is straight out of the box, so no need to show markup.
Upon a button click event I update the datasource: SqlDataSource1.SelectCommand = hdnSQL.Value; Then bind: qlDataSource1.DataBind();
But when I run this, I get this error:
System.Data.SqlClient.SqlException was unhandled by user code. Message=Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I am clueless. I have done this many times in the past and NEVER encountered a timeout.
I have a Dropdownlist in an itemTemplate in a gridview. My gridView binds to dataTable1 (from which the selected value for dropdown comes from) and dropDown binds to dataTable2 (i need to get DataValueField and DataTextField from here).
[Code]....
I m new in asp.net. I want to use gridview with a custom business object.
Should i have property in my custom object.is there a way to access object fields.
I am trying to bind the datasource of a ddl which is located inside the EditTemplate of a TemplateField.When is the best time to bind this datasource (after loading grid, before editing, ? (Note: I must do this in code behind).I am currently trying to bind it on the edit command:
[Code]....
The issue is that the list retrieved from the LoadLists method is null when passing to the LoadList method where the datasource is bound.
I am using a sql stored procedure which returns multiple result sets. By default Sql Datasource is binding the first result set to gridview. I want the second result set to be binded. I browsed all the properties in Sql datasource but could not find one to set this.
View 4 RepliesI have a datasource (quite heavy to run) and a Gridview on the page.
By default when the page is loaded the datasource and Gridview bind and display. However since the datasource is heavy I want on page load these 2 will not bind.
I want them to bind only on a button click. How to stop the datasource and Gridview from binding on 1st page load ?
I have few textboxes and I want to search the text (partial search is also required) in the database and then show the result in a telerik grid. The grid has to be hidden initially and when I click the search button it should show up and display the results.
View 2 RepliesI have a formview bound to an entitydatsource and it is working fine. here's the scenario though
If the querystring contains a "memberID" , I have setup an object datasource to fetch the results corresponding to the memberid from the database.
I want the name and email id fields in the formview to default to these values in the objectdatasource. How can you do this?
i 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 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?
I have a GridView bound to a SqlDataSource with a default SelectCommand defined as such:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" DataSourceMode="DataSet"
ConnectionString="<%$ ConnectionStrings:MyConn %>"
ProviderName="MySql.Data.MySqlClient"
SelectCommand="select * from blah blah" />
There are cases where I have to change this query dynamically at runtime, so I do the following:
SqlDataSource1.SelectCommand = sql; // 'sql' is the new query
GridView1.PageIndex = 0;
GridView1.EditIndex = -1;
GridView1.SelectedIndex = -1;
GridView1.DataBind();
updatePanel.Update();
This works just fine actually, but when I click the pagination controls, the result set defaults back to the SelectCommand defined in the SqlDataSource1.
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?
If I have two listboxes, with a button between them, how do I update the Items of ListBox2 if ListBox2's items are databound?
<asp:ListBox runat="server" ID="ListBox1" DataSourceID="DataSource1"
DataTextField="Name" DataValueField="ID" SelectionMode="Multiple" />
<asp:Button runat="server" ID="addButton" onClick="addButton_Click" />
[code]...
I have a DropDownList which binds its SelectedValue to a field from an SqlDataSource. However, I need it to ignore the case when data binding, as if it's not in the correct case I recieve a lot of errors. Is this easily achievable?
View 1 Replieshow can i access the my sqldatasource selected datasource for modification and adding for example new datacolumns before binding??where is the best place to perform these modifications ?i guess SqlDataSource1_Selected is the right place, but i don't know how ?
View 1 Replies