DataSource Controls :: Parameter Data Changing Between DataSource_Inserting And The BLL Call?

Aug 26, 2010

I have a problem when trying to validate data on insertion (and possibly update, didnt try it yet) .

I use a formview in insert mode, linking to a custom BLL that then link to a DAL to insert data into a table. The problem is the parameter data is changing between the Datasource inserting event and when the BLL insert method is called. 2 field, that cannot be null in the database, have default value added to them. Bot sure how to explain so well so 'ill post some picture explaining :

This is the form I use, I enter only test in the textbox for the value Nom this is the trace for my DataSource_Inserting event, as you can see, only the "Nom" value is non-null But then, right after the event is done and the call is made to the BLL, the value for "Sexe" and "DateDeNaissance" has been changed to some default value, namely 0 and Jan 1, year 1.

This of course is causing problem because if the user does not provide value for "Sexe" and "DateDeNaissance" then I want the DB to raise an ArgumentException, I do not want to have default value inserted. It seem the problem is in my code, the problem happen before the actual Update call. I'm pretty sure the problem is between the Inserting event and the BLL input parameter but I am still beginning in C# and ASP.NET so I have no clue

View 3 Replies


Similar Messages:

DataSource Controls :: How To Call TableAdapter Stored Procedure With Nullable Parameter

Jun 24, 2010

I spent about 60 minutes sifting through search engine listings trying to figure this out and couldn't find an answer, so I decided to make this post for others.

Situation: Using a Stored Procedure to insert a row and return the new row ID, explained here. In my case, I used the Idenity_Scope to return the new row, like so:

[Code]....

Next, following steps as described in link above, went into the dataset XSD page, configured the table adapter to use this stored procedure. By default, it wanted my return value to be set to some value, but I set to allow Null (makes sense, since I don't want to pass the value in, I want to get it out, so it should be null to begin with).

Problem: Where I ran into an issue was in the method to call this stored procedure. The intellisense displayed the prototype it was expecting, basicly like this:

[Code]....

View 2 Replies

Forms Data Controls :: Changing Parameter In An Embedded DDL?

Jan 20, 2010

I have a DDL in templatefield of a details view. Its datasource pulls its parameter from a session field which is boolean. I've placed another DDL on the page that changes the session boolean in order to change the data displayed in the DDL in the template field. Whenevr I do this I get an error that states:"There is no source code for the current location."And when I click okay I get:"Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."Here is my code:

[Code]....

and

[Code]....

[Code]....

View 3 Replies

Forms Data Controls :: How To Call The Bindgrid In Sorting / What Parameter Should Be Passed

Dec 13, 2010

I am using VS 2010.I have a gridview, in which I am binding the gridview from list.

[Code]....

How to call the bindgrid in sorting? What parameter should be passed?

View 5 Replies

Forms Data Controls :: Changing DataSource?

Oct 8, 2010

I have created a webpage using wizards to set up the objects, can I change the name of all the datasources by just going into the code and entering the new database (the tables are identical) ?ORDo I have to work my way back through all the wizards and re-enter parameters?

View 3 Replies

DataSource Controls :: Changing Data Of Same Value In The Same Column Of A Datatable?

Mar 18, 2010

I have a datatable that looks as follows:

Make,Ford,0
Model,Fusion,0
Year,2010,0
Make,Ford,1
Model,Focus,1
Year,2010,1

I'd like to loop through each row and replace all the values of the same type in the 3rd column with a different value.

So for example I would change all the 0 to 1234 and all the 1 to 1235. So I'd end up with:

Make,Ford,1234
Model,Fusion,1234
Year,2010,1234
Make,Ford,1235
Model,Focus,1235
Year,2010,1235

Whats the best way to do that ?

View 2 Replies

DataSource Controls :: Updating Data Using SP Taking XML As Parameter?

Apr 29, 2010

I have store procedure which can insert the data to table(s) by parsing the xml parameter provided.

Now, I wanted to modify the script such that it will allow update.

[code]...

Now how I can modify the SP so that it will allow updating the stud table ?

View 1 Replies

DataSource Controls :: SQL Data Source With Null Parameter?

Mar 17, 2010

I have a SQLDataSource on an ASP.Net C# page. I want the ability to add a Control Parameter based on a DropDown List that will either display records that are either NULL or Not NULL In a Column. I have the following Code Snippet:

SelectCommand="SELECT [PATID], [LastName], [FirstName], [UIN], [Rate], [Account], [Project], [Supervisor], [HireDate], [Assistantship], [Hourly], [FundingStartDate], [FundingEndDate], [TerminationDate], [Citizenship], [TitleCode], [Email], [Notes],
[SupervisorUpdateEnabled], [SupervisorTargetSemesterCode], [PATCertDate] FROM [PATAccounts] WHERE TerminationDate @Terminated ORDER BY [LastName]"

View 5 Replies

DataSource Controls :: Filtering Data (searching) On Parameters (more Than 1 Parameter)

Feb 12, 2010

I want to make data-driven page and ability to filter data on some parameters, for example 3 text boxes and 2 dropdown lists and then show the results by the grid view control.

Actually I like input data in the text boxes and select item from dropdown list and then press "OK" Button and result (filtered data) show in the new page by the grid view.

What I have seen in the quick start tutorial is filtering by one parameter.

View 1 Replies

DataSource Controls :: Datatable Data Types And Command Parameter Datatype?

Apr 7, 2010

I am using VS 2008.I am building a datatable of records to be inserted into a SQL Server 2005 table.
The program loops through this table and builds a SqlParameter for each DataColumn in the datatable. The SqlParameters are used in the SQL Insert statement.

The field I am having a problem with is of type 'bit' in the database table and has no default value and cannot be nulls. The field is called 'Active' The meaning of this field in the application is Boolean i.e True or False. When inserting the record, I wish to default the field to "False".

When I define the columns in the datatable I am forced to use the following code to build the datatcolumn containing the boolean field i.e. dtcActive.DataType = GetType(Boolean) as there is no GetType(Bit)

Dim dtcActive As New DataColumn("Active")
dtcActive.DataType = GetType(Boolean)
dtcActive.Unique = False
dtcActive.AllowDBNull = False
dtcActive.DefaultValue = False
dtProviderDayDetails.Columns.Add(dtcActive)

However, when I build the SqlParameter I am forced to use this:

If field.ColumnName = "Active" Then
prm.SqlDbType = SqlDbType.Bit
prm.Value = "False"
End If

This is because there is no SqlDbType.Boolean. The problem I have is there is no value I have been able to give the SqlParameter that is accepted by the Insert statement. It complains that the boolean field cannot be null on Insert.

View 1 Replies

Forms Data Controls :: Pass A Parameter In DropdownList's Datasource Inside The Gridview?

Mar 31, 2010

I have 2 dropdownlist(ddlCategoryFooter and ddlItemCodeFooter)inside my gridview. I want to set ddlItemCodeFooter 's datasource to my getItemList(decimal categoryID) method. The selecteditem of ddlCategoryFooter will serve as the paramter which will be passed to my getItemList Method. Basically,ddlItemCodeFooter is dependent on ddlCategoryFooter's selectedItem.

I know it can be done in code behind approach but i prefer to place it in my asp page.

This i what i want to acheive:

DataSource ='<%# getItemList(Convert.ToDecimcal(ddlCategoryFooter.seletectItem))%>'/>

Source code for my Gridview:

[Code]....

View 8 Replies

Forms Data Controls :: Pass Parameter To Object Datasource In User Control?

Jun 30, 2010

I have a gridview inside a user control bind to an object datasource. Now I want to bind the object datasource with a parameter from parent page.

For this purpose I defined a public property in user control but how do I pass it with object datasource ?

I am calling from parent page like

myusercontrol.parameter=querystring["id"];

How to bind object datasource with my parameter ?

View 4 Replies

Forms Data Controls :: Changing Webpage Label Text Based On Datasource Field In A Repeater Control?

Jan 27, 2011

I have a web page that has a repeater bound to a data source. I beed to change a label inside the repeater based on the data that is in each repeater item. For instance, for the first item it might be one thing, and for the next item the label may be something else. I am currently doing some processing in the prerender event, but I don't know if I can or how to access the data source fields there. Where and how do I get access to the data in each item so I can change the label text?

View 3 Replies

DataSource Controls :: Variable Connection String Parameter In A DataSource Control

May 20, 2010

I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:

<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%&#36; ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%&#36; ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>

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.

View 1 Replies

DataSource Controls :: Access Property Of Object As Session Variable As Declarative Datasource Parameter Value

Oct 27, 2010

I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:

[Code]....

However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />

View 2 Replies

DataSource Controls :: Can't Call Method In Code Behind From Data Source Control?

Nov 18, 2010

I want to call a method in the code behind file from the aspx file, but I can't get the TypeName propery correct.

I can call methods in the dll:s in the bin folder and from files in the app folder, but not from code behind in the aspx page. What do I need to do.

View 1 Replies

Forms Data Controls :: Deleting From GridView Without Call Datasource's Delete Command

Jan 21, 2010

I'm using the asp.net membership on my website. On the User Administration page i've got a GridView to show the details of the users on the site. As a datasource rather than just using the Membership.GetAllUsers function i've got a SQLDataSource as i need to display user information from 3 different tables. I'm trying to add a delete button to the GridView. I'm setting the Membership's UserName as a DataKey and then using the RowDeleting event to call Membership.DeleteUser for the appropriate UserName. This works fine and the user is deleted however i then get an error showing up that "Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified."

I don't want to use the SqlDataSource for deleting as i've already done it using the Membership. How can i stop it from trying to do this? Here is the cut-down that i have if you're interested. The selectcommand in the sqldatasource was auto-generated by it.

[Code]....

View 5 Replies

DataSource Controls :: Passing Parameter To Datasource In Code Behind?

Mar 25, 2010

I need to pass the control parameter to Sql Datasource in code behind,

<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"

View 3 Replies

DataSource Controls :: SQL Server 2008 Keeps Changing Password Of Logins?

Jan 3, 2010

When I create a new login for my SQL Server 2008 I also specify a password for this login. But when I, after the creation is done, check the login's properties the password is much longer than the one I specified. If I here change the password once again, SQL Server 2008 will automatically change the password for the login - again. ANd I don't know what the password that SQL Server keep putting for my logins, since the password consists of small black dots.

View 4 Replies

DataSource Controls :: Changing Paramter Type Of Integer To String?

May 20, 2010

How can I change the parameter value from Interger to String.
Here below is the part of the code that creates problem; the constant "sqlStatement" is as string, but when the parameters "@ProdColor" read the value it returns an integer instead of the proper type which is a string. I have tried every ting like: CType(sqlStatement(splitItems(1)), string)
Or convert or parse, but it keeps returning the wrong type.

Const sqlStatement As String = "INSERT INTO ProductDetails (ProdID,ProdColor,ProdSize) VALUES"
If item.Contains(",") Then
splitItems = item.Split(",".ToCharArray)
cmd.Parameters.AddWithValue("@ProdID", SqlDBType.Int).Value = sqlStatement(splitItems(0))
cmd.Parameters.AddWithValue("@ProdColor", SqlDBType.NVarchar).Value = sqlStatement(splitItems(1))
cmd.Parameters.AddWithValue("@ProdSize", SqlDBType.NVarchar).Value = sqlStatement(splitItems(2))

View 9 Replies

DataSource Controls :: DetailsView Edit Options After Changing Database

Sep 13, 2010

I had a DetailsView control for editing records in a Access 2003 database. I transfered the database to MS SQL 2008 and using the same code does not work - after clicking edit nothing happens (no error) and the record is not updated.

[Code]....

View 3 Replies

DataSource Controls :: Dynamically Changing Linq To Sql Sproc Names?

May 12, 2010

I have to be able to dynamically change the sproc name that is used in a Linq to SQL query. I see in the dbml designer this:

[Function(Name="dbo.InsertUnknownMessage")]

View 4 Replies

DataSource Controls :: Alter Query - Changing A User's Role?

May 9, 2010

I need to change a user's role in my application. Therefore I need to know the correct syntax in code behind to alter a user's role; i.e. string sql = "ALTER TABLE ...etc". I'm not sure how to implement this at all. Is it similar to the INSERT INTO query used in code behind, where we define the parameters etc?

View 2 Replies

DataSource Controls :: SQL Parameter Not Being Sent To Procedure

Aug 3, 2010

What am i missing or doing wrong here, when i debug, im seeing the selected value in the code behind, but when the page loads, it says the following:

Procedure or function 'Onsite_Report_Procedures' expects parameter '@rptNum', which was not supplied.
<asp:SqlDataSource

ID="SQLOnSiteReport"
runat="server"
ConnectionString="<%&#36; ConnectionStrings:connectn %>"
SelectCommand="Onsite_Report_Procedures"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="@rptNum" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

[Code]....

View 2 Replies

DataSource Controls :: How To Get SP Output Parameter From ODS

Aug 4, 2010

I have a stored procedure with output parameter. I encapsulate it with Table Adapter and BLL. Call it using ObjectDataSource in conjuction with formview, just like the one in Data Access Tutorial. How do I get the output parameter in event INSERTED of the ObjectDataSource in code behind (VB)?

My stored procedure looks like this:

[Code]....

My BLL code looks like this:

[Code]....

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved