Comments by Jean-Claude ADIBA (Top 24 by date)

yes it's possible to enter credential informations when you create the report (to locate the database), but i recommend you to do it in code to make dynamic because it's not sure that the credential of your dev environnement will be the same in production environment.

it's not best pratice but you can set your report credential directly in the production environment. and copy the file in application folder

you must do it manually for all reports and subreports (i suppose)

Hi i hope you found a solution to your problem if not. do you try the solution i gave below with the AssignConnection(rpt As ReportDocument)
method ?

I desagree I'm sorry, i inform you that after your post i don't edit the solution
you can see the editions history (http://www.codeproject.com/script/Articles/ListVersions.aspx?aid=690513)
yes i have edit just 20mn after my first publish jusT to add some precision but your comment was send later. i accept to be correct but please read before comment and downvote

Have you read my answer with his logic ? Solution 1 use TimeSpan and i show it. but he post his question in VB.NET Section so i wrote the answer in VB.net and i show the Existence of DateDiff (Dim timeDiff As Long = DateDiff(DateInterval.Hour, objDate1, objDate2)
).

He ask 2 Questions i try to give answer for these 2 question but Sergey no so ...
My answer don't need conversion any time. i show ealer how to get the part of time in the date as string (he uses a textbox) : Dim objTime As String = objDate.ToShortTimeString()
after i give how have difference between two date with TimeSpan

Dim objDate1 As DateTime = Date.Now()
Threading.Thread.Sleep(3000)
Dim objDate2 As DateTime = Date.Now()
Dim span As TimeSpan = objDate2 - objDate1
Console.WriteLine(span.TotalSeconds)

OK AS I TRY TO EXPLAIN YOU LATER, TO DELETE RELATED DATA IN YOUR SQLSERVER DATABASE YOU HAVE 2 SOLUTIONS

1. IN SQLSERVER ADD -ON DELETE CASCADE-STATEMENT TO YOUR FOREIGN KEY GuestId IN BOOKING TABLE BY USING SQL LANGAGE OR YOU CAN USE SQLMANAMENT STUDIO TO ADD IT WITH THE DESIGNER

ALTER TABLE [Booking] ADD CONSTRAINT FK_Booking_Guest_GuestId FOREIGN KEY( GuestId)
REFERENCES [Guest] ( GuestId)
ON DELETE CASCADE;

-ON DELETE CASCADE- PERMIT YOU TO DELETE AUTOMATICALY ALL RELATED ROWS IN BOOKING TABLE WHEN YOU DELETE THE GUEST.

BUT YOU CAN DO IT MANUALLY.

2. IN C# BEFORE DELETE A GUEST ROW.
- COUNT THE ROWS IN BOOKING TABLE WHICH HAVE THE ID OF THE GUEST ROWS YOU WANT TO DELETE
- IF COUNT >0 DELETE ALL THE DATA IN BOOKING TABLE WHICH HAVE THE ID OF THE GUEST ROWS YOU WANT TO DELETE
- NOW YOU CAN DELETE THEN GUEST ROW

no matter ! so mark that your question has been solve by the solution 1 ! it remove your question to the unanswered questions liste ;)

what laguage do you want to use to delete the data in your two table ?

OK Don't use this line System.Data.SqlClient.SqlConnectionStringBuilder(ConnectionString)
sqlclient is for sqlserver database

all you have to do is to remove this line form AssignConnection method
Dim con As New System.Data.SqlClient.SqlConnectionStringBuilder(YourConnectionString)

and provide your MYSQL DATABASE CONNECTION TO THE CRYSTAL REPORT ConnectionInfo Object
like this

connection.DatabaseName = "YourDataBaseName" 'myDataBase
connection.ServerName = "YourServerAdress" '127.0.0.1
connection.UserID = "UserID" 'root
connection.Password = "Password" '12345


Let's me know

i improve the assignconnection method

ok let's go slowly what SGBD do you use (MYSQL OR SQL SERVER)

hi i have improve the next solution for you by adding AssignTableConnection implementation and i try to reorder your code i hope it's help


<pre lang="vb">
Dim sqlQuery As String = "SELECT * FROM security_log where Middle_Name= '" & TextBox1.Text & "'"
Dim sqlAdapter As New MySqlDataAdapter
Dim sqlcommand As New MySqlCommand
Dim ds As New DataSet
Dim cryRpt As New ReportDocument

Dim rptDoc As CrystalDecisions.CrystalReports.Engine.ReportDocument
rptDoc = New CrystalReport3

With sqlcommand
.CommandText = sqlQuery
.Connection = sqlcon
End With

With sqlAdapter
.SelectCommand = sqlcommand
.Fill(ds, "security_log")
End With

' in the AssignConnection i used System.Data.SqlClient.SqlConnectionStringBuilder(ConnectionString)
'to get the connection by providing the connectionstring in parameter
'BUT YOU MUST USE YOUR MYSQL CONNECTION sqlcon
AssignConnection(rptDoc)
rptDoc.SetDataSource(ds)

ds.WriteXml("D:\secl.xml", XmlWriteMode.WriteSchema)

'YOU MUST ALLWAYS PROVIDE CONNECTION INFO TO YOUR REPORTDOCUMENT BEFORE OPEN IT
Form6.CrystalReportViewer1.ReportSource = rptDoc
Form6.Show()

</pre>

Thank you for your reply, I hope they will have tools to export from 10.1.18 build 8330 or upgrade to Universe 11.1. Let me know. THANK YOU

i have no tools to do this. if there is one tools i think it will be possible

there is no tools to export table

hi i have istall sql server 2012 and Rocket U2 Toolkit for .NET but when sql server 2012 try to extract data it doesnt see tables. i think its because the version of universe server is 10.1.18.0

How can i do ?

I don't have SQL SERVER 2012 I WORK ON SQL SERVER 2008 IS IT POSSIBLE ?

no matter you are welcome.

you cannot to be notified when an item change because ObservableCollection<t> collection only fires the CollectionChangedEvent.
Because you implement INotifyPropertyChanged, you will see changes to the items in the view (WPF does this automatically if you ), but if you need to execute manual actions when an item changes, you can use BindingList<t> and suscribe to BindingList.ListChanged event. with ListChangedEventArgs ( ListChangedEventHandler's proprety) you can manupulate your data in easy way.

Also you can always use ObservableCollection Class and handle datagrid CellEditEnding event like this:

private void dg_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
if (e.Column == yourColumn)
{
if (e.EditAction == DataGridEditAction.Commit)
{

TextBox t = e.EditingElement as TextBox; // Assumes columns are all TextBoxes

yourObject = e.Row.Item; //you must cast
yourObject.Property1 = t.Text ; // the value of the cell
}
}
}

Thanks for trying my solution. you know the binding system of WPF take sense with these classes because without them you will use WPF like any winform application.
I agree with you when you want to build your business classes as POCO without any of these kind of classes. To go further more you must build your application with MVVM architecture to take advantage of WPF binding. you must wrap your List<timesegment> object in ObservableCollection<timesegment> object in a viewmodel which will bind to your UI. follow this link to have more information about the MVVM pattern
http://msdn.microsoft.com/en-us/magazine/dd419663.aspx
regards

;) thank you for your precision