Data Access Application Block - C# Discussion Boards

Ennis Ray Lynch, Jr.7-Jul-06 8:23

7-Jul-06 8:23

private static Singleton instance;
public static Singletton GetInstance();

might though. Also, I read once, that private static Singleton instance = new Singleton(); would be gauranteed to be accessed in order and is not subject to threading issues. Whereas this.instance == null can cause threading problems.

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: Heh, doesn't work

Guffa7-Jul-06 23:45

Guffa

7-Jul-06 23:45

Ennis Ray Lynch, Jr. wrote:
private static Singleton instance;
public static Singletton GetInstance();
might though.

Yes, correct.

Ennis Ray Lynch, Jr. wrote:
Whereas this.instance == null can cause threading problems.

Yes, to make it thread safe you need locking.

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

RichTextBoxControl cursor position

Radu Sorin7-Jul-06 0:16

Radu Sorin

7-Jul-06 0:16

How can i change programaticaly the position of the caret in a RichTextBoxControl ?

Re: RichTextBoxControl cursor position

mav.northwind7-Jul-06 1:07

mav.northwind

7-Jul-06 1:07

Use RichTextBox.Select() and RichTextBox.ScrollToCaret().

Regards,
mav

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

Re: RichTextBoxControl cursor position

BoneSoft7-Jul-06 3:48

BoneSoft

7-Jul-06 3:48

or RichTextBox.SelectionStart and RichTextBox.SelectionLength...

If you just want to move the cursor, leave RichTextBox.SelectionLength = 0.

Try code model generation tools at BoneSoft.com.

Data Access Application Block AddInParameter method

Brendan Vogt7-Jul-06 0:12

Brendan Vogt

7-Jul-06 0:12

Hi,

Why when using this method is there no paramter size property to set? And does the method indicate that it is an input parameter?

Regards,
ma se

Re: Data Access Application Block AddInParameter method

Not Active7-Jul-06 2:56

Not Active

7-Jul-06 2:56

The size is implied by the DbType or calculated when necessary. That's the great thing about these blocks, it takes of the little things for you and allows you to concentrate on the solution.

Yes, as the name implies, this is for setting Input parameters. There is a cooresponding AddOutParameter and a simple AddParamater if you need more control.

Data Access Application Block

Brendan Vogt7-Jul-06 0:04

Brendan Vogt

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

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