System Data Dataset Cannot Indexed Because It Has No Default Property
Aug 18, 2010
I have built a site and worked fine for me, when I passed to a collegaue to deploy into another site he gets the message in subject.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
If Not getQueryString("post") = 0 Then
postID = Request.QueryString("post")
BlogAdmin1.Buttontext = "Edit Blog"
Dim MyCommand As SqlCommand
Dim myAdapter As SqlDataAdapter
Dim ds As DataSet = New DataSet
Dim myUpdateconnection As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("conn"))
MyCommand = New SqlCommand("ADMIN_BLOG_SELECT_POSTBYID", myUpdateconnection)
MyCommand.CommandType = CommandType.StoredProcedure
MyCommand.Parameters.Add(New SqlParameter("@postID", SqlDbType.Int))
MyCommand.Parameters("@postID").Value = postID
MyCommand.Connection.Open()
Try
myAdapter = New SqlDataAdapter(MyCommand)
myAdapter.Fill(ds, "postData")
Catch exp As SqlException
Response.Write(exp.ToString())
End Try
If Not ds Is Nothing AndAlso Not ds.Tables(0) Is Nothing AndAlso ds.Tables(0).Rows.Count > 0 Then
BlogAdmin1.BlogTitle = nullToStr(ds.Tables(0)(0)("title"))
BlogAdmin1.BlogBody = nullToStr(ds.Tables(0)(0)("body"))
BlogAdmin1.BlogCategory = nullToInt(ds.Tables(0)(0)("category"))
End If
MyCommand.Connection.Close()
LoadData()
Else
Response.Redirect("/admin/blogs.aspx", False)
End If
End If
End Sub
First time using a dataset instead of a data reader, and I'm trying to fill both a datalist on my page, and set the selected item value for a drop down list. The datalist on the page is displaying properly, but I get this errorClass 'System.Data.SqlClient.SqlDataAdapter' cannot be indexed because it has no default property. when trying to set the selected value for the drop down list. Why can't I get the selected value for the drop down list to work properly?
What i am having trouble doing is set the current parameter to the current row at a specific column like e.row[column index]
For Each trow As TableRow In table.Rows
cmd1.CommandText = "dbo.directway" cmd1.CommandType = CommandType.StoredProcedure cmd1.Connection = conn [code].... Class 'System.Web.UI.WebControls.TableRow' cannot be indexed because it has no default property.
after creating a xsd dataset in one machine when i try to use the another in a application in another system though i can use it for fetching records & all i am not able to confidure it or preview data.i already have the connectin string in web config.what changes needs to be done so that the dataset from system 1 can work in ssytem2
I was working with SSRS in windows application,when I got this error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I have made the property of Dataset(.xsd) EnforceConstrints to False and error gone. Whether it will impact anywhere in the application in the future or it wont have any impact.
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'p2_area_name'.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'p2_area_name'.
Also, I need tp populate data from database in the Area dropdown but not able to do so..
I am having a problem about my gridview when it binds to an accessdatasource.
The error appears:
"DataBinding: 'System.Char' does not contain a property with the name 'Firstname'."
Here's my gridview:
[Code]....
Here's my code behind:
[Code]....
The error occurs when the selected index of the DDL is 1 and I have to bind it in an accessdatasource. First condition is working fine where I will check a value and put all items that matched the date criteria in a data table and then bind gridview in the data table.
The error is just when I bind my gridview in the accessdatasource.
AccessDataSource1.SelectCommand = "Select Firstname,Middlename,Lastname,Jobseeker.IdNo,SchDate,Time,Venue,JobPosting.JobCode,JobTitle from JobPosting INNER JOIN (Jobseeker INNER JOIN ApplicationProgress ON Jobseeker.IdNo = ApplicationProgress.IdNo) ON JobPosting.JobCode = ApplicationProgress.JobCode where PostingHr = " & Session("Id") & " and SchDate = '" & Date.Today.ToString("dd - MMM - yyyy") & "' " GridView1.DataSource = "AccessDataSource1" GridView1.DataBind()
I am writing unit tests for fluent Nhibernate, when I run the test in isloation it passes, but when I run multiple tests. or run the test more than once it starts failing with the message below System.ApplicationException : For property 'Id' expected '1' of type 'System.Int32' but got '2' of type 'System.Int32'
I tried translating this from vb but getting the error on e.Row.DataItem("CustomerID").ToString i tried varios things but no gooddbSrc.SelectCommand = "SELECT * FROM Orders WHERE CustomerID = '" + e.Row.DataItem("CustomerID").ToString + "' ORDER BY OrderDate";
Public Class CustomProfile Inherits ProfileBase Public Property AreCool() As Boolean Get Return Me.GetPropertyValue("AreCool") End Get Set(ByVal value As Boolean) Me.SetPropertyValue("AreCool", value) End Set End Property End Class
I don't know how to set the default value of the property. Its causing errors because without a default value, it uses an empty string, which cannot be converted to a Boolean. I tried adding <DefaultSettingValue("False")> _ but that didn't seem to make a difference.
I'm also using a custom ProfileProvider (CustomProfileProvider).
I have bound data to text values of many textboxes using dataset as follows,
[Code]....
Now I want to provide a navigation system such as first, previous, next, last buttons as there are many rows returned from the query. I tried but could not succeed.
i need to prepare a report as a table. but my table needs to contain data from two schemas. so my doubt is, is it possible to set two dataset names for a table in its property?