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.
View 1 RepliesI am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj;
OdbcCommand cmdObj;
OdbcDataAdapter daObj = new OdbcDataAdapter();
public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) {
conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
[code]....
I want to add a field to dataset from another dataset in ssrs?
View 3 Replies[Code]....
[Code]....
[Code]....
i have a page for search.and there is abutton when user click on it.result get in dataset.
[Code]....
i have repeater in itemtemplate of repeater i put table and there is lable that i want show hotelname on it.but it has error.my code is:
[Code]....
the error is:DataBinding: 'System.Char' does not contain a property with the name 'hotelname'.
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
View 1 RepliesI mean, what is the faster way to get as fast as I can more than one table with stored procedure? Is there any study what is faster and why? There is a big problem getting more than one table at once with Entities, so the only way is DataSet. But I was told DataSet work very slow. Is that true?
View 2 RepliesI have a Listview control that DataBind programatically... ie I am NOT using SqlDataSource or such... I am attempting to sort a column... clicking on a link button that fires the "Sorting" event. So, after cliking on the column heading... I end up in this routine, where I hardcoded the .Sort = values (just for testing). The code is executed... but the RESULT show via Listview remains the SAME. No change!
How to fix this? I've seen some other posts examples that uses this event (ListView1_Sorting) and then sort via LINQ. I am not ready to try that...
Just want to know why dsPaymentList.Tables[0].DefaultView.Sort does not work?
I followed the example at: [URL]
protected void ListView1_Sorting(object sender, ListViewSortEventArgs e)
{
string sortExpression = e.SortExpression + " " + e.SortDirection;
DataSet dsPaymentList = new DataSet();
[Code]....
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
It errors here
BlogAdmin1.BlogTitle = nullToStr(ds.Tables(0)(0)("title"))
i am using datadrid and i want to display it in vertically but it is continiously showing in horizontally style. i have made changes in view , property but still not working.
View 2 RepliesI have a Hyperlink control in an ItemTemplate inside of a DetailsView. The DetailsView is inside a view of a MultiView which is inside of an update panel.
I am using binding syntax to bind the NavigateUrl property of the Hyperlink. However, the text shows up but when the mouse point moves over the hyperlink, the pointer doesn't change to a pointer hand like it should. And, nothing happens when the HyperLink is clicked. Here's the syntax I'm using:
<ItemTemplate>
<asp:HyperLink ID="hlWODWorkSpace" runat="server" ToolTip='<%# Eval("WorkSpace") %>'
NavigateUrl='<% Eval("WorkSpace") %>' Text='<%# Eval("Workspace") %>'
Target="_work">
</asp:HyperLink>
</ItemTemplate>
I'm trying to set the ImageUrl property after I've uploaded an image so that I can display the newly uploaded image, but for some reason it's not working.
If I navigate from the record I've just updated and then return back to that same record, the image then displays. It just doesn't display right after I've updated it. Basically what I'm doing is this:
Sub FormView1_OnItemUpdated(Sender As Object, e As FormViewUpdatedEventArgs)
Dim MyImage As Image
MyImage = FormView1.FindControl("Image1")
MyImage.ImageUrl = "image1.jpg"[code]....
I've left out the path intentionally because I'm pretty certain that the path I'm giving is correct... again, if I navigate away from the record and then return to it, the image displays. In addition, when I view the "Page Source" to view the resulting html, the src property of the image tag is blank . So, it's not a path issue... the issue is that its not setting the src at all which is why the image is not displaying.
I've got an odd problem and can't figure out what's causing it. We've got 2 different DataSets in the same project and I'm seeing different generated code from the MSDataSetGenerator. Both projects are .NET Framework 4.
In one DataSet, I can open the .Designer.cs file and there's a line like:
[Code]....
This essentially exposes a Transaction property to any partial class I create so I can do with it what I want (by setting it to something).
In the other DataSet no matter what I try to do, this Transaction property never gets generated. I've right-clicked on both DataSets and chose "Run Custom Tool" to get them to regenerate (I've even tried deleting the .Designer.cs file before doing this) and they both get generated the same.
I tried to make sure all the properties of the DataSets were the same. Both are using .NET Framework 4.0 and VS2010.
The file that does not generate the Transaction was from a .NET 1.0 asp.net web site that has continually been upgraded through different .NET versions. Right now it's at 4.0 but I don't know if that would have anything to do with it.
I have a detailsview, template as follows:
[Code]....
Codebehind: creating dataset, getting data from sql with adaptor and filling into dataset object, then setting detailsview's datasource.
I add 2 button to above template to able to edit data at asp page, and added event handlers:buttons:
[Code]....
My question is, what to do inside the detailsview update event function to able to edit and update data. My method can be wrong too.
I'm a bit new to VB .NET programming. I was given a project to build a web page for our Shipping department to pull up some order & invoice numbers, based on an order number parameter.
Basically, what I'm trying to do is, when the user enters an order number, I want the web page to display the invoices & invoice dates that are associated with the order number.
I've put together some code already, but not sure it is actually working. The web page comes up in Debugging mode and it acts like it is pulling data from the Oracle database, but nothing shows up in the Gridview (which I bound to the dataset... I think).
[Code]....
Being new to VB, I'm guessing my code may not be totally correct. I've tried lots of things and done tons of searching on Google, but nothing I've tried seems to work. At this point, I'm not even sure if the dataset is being populated correctly or at all either. I'm a bit lost right now and could use some expert thoughts.
In case it helps, my dataset has one data table in it (dtShipData). My dataset class is sdDataSet. I added 3 columns to the data table and the gridview, manually. Not sure if should do that or not. I don't have any SQL behind the datatable itself...
I've recently started working with SSRS 2008 and ASP.Net.I must develop a report with 3 different levels of detail. So, I decided the best solution was to develop 3 different reports and provide some drill-through mechanism in order to allow navigation. For that, I set the 'Action' property of one of the textboxes to 'Go to report' and set the correct url.The parameters passed to the report need to be validated first. So, for a matter of flexibility and better user experience I let the user enter the parameters using standard ASP.Net controls. When the user clics on my custom button 'Show report' the following code executes:
ReportViewer2.ServerReport.ReportPath = ".. my report path ..";
ReportViewer2.ServerReport.ReportServerUrl = new Uri(".. my report url ..");
ReportParameter p1 = new ReportParameter("dateStart", dateStart.ToString());
[code]...
This is bizarre and seems like a bug to me.Using a table in SSRS, I have a details row, with a parent group and finally a header row. For my header row, I am referencing a particular cell in the parent group.I am doing this so that i can have the header row repeat on each page of the group.his works fine when I'm not in Print Layout mode. However, when i switch to print layout mode, or print the report itself, the data that is presented on the screen is different then what is presented when not in print layout mode. WHAT THE F*!@!??
I've been battling this for a while now and i'm at my wits end. Has anyone else experienced different results from when you are in print layout mode as opposed to being in print layout mode?
I tried to find out about subject but with no success. The point is that in the beginning I've made many user controls. My site is too slow. I have not idea yet if it is because of user controls.
View 7 RepliesIam developing a custom server control of radiobuttton. it is working fine with the all the properties i wrapped except the grouping . somehow the grouping is not working .
[Code]....
I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.
I have installed BIDS 2005 and have opened the project in BIDS 2005.
When i open any file individually I get about 200 error messages.
Does anyone know what I need to do to convert the .rdl files to SSRS 2005?
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?
View 3 Replieshave a report that worked fine until we upgraded the SQL server from 2008 to 2008 R2 and the report viewer to latest version as well.This report has a pie display, NOW instead of showing one pie, it is showing 20 pies!I am trrying to learn how to resolve and what is causing this.
View 1 RepliesI've a MDX Query that has where clause as shown below.I'm designing report using SSRS 2008. How can i pass date as parameter? I tried to setup @from and @to as parameter but not working?
WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )
need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )
In my project I work with Entity Framework (LINQ to ENTITY). I only have ADO.NET Entity Data Model and a DAL (Data Access Layer). I also get the data due a WCFClientService. I have a gridview that needed to be exported in Excel.
FlexCel is a tool for generating Excel files based on a template. The only thing I see in demo's is that they work with DataSets.
Is there a way to convert the data in my gridview to a virtual DataSet?
I've written the following method to get the data:
[Code]....
Traditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?
So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.