C# Discussion Boards - CodeProject

Paddy Boyd5-Nov-07 5:21

Paddy Boyd

5-Nov-07 5:21

Smells a bit like homework...

led mike5-Nov-07 5:21

led mike

5-Nov-07 5:21

VarChar255 wrote:
The question is, what is the best algorithm to use to achive the above results?

I suggest the critical thinking algorithm. Good luck on your assignment, it's an interesting one.

Pete O'Hanlon5-Nov-07 9:24

Pete O'Hanlon

5-Nov-07 9:24

If the datasource for this is SQL Server 2005, then take a look at using Common Table Expressions (CTE). They will sort this out for you no problem.

Deja View - the feeling that you've seen this post before.

VarChar2555-Nov-07 5:42

VarChar255

5-Nov-07 5:42

No not homework at all... actually one of my developers is having trouble with this, he wrote the code but i'd like to get some opinions from others on what patterns they use.

Arsen

J4amieC5-Nov-07 5:56

J4amieC

5-Nov-07 5:56

VarChar255 wrote:
No not homework at all... actually one of my developers is having trouble with this, he wrote the code but i'd like to get some opinions from others on what patterns they use.

OK, lets flip this around then. What patterns would you use and we'll tell you whether we agree and which of your options sounds like the best way to us!

If you're telling the truth, and this really isn't homework, then you'll be willing and able to provide some responses. More likely we will see no response from you whatsoever.

Compare Static variable and Session variable

VarChar2555-Nov-07 6:25

VarChar255

5-Nov-07 6:25

Here is what my developer has implemented (excerpts)

void ProcesstopicChildren(DataTable dttopic)
{

similar while loop, but calling processtopic within whileloop.
}

main()
{
DataTable dtChildtopic;
DataTable dtParenttopic;
ItopicManager topicManager; // this is the SQL connector to call the SQL.
int ParenttopicID;

ParenttopicID = 8; // Just as a test
dtParenttopic = topicManager.GettopicView(ParenttopicID);

while(dttopic.Rows.Count > 0)
{
ParenttopicID = int.Parse(dtParenttopic.Rows[ParenttopicCount]["ParenttopicID"].ToString());
dttopic = topicManager.GettopicView(ParenttopicID);
ParenttopicCount++;
}
}

P.Murugs5-Nov-07 5:07

P.Murugs

5-Nov-07 5:07

Jus want to know which one wil be performance wise better either static or session variable?
If suppose i want to maintain one instance specific data(E.g: username) which one i should prefer to go for?
How does the static variable stored in Memory?
I believe static variable will be maintained as a single copy in Application domain.if it true then how does it allows to store instance specific data.
Please clarify me..

Regards,
Murugs.

Re: Compare Static variable and Session variable

led mike5-Nov-07 5:19

led mike

5-Nov-07 5:19

P.Murugs wrote:
Please clarify me..

There are actually very fine articles beyond the documentation for ASP.NET Application and Session objects on MSDN. Have you read the documentation and articles? If you find them confusing please explain which specific part is not clear?

Re: Compare Static variable and Session variable

P.Murugs5-Nov-07 5:46

P.Murugs

5-Nov-07 5:46

Yes..i have read some articles.
My query is if both the session and static variable allows us to store instance specific data's which one we opt to go for?
Tell me in terms of performance..
Thanks..

Use Form Authentication

whale845-Nov-07 4:44

whale84

5-Nov-07 4:44

I can't open any page in my website because they also auto switch to login.aspx page ? Why? Here is my code in file login.aspx :

private bool ValidateUser( string userName, string passWord )
{
SqlConnection conn;
SqlCommand cmd;
string lookupPassword = null;

// Check for invalid userName.
// userName must not be null and must be between 1 and 15 characters.
if ( ( null == userName ) || ( 0 == userName.Length ) || ( userName.Length > 15 ) )
{
System.Diagnostics.Trace.WriteLine( "[ValidateUser] Input validation of userName failed." );
return false;
}

// Check for invalid passWord.
// passWord must not be null and must be between 1 and 25 characters.
if ( ( null == passWord ) || ( 0 == passWord.Length ) || ( passWord.Length > 25 ) )
{
System.Diagnostics.Trace.WriteLine( "[ValidateUser] Input validation of passWord failed." );
return false;
}

try
{
// Consult with your SQL Server administrator for an appropriate connection
// string to use to connect to your local SQL Server.
conn = new SqlConnection( "server=localhost;Integrated Security=SSPI;database=HopNhacProj" );
conn.Open();

// Create SqlCommand to select pwd field from users table given supplied userName.
cmd = new SqlCommand( "Select Matkhau from tblThanhVien where TenDn=@userName", conn );
cmd.Parameters.Add( "@userName", SqlDbType.VarChar, 25 );
cmd.Parameters["@userName"].Value = userName;

// Execute command and fetch pwd field into lookupPassword string.
lookupPassword = (string) cmd.ExecuteScalar();

// Cleanup command and connection objects.
cmd.Dispose();
conn.Dispose();
}
catch ( Exception ex )
{
// Add error handling here for debugging.
// This error message should not be sent back to the caller.
System.Diagnostics.Trace.WriteLine( "[ValidateUser] Exception " + ex.Message );
}

// If no password found, return false.
if ( null == lookupPassword )
{
// You could write failed login attempts here to event log for additional security.

//lblMsg.Visible=false;
return false;
}

// Compare lookupPassword and input passWord, using a case-sensitive comparison.
return ( 0 == string.Compare( lookupPassword, passWord, false ) );

}

private void btnDangNhap_Click(object sender, System.Web.UI.ImageClickEventArgs e) //button login
{
if (ValidateUser(txtUserName.Text,txtUserPass.Text) )
{
FormsAuthenticationTicket tkt;
string cookiestr;
HttpCookie ck;
tkt = new FormsAuthenticationTicket(1, txtUserName.Text, DateTime.Now,
DateTime.Now.AddMinutes(30), chkPersistCookie.Checked, "your custom data");
cookiestr = FormsAuthentication.Encrypt(tkt);
ck = new HttpCookie(FormsAuthentication.FormsCookieName, cookiestr);
if (chkPersistCookie.Checked)
ck.Expires=tkt.Expiration;
ck.Path = FormsAuthentication.FormsCookiePath;
Response.Cookies.Add(ck);

string strRedirect;
strRedirect = Request["ReturnUrl"];
if (strRedirect==null)
strRedirect = "~/default.aspx";
Session["userName"] = txtUserName.Text;
Response.Redirect(strRedirect, true);
}
else
{
//Response.Redirect("../SubPages/Login.aspx", true);
lblMsg.Visible = true;
lblMsg.Text = "Tên đăng nhập hoặc mật khẩu không hợp lệ !";
txtUserName.Text = "";
txtUserPass.Text = "";
}

}

nothing

Re: Use Form Authentication

led mike5-Nov-07 4:55

led mike

5-Nov-07 4:55

whale84 wrote:
Why?

Indeed. What actually happens when the code executes? That might explain the "why", don't you think?

Re: Use Form Authentication

whale845-Nov-07 5:06

whale84

5-Nov-07 5:06

I mean I set as start page for default.aspx at the root of my solution.But when I compile ,I saw in Address bar of browser show the link of default.aspx but it switch to show the login.aspx page immediately.I try to set as start page for another page in my solution and the browser also show the login.aspx page like that.
In file web.config, i set :

<authentication mode="Forms">
<forms name=".ASPXFORMS" loginUrl="./SubPages/Login.aspx"
protection="All" path="/" timeout="60" />
</authentication>

nothing

RichTextBox Text Color

half-life5-Nov-07 3:35

5-Nov-07 3:35

Hi,

I like to know if there is a way to have multi color Text
like some text in red color The other Green and so on...

i tried this :

RichTextBox1.ForeColor = Color.Red;<br />
RichTextBox1.Text +="try Red";<br />
RichTextBox1.ForeColor = Color.Green<br />
RichTextBox1.Text +="try Green";

But of course it remember the last ForeColor;

maybe a nother Control to use will help???

THANKS

Have Fun
Never forget it

Pete O'Hanlon5-Nov-07 4:21

Pete O'Hanlon

5-Nov-07 4:21

IIRC you have to use the SelectionColor to do this. For instance:

int pos = RichTextBox1.Text.Length;
RichTextBox1.SelectionStart = pos;
RichTextBox1.SelectionColor = Color.Red;
RichTextBox1.Text += "try red";
pos = RichTextBox1.Text.Length;
RichTextBox1.SelectionStart = pos;
RichTextBox1.SelectionColor = Color.Green;
RichTextBox1.Text += " try green";

Deja View - the feeling that you've seen this post before.

half-life5-Nov-07 4:29

5-Nov-07 4:29

Sorry
Not working, Frown | :(

THNKS,

Have Fun
Never forget it

Pete O'Hanlon5-Nov-07 4:39

Pete O'Hanlon

5-Nov-07 4:39

Try this:

int pos = rtb.Text.Length;
rtb.Font = new Font(rtb.Font.FontFamily, rtb.Font.Size);
rtb.Text += "Hello";
rtb.SelectionStart = pos;
rtb.SelectionLength = 5;
rtb.SelectionColor = Color.Red;

Deja View - the feeling that you've seen this post before.

half-life5-Nov-07 4:48

5-Nov-07 4:48

Wow, It Works
Smile | :)

THNKS A million

Smile | :)

Have Fun
Never forget it

Color of Title bar

coder_help5-Nov-07 3:25

coder_help

5-Nov-07 3:25

Hi,

I am beginner in C#. I have a problem while coding in C#. The problem is somewhere in the application, i need to change the color of a Title bar of a window. Yes, title bar is where system menu, minimize,maximize buttons are located. Can anybody help me in doing this in C#? Pls help me ASAP... Thanks in advance

Regards,
Jitin Frown | :-(

Re: Color of Title bar

half-life5-Nov-07 3:31