DataSource Controls :: Sqldatasource1_selecting Method Is Not A Member Of Webform1.aspx?
Oct 19, 2010
I have a serious problem since yest, i have a grid and i have to pass parameter to datasource of grid during run time...i tried this way in grids it worked.yest wen i try to create a new grid and pass parameter thru onselecting method of grid. i faced problem.
here's my code:
[Code]....
when i run this code im gettin error that SQLDATASOURCE1_selecting is not a member of asp.webform1.aspx..
View 2 Replies
Similar Messages:
Feb 23, 2010
I have DropDownList and GridView on my page. GridView is popuated based on DropDownList SelectedValue.
DropDownList Populated as following
DropDownList looks like (after binding)
View 3 Replies
Mar 4, 2010
I have created a function that is called when a user wishes to upload a file to the database. The problem I am having is that it won't write the files to the database anymore. This function used to work before I implemented a treeview (which connects to the database). I am struggling to see how the treeview could have cause the file upload to stop working (the error may not even be related to the implementation of the treeview).
The error message I am receiving is: 'Update' is not a member of 'CMS.SiteFilesDSTableAdapters.SiteFilesTableAdapter'.
The code for the upload function is:
<System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, True)> _
Public Function AddSiteFile(ByVal FileData As Byte(), ByVal FileName As String, ByVal FileDescription As
[code]....
It is throwing the error at: Dim rowsAffected As Integer = Adapter.Update(SiteFiles)
' Return true if precisely one row was inserted, otherwise false
Return rowsAffected = 1
EDIT: I managed to solve this problem by following:
http://www.asp.net/%28S%28pdfrohu0ajmwt445fanvj2r3%29%29/learn/data-access/tutorial-69-cs.aspx
Basically, I had used an Inner Join to gather all the fields, and table adapters don't seem to like them.
INSERT INTO [SiteFiles] ([FileData], [FileName], [FileDescription], [FileType], [FileCreated], [FileCreatedBy]) VALUES (@FileData, @FileName, @FileDescription, @FileType, @FileCreated, @FileCreatedBy)
View 1 Replies
Oct 17, 2010
I have the following code that gives me the error "'DataSource' is not a member of 'gridview'.".
what's wrong here? I'm working in the page load of my aspx page
[Code]....
View 1 Replies
Nov 9, 2010
I have a public shared function and I'm trying to access the values of a text box and a session variable.
I'm getting the error "Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class."
Is there any way I can get to the values in the textboxes or session variables from within the method?
[code]....
View 2 Replies
Oct 18, 2010
I have an ObjectDataSource that I want to perform updates using a business entity i.e. Type="Object"). Since the values for the entity are within a user control, I have stored a reference to the control in Session and in the updating event, set the new instance to the value of the entity from the user contol property (which also pulls values from the form viaother properties of the control):
Protected Sub MasterDataSource_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceMethodEventArgs) Handles MasterDataSource.Updating
Dim entity As New Login()
Dim accountControl As AccountInfo = TryCast(Session("AccountCtrl"), AccountInfo)
entity = accountControl.Entity
e.InputParameters.Add("entity", entity)
End Sub
And here's the markup for the datasource:
<asp:ObjectDataSource ID="MasterDataSource" runat="server" EnableCaching="true" CacheDuration="10"
SelectMethod="SelectAll" UpdateMethod="Update" TypeName="Data.DAL.LoginDAL">
</asp:ObjectDataSource>
My question is, how can I get the update method to pass this entity to the update method in my BLL class? It seems the Update method requires an ID or reference to the original object to use in determining whether any changes have taken place, but I don't really want to do this. In other words, I just want to use the Update event on my ObjectDataSource to pass my entity to the method ("Update") I set as a property and then let this business method handle the update of the data. Shown below, is the BLL update method I want to call:
Public Overloads Function Update(ByVal entity As Login)
If entity Is Nothing Then
Throw New ArgumentNullException("entity")
End If
MyBase.Update("UpdateLogin", entity.Username, entity.Password, entity.FirstName, entity.LastName, entity.Role, entity.Region, _
entity.Email, entity.Title, entity.TierID, entity.Street, entity.City, entity.State, entity.Zip, entity.Mobile, entity.Phone, entity.Fax)
End Function
When I try to call this as it stands now, I get an error: ObjectDataSource 'MasterDataSource' could not find a non-generic method 'Update' that has parameters: ID, entity. Previously, I'd set up a long list of parameters of basic data types (string, int, boolean), but this is rather cumbersome and I was hoping to use an entity for this (FYI, I also got the same type of error when I tried this approach, but with the ID as the
last parameter in the list). Perhaps what I'm doing here is atypical to how the ODS is normally used?? Has anyone done something like this successfully?
View 1 Replies
Mar 14, 2011
Given an instance of a control SomeControl that is in a some file (could be a usercontrol/ascx, or an aspx) how can I get a reference to the class to which it belongs?
In a usercontrol, SomeControl.NamingContainer seems to be reliable.
In a page that inherits from a MasterPage, this will return a reference to the ContentPlaceHolder, not the actual class that defines the aspx. What I would want in that case is SomeControl.Page
Parent will return the parent control in the heirarchy so isn't much use.
Is there any method for getting this directly regardless of what kind of thing it is?
View 2 Replies
Jul 28, 2010
I am using ASPNET2008 I have been asked to replace DATAGRID with GRIDVIEW on WEBFORM1.ASPX.
For Pagination, I am having problem due to lack of knowledge to replace page 1,2,3,4,5,6,7 8, 0 with NEXT , PREV like I did it for DATAGRID. Have to use NEXT and PREV because the GRIDVIEW Pagesize = 20 while the rows from the TBLSALESTRANSACTION exceeded 350rows What I am trying to do is, each time the user click on either NEXT or PREV, This is what I want the GIRDVIEW to display. NEXT the GRIDView should display the next 20 rows and the LBLPAGE.text should display the page number of the current 20 rows, Eg. Page : 2 / 18 PREV the GRIDView should display the previous 20 rows from the current 20 row and the LBLPage.text should display the page number of the current rows, Eg. 1 /18.
Also, How do I determine logically whether it NEXT or PREV being clicked ? And how do I use this FLoadGridView to either display next 20 or previous 20 rows.
[Code]....
[Code]....
[Code]....
[Code]....
View 2 Replies
Feb 25, 2010
I have two member roles at my project:
1.) Administrator
2.) Member
From the toolbox in Visual Studio 2008, I have dragged and dropped the create user wizard into the stage. I aim that a guest can register itself and automatically join the "member" role. Not the role "administrator". How can I do that?
View 9 Replies
Apr 22, 2010
I am using VS2005, and a newbie at table adapters, DAL & BLL. I have a single dataset (in DAL) and 2 classes (in BLL) named Class1.vb and Class2.vb.
When I try to call a function from Class1 within Class2 I get the error "Reference to a non-shared member requires an object reference".
Here is a sketch of my code structure:
[Code]....
View 3 Replies
Dec 22, 2010
I am making a website to store invoices so i can mail them to clients. So i got a table for clients, invoices and one with invoice products/services. When an invoice has no products/services added to them and it returns null i get the error "the null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type."
I just started with linq. Before i always used mysql. Mostly i just had to call data from 1 table so forgive me if my linq query isn't really correct.
Dim invoices = From i In db.invoices _
Group Join p In db.products On i.id Equals p.invoiceId Into invoiceProducts = Group _
Select New With {i.client.naam, i.titel, (From iP In invoiceProducts Select iP.prijs).Sum}
i show the client's name, the title of the invoice and the total amount the clients will need to pay for products and services.
View 1 Replies
Nov 25, 2010
I have following model class:
public class WebModel
{
public List<ArticleModel> Articles { get; set; }
}
public class ArticleModel
{
public int ID { get; set; }
public double ValueParam { get; set; }
}
Then I have the controller with the two actions:
[Authorize]
public ActionResult Index()
{
WebModel model = new WebModel();
ModelConverter.ConvertToModel(model, controller);
return View(model);
}
[Authorize]
[HttpPost]
[ValidateInput(false)]
public ActionResult Index(WebModel model, string saveButton)
{
ModelValidation.ValidateWebModel(model, ModelState);
if (ModelState.IsValid)
{
return RedirectToAction("Create", "Article");
}
ModelConverter.ConvertToModel(model, controller);
return View(model);
}
And this is my view:
<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<Web.Models.WebModel>" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<%var controller = Session["controller"] as Web.Code.SessionController; %>
<%Html.BeginForm(); %>
<div>
<table width="100%">
<%foreach (var article in Model.Articles)
{%>
<tr style="text-align: right">
<td>
<%:Html.DropDownListFor(m=>m.Articles.FirstOrDefault(f=>f.ID == article.ID).ID, new SelectList(controller.CurrentProdukt.Articles.AsEnumerable(), "ID", "Name", article.ID)) %>
</td>
<td>
<%:Html.TextBoxFor(m => m.Articles.FirstOrDefault(f => f.ID == article.ID).ValueParam)%>
</td>
</tr>
<%} %>
</table>
</div>
<table style="width: 100%">
<tr>
<td>
<input type="submit" name="saveButton" value="Save" />
</td>
</tr>
</table>
<%Html.EndForm(); %>
</asp:Content>
If I press the submit button, I get to the second action method in the controller (the one with the HttpPost attribute). In this action, the object model itself is not null, but the "Articles" list inside is null.
View 2 Replies
Feb 25, 2010
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?
View 1 Replies
Mar 14, 2011
Back in my vb.net days, I had a gridview, that when a user clicked a select button in a templatefield, I could determine the row that the user selected. Trying to do the same in C#, but am lost in translation somewhere as it throws this error when trying to get the value. This is what I have, but it throws an error.
[Code]....
View 3 Replies
Jan 17, 2010
I have a Public Sub listed in a class file that I am using to store Select, Update,etc...methods for an Object Datasource. When I attempt to configure the datasource, the Class appears as a business object, but the sub within the class is not available for method selection. (It does not appear in drop down list in wizard.)
The sub exists, so where is a good place for me to start looking for a fix? I have part of the class file listed below:
[Code]....
View 7 Replies
Jun 7, 2010
what is the best way to position my asp.net controls on aspx page by simply drag n drop method is insert layer and then dragging controls to it by using position='absolute' a best solution.
View 1 Replies
Apr 14, 2010
I have a working web app that uses a web service which is compiled into its separate assembly. I have another class library project compiled as a separate assembly that serves as a proxy to this web service. This all seems to work at runtime but I am getting this warning at compile time which I don't understand and would like to fix:
I have dozens of webforms in the main project that reference the proxy class with no compile time complaints as this snippet shows:
[Code]....
And yet I have one webform (also in the root of the main project) which gives me the "not CLS-compliant" message but yet attempts to reference the proxy class just like the other ASPX files. I get the compile time warning on the line annoted by me with 'ERROR here..
[Code]....
This makes no sense to me. The file with the warning is called frmHome.aspx.vb; all others in the project declare things the same way and have no warning. BTW, the webservice itself returns standard datatypes: integer, string, and dataset.
View 4 Replies
Feb 10, 2011
Got a little dilemma I could use some guidance on. I'm trying to call an Interface method that resides in my Business Layer from within the template of a gridview in the same manner as below:
<%# GetEmployee(Eval("EmpId"))%>
i.e. it reads as follows:
<%# BusinessLayer.IEmployee.GetEmployee(Eval("EmpId"))%>
I'm actually getting the following error:
"An object reference is required for the non-static field, method, or property"
Which makes sense as I haven't instantiated as instance of the Interface. So the queston is how do I do it?
View 2 Replies
Jan 4, 2011
My Business Logic Layer has AddItem method that add's to Items table in db along with an entry in Balance table.AddItem method uses two TableAdapters Items & Balance. Both these have corresponding Business Objects as Item and Balance.
Here is the AddItem method :
[Code]....
ASPX Page with DetailsView & ObjectDataSource
[Code]....
Now executing this page generates error as
ObjectDataSource 'ObjectDataSource2' could not find a non-generic method 'AddItem' that has parameters: _item, _balance, ItemName, GroupId, CategoryId, AuId, Rate, TotalStrScale, OffsStrScale, OffsAE [code]...
View 1 Replies
Mar 10, 2010
difference between these two codes would be?
[Code]....
View 1 Replies
May 14, 2010
to call some piece of c# code via a trigger in sql, and if it is what's the easiest method to go about doing it.
View 3 Replies
May 14, 2010
I have one main doubt for long perioad, If we access the DB using SqlDataSource and ObjectDataSource, Can i know which is the fastest accessing the DB.
View 5 Replies
Jan 5, 2010
I right click on a TableAdapter, select Add Query, select using QueryBuilder, then select a field to filter upon, and add Filter as =@BookStem. Automatically the QueryBuilder adds the WHERE clause to my new query:HERE (BookStem = '@BookStem')When I press OK, I get "BookStem in expression is not part of the query". And filtering doesn't work.
View 1 Replies
Apr 14, 2010
I'm having a question about an update method using SQL To Entities. I'm sending an object to the class and i'm updating him sucefully, but i need to specify each property of object instead of update in once. For example
[Code]....
In this case, i'm updating name, age and country sucefully but i want to use instead of update each property one-by-one, something like this:
[Code]....
So, the C = New should fill the C with all New values on properties, but this isn't work. To update an object, i've to update each property individual or can i update all in one like C = New?
View 3 Replies
Feb 19, 2010
i am having a datatable with 10 rows.
Out of this 10 rows 3 Rows have their RowState as Added, 2 rows as Modified, and 4 as Deleted.
Now i want to use Datadapter's InsertCommand, UpdateCommand and DeleteCommand
Is it possible to update datatable's changes to Database with Single DataAdpater.Update(DataTable) Call.
Means i will call DataAdapter.Update(DataTable) method only once and with this all new added rows should be inserted in database, modified rows should be updated and deleted rows should be deleted from Database.
View 3 Replies
