To connect to my database I used the wizard to make SQLDataSource. But I need to access it in code behind, to store my data in the database. Does someone knows how I can do that?
This is the code:
<asp:SqlDataSource
ID="MySqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:HELPDESK_OUTLOOKConnectionString3 %>" SelectCommand="SELECT
hd_aanvraag_fase.aanvraag_id,
[Code]....
Can the select command of a SqlDataSource be given by code in the code behind file. Also by calling the SqlDataSource.Select can the select statement be executed?
View 3 RepliesHow can i set sql parameters for an sqlDatasource in the code behind?
I am trying like this:
[code]....
i open a sqldatasource for binding on listview.
I would like also to read a field on first record for print it.
How can i access to my sqldatasource from code behind ?
I have a dropdown within gridview i have binded that dropdown with datasource values.
i will select any value from dropdown then it will save in database.
now i want to show the database value in the top value in same dropdown with sqldatasource.
Suppose i have value in dropdown from sqldatasource is test,test1,test2.
Suppose i have selected test1 then it will save in database now i want that dropdown show this values test1,test,test1,test2
What ive been using now is getting datas in code-behind, passing datasource into a Session, re-binds it to a gridview whenever there's paging/sorting needed. What i want to know is what is better if its performance we are talking about?
Is it datasource into a session Or SqlDataSource for which I know whenever paging/sorting needed is that sqldatasource opens up a DB connection to get the datas again?
what i would like to do is when the value of my sqldatasource is returned, then if it is null, run a code, in my case, redirect them to the login page, heres my code:
string connectionString = ConfigurationManager.ConnectionStrings["PokemonPlanetConnectionStrings"].ConnectionString;
string insertSql = "SELECT * FROM LoggedInUsers WHERE UserId = @UserId";
using (SqlConnection myConnection = new SqlConnection(connectionString))
[Code]....
Now what i would simply like to do is, if the select statement searches the database, and the result is not found, the simply redirect them to "register.aspx"
Basically, what I want to do is to get all my data in 1 statement and then pull data from that into a GridView. I already have the columns that I want displaying in the GridView, but now I want to insert a footer row in between the header row and all the datarows, that contains a couple columns that will be the same for every row in the GridView. So something along the lines of this:
Header1 Header2 Header3
Dept: Technology
data1 data2 data3
data4 data5 data6
data7 data8 data9
The thing is, I don't know what that "Dept" will be, so I want to pull it from my SqlDataSource that already has it.
i have a really annoying problem in that i need to programmatically create a SQLDatasource and then add it to my asp.net page on the load event. If I do this it all seems to work ok in terms of data binding but for all buttons on the page their postback events stop working?Is this a know issue or must I be doing something wrong?
View 3 RepliesUsing a FormView with a SqlDataSource, I'm attempting to Update data
by calling a stored proc in code behind. I was having trouble getting parameters
using Update Parameters in the SqlDataSource, but found a working solution by
coding the parameters.
The problem now is I'm getting an "Updating is not supported by data source 'XYZ' unless UpdateCommand is specified'.
Should i use dataset in code behind or SqlDataSource on the form designer to fill or bind a DropDownList in my asp.net page I am currently using SqlDatasource on the form and i bind the control to MySqlDatasource because i find it is very easy and to much faster but somebody told me to use dataset from code behind because of security and performance
View 3 RepliesIs 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?
I have a gridview that loads with a new datasource on button click event. On the gridview (which is located in a table columm incidentally) are 2 columns, a descriptor and a checkbox. The problem is that after postback, the column widths change, the checkbox column expands and the other column contracts. Is there a way to keep the gridview column sizes the same after postback?
View 2 RepliesI am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
Following is the code to insert userName from session and PageName into table to keep record that how many times a user does hit a particular page.
To avoid repitition of code I want to put the code in one class and want to inherit same code in each page.
How to get this task? Please do share with me? Here is the OK code:
[Code]....
what is difference between developing website using ADO.NET means using connection,command... object and using sqlDataSource?
View 2 RepliesIf I want to connect to a database in ASP.Net, is it better to use ADO.NET rather than SQLDataSource? They serve a similar purpose, correct?
View 7 RepliesIf I want to access the method in which we define update query, how can I access that method on aspx page & update the data in a grid view without direct use of an query on aspx page under sql data source?
View 28 RepliesI have a DDL with 2 options: "Trainer" & "Observer." I'd like to use the selection from that DDL to reference a field in the SqlDataSource SelectCommand.
There are 2 fields in the table that may be referenced in the SelectCommand:
"Trainer_Oracle_ID" & "Observer_Oracle_ID." I'm trying to do something like:
WHERE @Oracle_ID_Type = <%=DropDownList_Oracle_ID_Type.Text%>_Oracle_ID
i.e. User selects "Trainer" and the SelectCommand references the field called:
"Trainer_Oracle_ID."
the syntax for retrieving a value from a SqlDataSource? I've managed to get it working using numbers to represent the column, but I'd much rather use it's DB name?
[Code]....
I really do not have time to learn new language, in my case asp.net, but would like to start developing website in asp.net. I do not want to use asp:SqlDataSource control. is it ok if i write in codebehind aspx: all database connections and other CRUD operations in ado.net and c#. I already know xhtml, javascript - jquery, css, xml, json, some knowledge in sever-side coding (before php). want to start coding, instead of learning messy asp.net controls.I have to sit and learn all bloody ways of using those asp.net controls?
View 2 Repliesi have SQLDataSource and stored procedure "newsSelectLastHeading" that returns newsHeading
<asp:SqlDataSource ID="newsSelect" runat="server"
ConnectionString="<%$ ConnectionStrings:newsConnectionString %>"
SelectCommand="EXECUTE newsSelectLastHeading">
</asp:SqlDataSource>
[code]...
So I have a gridview within a gridview (I have a one to many table) my first gridview is working well, but my second gridview has a sqldatasource that has a select parameter(the default value was just for testing)
<asp:SqlDataSource ID="dsCountryByTripID" runat="server" ConnectionString="<%$ ConnectionStrings:bahDatabase %>" SelectCommand="spSelectCitiesByTripID" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:Parameter Type="Int32" Name="tripID" DefaultValue="56" /> </SelectParameters> </asp:SqlDataSource>
during my Gridview1 row databound I am trying to grab the columns that match the tripID. But dsCountryByTripID which is my datasource, is only going inputted with the last tripID.
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e) { GridView gv2 = (GridView)e.Row.FindControl("GridView2"); if (e.Row.RowType == DataControlRowType.DataRow) { dsCountryByTripID.SelectParameters.Clear(); DataRowView drv = (DataRowView)e.Row.DataItem; string tripID = (drv["pkiTripId"]).ToString(); dsCountryByTripID.SelectParameters.Add("tripID", DbType.Int32, tripID); //gv2.DataBind(); //e.Row.DataBind(); } }
So I have a gridview within a gridview (I have a one to many table) my first gridview is working well, but my second gridview has a sqldatasource that has a select parameter(the default value was just for testing)
<asp:SqlDataSource ID="dsCountryByTripID" runat="server"
ConnectionString="<%$ ConnectionStrings:bahDatabase %>"
SelectCommand="spSelectCitiesByTripID" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Type="Int32" Name="tripID" DefaultValue="56" />
</SelectParameters>
</asp:SqlDataSource>
during my Gridview1 row databound I am trying to grab the columns that match the tripID. But dsCountryByTripID which is my datasource, is only going inputted with the last tripID.
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
GridView gv2 = (GridView)e.Row.FindControl("GridView2");
if (e.Row.RowType == DataControlRowType.DataRow)
{
dsCountryByTripID.SelectParameters.Clear();
DataRowView drv = (DataRowView)e.Row.DataItem;
string tripID = (drv["pkiTripId"]).ToString();
dsCountryByTripID.SelectParameters.Add("tripID", DbType.Int32, tripID);
//gv2.DataBind();
//e.Row.DataBind();
}
}
I have a StoredProcedure called "usp_posts_getall" and it has 1 parameter called "@thisCategoryID"
in my "thisCategoryID", any values other than 0(zero) will return all the records in my Posts table.
Now I have a category menu items and each time I select, I set the value in my Session name called "SelectedCID".
So, How Do I ...
Create a SessionParameter Programatically in SqlDataSource?