how to export table in my word document to xml - C# Discussion Boards

Re: Slow in displaying Crystal report

1-Sep-09 0:49

Please Check the following:

1) Which DB you are using.

2) Are you retrieving the data in Network

3) Is that Windows application or Web application

Check where is the actual delay

Is that in binding ?
Is that in Fetching ?

then you can get some idea.

sharad Pyakurel1-Sep-09 1:21

sharad Pyakurel

1-Sep-09 1:21

I have used Oracle10g Database. Yes is retrieved by client side from server. This is windows application.

In my report In crystal report oracle Database is not connected. used Dataset and DataTable. my coding pattern is like this.

private void btnTestReceipt_Click(object sender, EventArgs e)
{
ReportDocument rptdmt=new ReportDocument();
DataTable dtr=GetDatas();
string ReportName = Application.StartupPath + "\\Reports\\rptCashReceiptPP.rpt";

rptdmt.Load(ReportName);
rptdmt.SetDataSource(dtr);
CrystalReportViewer.ReportSource = rptdmt;
}

private DataTable GetDatas()
{
StringBuilder sb=new StringBuilder();
sb.Append("SELECT *from TableName WHERE CONDITION");
DataTable dt=_con.ExecuteDataTable(sb.ToString());

DsDataSet.UserDataTable dtrep=new DsDataSet.UserDataTable(); //This is object of DataTable of Typed Dataset named DsDataset.

foreach(DataRow dr in dt.Rows)
{
dtrep.Rows.Add(dr.ItemArray);
}
dtrep.AcceptChanges();
return dtrep;
}

Indexers Question

Programm3r31-Aug-09 23:49

Programm3r

31-Aug-09 23:49

Hi all,

I am looking for a more advance way of using an indexers. I have searched the net but cannot find anything that explains how I must accomplish the following:

I have three classes namely: Building, Controller, Reader (each with their own fields/properties/methods). I want to make use of an indexer to reference each of the classes so that it can following this pattern:

Building["MyBuilding"].Location = ".....";
Building["MyBuilding"].Controller["MyController"].Area = ".....";
Building["MyBuilding"].Controller["MyController"].Reader["myReader"].Tag = "......";

Many thanks in advance
Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Indexers Question [modified]

Keith Barrow1-Sep-09 0:01

Keith Barrow

1-Sep-09 0:01

Assuming you are not using static classes in your example:

Dictionary <string,Building> building = new Dictionary<string,Building>();
Building myBuilding = new Building();
//... Other stuff here....
building.Add("MyBuilding", myBuilding);
//Now You can:
building["MyBuilding"];

in the class definition of Building there should be a property like:

public Dictionary <string,Controller> Controller {get; private set;}

And follow the same method for Reader in the controller class.

Let me know if this isn't what you want.

modified on Tuesday, September 1, 2009 6:12 AM

Re: Indexers Question

Programm3r1-Sep-09 0:13

Programm3r

1-Sep-09 0:13

Hi Keefb,

Thanks for the response.

keefb wrote:
Let me know if this isn't what you want.

Well, kinda ... I was actually hoping not to make use of generics collections.

But on the other hand, lets see what I can do with this....

Thanks again.

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

how to export table in my word document to xml

dotgnu31-Aug-09 23:30

dotgnu

31-Aug-09 23:30

hello everybody,

how to export table in my word document to xml using visual c#. (I'm using office 2003)

Re: how to export table in my word document to xml

Md. Marufuzzaman1-Sep-09 2:53

Md. Marufuzzaman

1-Sep-09 2:53

Try this link.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

Thanks
Md. Marufuzzaman

Search Active Directory

Ferudun Atakan31-Aug-09 23:27

Ferudun Atakan

31-Aug-09 23:27

Hi,

I want to query the Active Directory for some objects. How can I list the objects than can be searched in AD. For example I want to find the Domain Controllers in AD.

Thanks,

- ferudun

Re: Search Active Directory

SeMartens31-Aug-09 23:28

SeMartens

31-Aug-09 23:28

Hi,

look at this great article:

Howto: (Almost) Everything In Active Directory via C#[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: Search Active Directory

Arun Jacob31-Aug-09 23:46

Arun Jacob

31-Aug-09 23:46

Search for DirectorySearcher class,

http://msdn.microsoft.com/en-us/library/ms180885%28VS.80%29.aspx[^]

Arun Jacob
http://codepronet.blogspot.com/

one click all records update datagridview

cursedsw31-Aug-09 23:21

cursedsw

31-Aug-09 23:21

hi;

i have a ms access mdb. my records customers. i want to change records. i want update one record and old value - new value; and plus all records remainders. how i made one click and update all records remainders?

sorry my bad english Smile | :)

Jacobb Michael31-Aug-09 23:34

31-Aug-09 23:34

hi,

where do u want to click and where do you want to update.

Reload the Datagridview to refresh.

cursedsw31-Aug-09 23:42

cursedsw

31-Aug-09 23:42

i have two value. one value price. and i want update price. but i need update price while all records change remainders. like this; (newprice-oldprice)+ all customers remainders. but iam update only one record price. i hope explanation my problem thnx.

Jacobb Michael1-Sep-09 0:04

1-Sep-09 0:04

you have a price column, when you change the price for a single customer
then the entire list of customers should be replaced with the same Price.

if it is why dont you have a another table like customer vs price

parameter in Event Handler

cursedsw1-Sep-09 0:11

cursedsw

1-Sep-09 0:11

because i need one datagridview preview. please look at this pic.
http://img140.imageshack.us/img140/4730/ssprogram22.jpg[^]

Saiyed Alam31-Aug-09 23:13

Saiyed Alam

31-Aug-09 23:13

Hello,,

Is it possible to send a parameter like below?

CheckBox oCheckBox = new CheckBox();
oCheckBox.Name = "cb_" + currentChild.ID;
oCheckBox.Click += new RoutedEventHandler(this.CheckClick);

Now I want to send the name of check box to the event handler. HOw can I do it?

Like

CheckBox oCheckBox = new CheckBox();
oCheckBox.Name = "cb_" + currentChild.ID;
oCheckBox.Click += new RoutedEventHandler(this.CheckClick,oCheckBox.Name);

so that in

CheckClick(object sender, RoutedEventArgs e)

I can get the name of that check box as there will be many dynamically created check box.

Keith Barrow31-Aug-09 23:24

Keith Barrow

31-Aug-09 23:24

One of the following lines should work, with the caveat that I'm a little rusty on WPF, so apologies if my answer isn't correct!

CheckClick(object sender, RoutedEventArgs e)
{
  CheckBox checkBox1 = (CheckBox)sender;
  sring id = checkBox1.Name;
  // or
  CheckBox checkBox2 = (CheckBox)e.OriginalSource;
  sring id = checkBox2.Name;
}

Saiyed Alam31-Aug-09 23:43

Saiyed Alam

31-Aug-09 23:43

Thanks ..

Jacobb Michael31-Aug-09 23:26

31-Aug-09 23:26

Just try with this.

CheckClick(object sender, RoutedEventArgs e)
{
string chkBoxName = ((CheckBox)sender).Name;
}

Saiyed Alam31-Aug-09 23:44

Saiyed Alam

31-Aug-09 23:44

Thanks ..It Worked

GMail - Can you Trace !

Jacobb Michael31-Aug-09 23:10