Crystal Reports - Runtime - C# Discussion Boards

Brendan Vogt7-Jul-06 0:04

7-Jul-06 0:04

Hi,

I am using the data access application block January 2006. It's the first time that I am using it. Can someone please look at my code and comment on it, I want to know if I am doing this correctly, and if there is anything I need to add or to close/dispose. Am I checking for the correct exceptions? Basically I want to return a strongly typed list of Vendor objects:

public static List<Vendor> GetAllVendors()
{
DbCommand dbCommand = null;
List<Vendor> vendorList = new List<Vendor>();

try
{
// Load the default database
Database db = DatabaseHelper.DatabaseDB;

// Specify the stored procedure
string strSProc = "sp_Vendor_GetAllVendors";

using (dbCommand = db.GetStoredProcCommand(strSProc))
{
IDataReader rdr = db.ExecuteReader(dbCommand);

while (rdr.Read())
{
Vendor objVendor = new Vendor();
objVendor.ID = DatabaseHelper.GetInt(rdr["VendorID_PK"]);
objVendor.Status = DatabaseHelper.GetBool(rdr["VendorStatus"]);
// Add Vendor instance to array
vendorList.Add(objVendor);
}
rdr.Close();
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
dbCommand.Dispose();
}

return vendorList;
}

Hope someone can let me know!

Regards,
ma se

Re: Data Access Application Block

Not Active7-Jul-06 2:49

Not Active

7-Jul-06 2:49

Nothing major that I can see.

Although there is nothing wrong with calling dbCommand.Dispose in the finally block it is technically unnecessary as it will be disposed when the using block is exited.

I would also consider using DataTable.Load(db.ExecuteReader). That way you could close the db connection sooner and still iterate through the resultset.

DataTable dt = new DataTable();
dt.Load(db.ExecuteReader(dbCommand));

// Close connection here

DataTableReader reader = dt.CreateDataReader();

while(reader.Reader())...

Webbrowser control - opening link in new window

Oohmesh6-Jul-06 23:59

Oohmesh

6-Jul-06 23:59

Hi Coders
I am using a webbrowser control in my winform application. I want to open all the links in the same window even though if the link is having the target=_blank property also.

Its very urget. Please help me out.

Oohmesh

Re: Webbrowser control - opening link in new window

Anh_Tuan7-Jul-06 1:34

Anh_Tuan

7-Jul-06 1:34

You need to add event handlers to handle "NewWindow" event when the user clicks on a link with the target not on the current webbrowser

1. For Pre Windows XP SP2

axWebBrowser.NewWindow2

2. For Windows XP2 and later there is another event named

axWebBrowser.NewWindow3

The whole code for this would look

axWebBrowser.NewWindow2 += new AxSHDocVw.DWebBrowserEvents2_NewWindow2EventHandler(axWebBrowser_NewWindow2);<br />
<br />
try<br />
{<br />
	axWebBrowser.NewWindow3 += new AxSHDocVw.DWebBrowserEvents2_NewWindow3EventHandler(axWebBrowser_NewWindow3);<br />
}<br />
catch ( Exception )<br />
{<br />
	// Not XP SP2 - just ignore<br />
}

Now in the event handlers all you have to do is block the new window from opening by putting

e.Cancel = true;

and redirect the current webbrowser to the new URL sent by the event.

See more at NewWindow3[^]

Jup

Re: Webbrowser control - opening link in new window

Jax_qqq12-Jul-06 5:27

Jax_qqq

12-Jul-06 5:27

Where i ll find this "axWebBrowser" class...Pls send the namespace.

Aur it's an coponent u r using... Smile | :)

Anuj

Re: Webbrowser control - opening link in new window

Anh_Tuan12-Jul-06 18:10

Anh_Tuan

12-Jul-06 18:10

That's the variable name. The activeX browser could be found on your system. With .NET 1.1 the simplest way is that you should import that COM component from system32/shdocvw.dll. .NET 2.0 already have a web browser control for you by default from the toolbox.

-Good Luck

Jup

Want code to Extract Table of content from a pdf file [modified]

Prathi.V6-Jul-06 23:31

Prathi.V

6-Jul-06 23:31

I need code to do the following in C#-
1. To display - The table of content from a pdf file in a pane on the left
side of the window
2. On clicking a topic in the table of content - It should diplay the
topic in a pane on the right side of the window.
Regards,
Prati

-- modified at 5:32 Friday 7th July, 2006

Crystal Reports - Runtime

SysJey6-Jul-06 23:00

SysJey

6-Jul-06 23:00

How to add text objects and others at run time. How to sort the fileds in report, choice of sorting field will be read from user.

Jey

FOP it

Support1236-Jul-06 23:00

Support123

6-Jul-06 23:00

hi all,

Sorry for posting this problem in the C# section aswell...
its just that i have been getting GREAT reply in the C# section

i have a xsl/xml Question.
<href>http://www.codeproject.com/script/comments/forums.asp?forumid=3421&select=1565540&df=100#xx1565540xx

He who laughs last...

How to find the Server IP using .net

rajkasa6-Jul-06 22:38

rajkasa

6-Jul-06 22:38

Hi I want to find out the server IP programmatically using vb or C#.
how can we do this?
My client wanted me to do a chat application where I have to specify the server IP automatically..
How can i do that?
Thanks

Re: How to find the Server IP using .net

stancrm6-Jul-06 22:49

stancrm

6-Jul-06 22:49

You must use the same method in MSN or Yahoo.
In your application, you must write the hostname (not host IP).
The hostname will be changed to IP automatically using DNS Server.

string problem ? help please ¿

cmpeng346-Jul-06 22:37

cmpeng34

6-Jul-06 22:37

hi all,

i have some lines ine a txt file like these :

this.tabPage1.Text = "SPECIFICATIONS";
this.tabPage5.Text = "COMPANY";
this.button3.Text = " EXIT";
this.toolTip1.SetToolTip(this.button3, "Quit Application");
this.button2.Text = " DELETE";
this.toolTip1.SetToolTip(this.button2, "Delete Record");
this.button1.Text = " SAVE";

...

i read them line by line but i am not able to process them Frown | :(

> i mean if i read the line: this.button3.Text = " EXIT"; what should i make to change button3's text to EXIT ?

regards,
bye.

ps: its a turkish - english translation process Smile | :)

first i copied all turkish texts in a file then copy all in another one and translated them into english.
now with a button i want to change the form language. can read anything from file but not dunno how to do the last step Smile | :)

Re: string problem ? help please ¿

stancrm6-Jul-06 22:58

stancrm

6-Jul-06 22:58

Put each line in this method:

static string GetValue(string input)
{
	string[] output = input.Split('=');
	output[1] = output[1].Replace("\"", "").Replace(";", "").Trim();
	return output[1];
}

For example :
input : this.tabPage1.Text = "SPECIFICATIONS";
output : SPECIFICATIONS

Re: string problem ? help please ¿

Guffa6-Jul-06 22:59

Guffa

6-Jul-06 22:59

You can't execute code dynamically like that. If you were just writing scripts instead of using compiled code, it could be done.

If you split them up in texts and toolstips, you could locate the controls using the name and change them. Just save the names and texts in the file, there is no reason to have it in a code-like syntax.

---
b { font-weight: normal; }

Re: string problem ? help please ¿

Nader Elshehabi6-Jul-06 23:15

Nader Elshehabi

6-Jul-06 23:15

Hello

You can parse and excute C# statements from text files but in your case it's not worth it. Instead you should store the names of your controls, and the the values. Then you might want to check them with if/else if statements. eg:

string MyReadLine = TextFile.ReadLine();
if(MyReadLine.StartWith("TabPage1"))
{
    string temp = MyReadLine.SubString(8);
    tabPage1.Text = temp;
}
else if(...

Another more advanced approach would be Reflection. Just type Reflection in your MSDN's index. Yet again I don't think it's worth it.

Regards Rose | [Rose]

Re: string problem ? help please ¿

Anh_Tuan7-Jul-06 2:18

Anh_Tuan

7-Jul-06 2:18

Try to see Globalization on this site like these:

http://www.codeproject.com/dotnet/globitfrmwk.asp[^]

http://www.codeproject.com/csharp/multilanguageapplications.asp[^]

Jup

Re: string problem ? help please ¿

V.7-Jul-06 1:10

7-Jul-06 1:10

You could find some info on ResourceManager and Culture Classes.

I've found a living worth working for, but I haven't found work worth living for.

<marquee> Beer | [beer]

instance of a crystal report

cellardoor07166-Jul-06 22:25

cellardoor0716

6-Jul-06 22:25

I made a simple report CrystalReport1.rpt which was added to my project (Add New Item => Crystal Report) I want to use the report in my project, but i don´t know how to create an instance of it...
I tried CrystalReport1 report = new CrystalReport1(); but that doesn´t work, i always get error: The type or namespace name 'CrystalReport1' could not be found (are you missing a using directive or an assembly reference?)

cellardoor

Re: instance of a crystal report

V.7-Jul-06 1:14

7-Jul-06 1:14

>Read up on how to use Crystal Reports in in VS.

You need to initialize the Crystal Reports Viewer and attach the report to it.
It's been a long time, but I remember looking that stuff up on MSDN[^].

there is an object model on there somewhere as well.
good luck.

I've found a living worth working for, but I haven't found work worth living for.

<marquee> Beer | [beer]

Marshaling Object

Anh_Tuan6-Jul-06 22:22

Anh_Tuan

6-Jul-06 22:22

Hi,

I have applications that need to communicate with each other using HWND_BROADCAST

Here is the prototype for unmanged code function SendMessage

[DllImport("user32.dll")]<br />
extern static IntPtr SendMessage(IntPtr hWnd, int msg, MyClass myClass, IntPtr lParam);

where WParam is passed as an object reference.

In the overriden WndProc method on the other application, the WParam variable is marshaled back to the original object like this

protected override void WndProc(ref Message m)<br />
{<br />
if (m.Msg == CommonMessageID)<br />
{<br />
...<br />
// myClass contains junk data here<br />
MyClass myClass = (MyClass)Marshal.PtrToStructure(m.WParam, typeof(MyClass));<br />
...<br />
}<br />
base.WndProc(ref m);<br />
}

However, it does not hold the information that was initialized by the other app. What did I do wrong here?

Jup

Re: Marshaling Object

mav.northwind7-Jul-06 1:14

mav.northwind

7-Jul-06 1:14

Hi!
You cannot simply stuff an object into an arbitrary SendMessage call and expect it to appear unchanged at another application.
SendMessage is sending pointers as parameters (wPar, lPar), but these pointers point to an adress in the current process adress space!

You can transmit simple datatypes (int) that way but no objects. In Win32 there's a special message WM_COPYDATA that's used to transfer data from one process to another, but I strongly doubt that this will solve your problem.

For transfering objects (or rather object references) you should use .NET Remoting.

Regards,
mav

--
Black holes are the places where god divided by 0...

Re: Marshaling Object

Anh_Tuan7-Jul-06 3:20

Anh_Tuan

7-Jul-06 3:20

Thanks, you're right. I forgot about address space. Should I access other's process address space to read/write data?

Jup

running a function in a thread

Mridang Agarwalla6-Jul-06 22:21

Mridang Agarwalla

6-Jul-06 22:21

i havea function in my app called CheckStatus. This take no prameters and returna a boolean value as the result. I am using it in a if..else statement like this:

if (CheckStatus() == true)<br />
    //Do somethins here<br />
else<br />
    //Do something else here<br />

Now what happening is that CheckStatus function takes some time to process and due to this my UI becomes non responsive. How can i acheive the above functionality by putting it in a separate thread. I'm pretty new to using Threading so it'd be great if someone could explain in a bit of detail. Thaks in advance!

Re: running a function in a thread

Anh_Tuan6-Jul-06 22:32

Anh_Tuan

6-Jul-06 22:32

Create a new thread to process time-consuming tasks.

Here is a simple example

using System.Threading;
...

ThreadStart ts = new ThreadStart(DoWork);
Thread t = new Thread(ts);
t.Start();

...

void DoWork()
{
// do my work here
}

Check out more at at Threading articles on here or MSDN Lib.[^]

Jup

Re: running a function in a thread

Adadurov7-Jul-06 0:22

Adadurov

7-Jul-06 0:22

I use to do it like this:

class SomeClass<br />
{<br />
  public Routine1()<br />
  {<br />
    // Show "Wait" cursor (hour-glass)<br />
    System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;<br />
<br />
    // reset completion flag<br />
    workDone = false;<br />
<br />
    ThreadStart ts = new ThreadStart(DoWorkWithStatusChecking);<br />
    Thread t = new Thread(ts);<br />
    t.Start();<br />
<br />
    // in this loop we wait for completion and<br />
    // processing GUI messages.<br />
    while( ! t.IsDone this.workDone )<br />
    {<br />
      // If you need to prevent user's interaction with GUI<br />
      // (clicking around, pressing buttons, etc.)<br />
      // you can pass message filter to Application.DoEvents()<br />
      System.Windows.Forms.Application.DoEvents();<br />
      // following line is here to prevent 100% CPU load<br />
      // but some people think it's not necessary<br />
      // i just dont have time to check it, 'cause it works just fine<br />
      Sleep(0);<br />
    }<br />
  }<br />
<br />
  bool workDone = false;<br />
<br />
  void DoWorkWithStatusChecking()<br />
  {<br />
    // This is what you want to do after status-checking.<br />
    if( this.Status )<br />
    {<br />
    }<br />
    else<br />
    {<br />
    }<br />
<br />
    // ... done, set <br />
    this.workDone = true;<br />
  }<br />
<br />
  bool CheckStatus()<br />
  {<br />
    // ... real status checking here<br />
<br />
    return ( true | false );<br />
  }<br />
} // end class SomeClass

Note: routine1 is not reenterable and must be guarded by some sort of guard condition in the beginning!

got the idea?

Alexei.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.