Re: C# And ADO.NET N-Tier Help - C# Discussion Boards

Daniel Grunwald14-Dec-05 6:40

14-Dec-05 6:40

The comment in the rotor code is quite clear:
// Write out an int 7 bits at a time. The high bit of the byte,
// when on, tells reader to continue reading more bytes.

A length prefix consists of zero or more bytes in the 128-255 range and one byte in the 0-127 range.
The binary number zzyy.yyyy.yxxx.xxxx is encoded as 1xxxxxxx 1yyyyyyy 000000zz

The rotor code for reading:
474: protected int Read7BitEncodedInt() {
475: // Read out an int 7 bits at a time. The high bit
476: // of the byte when on means to continue reading more bytes.
477: int count = 0;
478: int shift = 0;
479: byte b;
480: do {
481: b = ReadByte();
482: count |= (b & 0x7F) << shift;
483: shift += 7;
484: } while ((b & 0x80) != 0);
485: return count;
486: }

PerfMon: Where are my counters?

Salil Khedkar12-Dec-05 23:50

Salil Khedkar

12-Dec-05 23:50

If you visit ‘Add Counter’ window in (WinXP) perfmon and select the ‘Memory’ performance object, you see several counters in the list below. Available bytes, Cache bytes and so on.

But for some reason my machine (WinXP) shows only one counter in this section. It happens to be ‘Available Mbytes’, only one entry. I have no idea where the others have gone. Frown | :(

I need to restore the default counters for ‘Memory’ performance object because I am working on a project which reads values of some of the counters I mentioned above. The code always fails on machine throwing an exception ‘instance name xxx is not valid for this counter category’

Can somebody help regarding what I can do to restore default performance counters? Confused | :confused:

Salil Khedkar [^]

Re: PerfMon: Where are my counters?

S. Senthil Kumar13-Dec-05 1:06

S. Senthil Kumar

13-Dec-05 1:06

Assuming you're missing counters specific to .NET, does running lodctr %WINDIR%\Microsoft.NET\Framework\v1.0.3705\CORPerfMonSymbols.ini at the command prompt help?

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: PerfMon: Where are my counters?

Salil Khedkar13-Dec-05 20:06

Salil Khedkar

13-Dec-05 20:06

No these were Windows performance counters (not specific to .NET) The CORPerfMonSymbols are all there.

Anyways, thanks man. Rose | [Rose]

Salil Khedkar [^]

C# And ADO.NET N-Tier Help

systemnyc12-Dec-05 23:15

systemnyc

12-Dec-05 23:15

Hi,

I am developing the Date Access Tier. Can soem one help me with a stand alone SqlDataReader. I have created a connection class and would like to then open the connection in the Data Access class, but I am stuck. Every piece of material that I read, just implements code in the same class. I Know that i can drag and drop the connection and all but i don't want to do that. I am new to coding.

<code>
public class Connectivity
{

private string ServerName = "";
//private string prvWINNTAuth = "";
//private string sDBInfo = "";
//private string sStaticDataConnectionString = "";
private string DatabaseName = "";

public Connectivity()
{
DatabaseName = "(Local)";
ServerName = "DataBase";
}
public SqlConnection SetConnection()
{
return GetConnection();
}

private string UserName
{
get{return prvUserName;}
set{prvUserName = value;}
}

private string Password
{
get{return prvPassword;}
set{prvPassword = value;}
}

private string DatabaseName
{
get{return prvDatabaseName;}
set{prvDatabaseName = value;}
}

private string ServerName
{
get{return sServerName;}
set{sServerName = value;}
}
<code>
private int WinNTAuth
{
get{return bUseWinSecurity;}
set{bUseWinSecurity = value;}
}

private int UserAccessLevel
{
get{return iAccessLevel;}
set{iAccessLevel = value;}
}

private string ConnectionString()
{
string connStr = "";
string sMsg = "";
try
{
connStr = "server=" + ServerName + ";" +
"integrated security=SSPI;" +
"database=" + DatabaseName;

}
catch (Exception ex)
{

connStr = "";
sMsg = "DataAccess: ConnectionString: " + ex.Message.ToString();
throw new Exception(sMsg);
}

try
{
if (WinNTAuth == Convert.ToInt16(vbWINNTAuth.vbUseApplication))
{
connStr = connStr + "user id=" + UserName + ";";
connStr = connStr + "PWD=" + Password + ";";
}
else
{
connStr = connStr + "persist security info=True;";
connStr = connStr + "integrated security=sspi;";
}
}
catch (Exception ex)
{
connStr = "";
sMsg = "DataAccess: ConnectionString: " + ex.Message.ToString();
throw new Exception(sMsg);
}

return connStr;

}</code>

private SqlConnection GetConnection()
{
<code>string sMsg = "";
SqlConnection conn = new SqlConnection(ConnectionString());
try</code>
{
conn.Open();
return conn;
}
catch (Exception ex)
{
conn.Close();
if(conn != null)
{
conn = null;
}
sMsg = "DataAccess: GetConnection: " + ex.Message.ToString();
throw new Exception(sMsg);
}
}
public void CloseConnection(SqlConnection conn)
{
string sMsg = "";
try
{
if (conn.State != ConnectionState.Open)
{
conn.Close();
if(conn != null)
{
conn = null;
}
}
}
catch (Exception ex)
{
sMsg = "DataAccess: Login: " + ex.Message.ToString();
throw new Exception(sMsg);
}

}
public bool Login()
{
string sMsg = "";
bool ret = true;
SqlConnection cn = new SqlConnection(ConnectionString());
try
{
cn.Open();

if (cn.State != ConnectionState.Closed)
{
ret = true;
cn.Close();
}
else
{
ret = Convert.ToBoolean(ConnectionState.Closed);
}
}
catch (Exception ex)
{
if (cn.State != ConnectionState.Closed)
{
cn.Close();
if(cn != null)
{
cn = null;
}
}

sMsg = "DataAccess: Login: " + ex.Message.ToString();
throw new Exception(sMsg);
}

return ret;
}
<code></code><code></code></code></code>

Re: C# And ADO.NET N-Tier Help

Ista13-Dec-05 2:37

Ista

13-Dec-05 2:37

just do a command object and return if

SqlCommand cmd = new SqlCommand( "<stroed procedure name>", conn);
cmd.CommandType = CommandType.StoredProcedure;

return cmd.ExecuteDataReader();

while to read:
while( myReader.Read() )
{}

I'm not an expert yet, but I play one at work. Yeah and here too.

Re: C# And ADO.NET N-Tier Help

systemnyc13-Dec-05 18:26

systemnyc

13-Dec-05 18:26

Thanks Ista.
Big Grin | :-D

Re: C# And ADO.NET N-Tier Help

Ista14-Dec-05 10:01

Ista

14-Dec-05 10:01

You can use Relection to populate the class also

Get the name of the field. Get the Name of the Property into a PropertyInfo object then call set value.

Then you wont have and hunky stored proc code for getting and saving.

Use CommandBuilder.DeriveParameters to get all the parameters dynamically

use the reader to step through

I'm not an expert yet, but I play one at work. Yeah and here too.

Re: C# And ADO.NET N-Tier Help

systemnyc14-Dec-05 17:23

systemnyc

14-Dec-05 17:23

Ista wrote:
You can use Relection to populate the class also

Get the name of the field. Get the Name of the Property into a PropertyInfo object then call set value.

Then you wont have and hunky stored proc code for getting and saving.

Use CommandBuilder.DeriveParameters to get all the parameters dynamically

use the reader to step through

I will try it tonight as I am still working on my project and will start in about five minutes. I will let you know if i have any other questions. thanks for the all your help Big Grin | :-D

using Authorization Manager and principal permission

keinan12-Dec-05 23:06

keinan

12-Dec-05 23:06

Hello
I am trying to use principal permission in my code, using the imperative security permission, as follow.

appAdmin.CurrentDomain.SetPrincipalPermissionPolicy(PrincipalPolicy.WindowsPrincipal);

void doMe()
{
PrincipalPermission iPerm = new PrincipalPermission(null,"RoleName");
iPerm.Demand();
}

And then I created a new role ("RoleName") and assign it to my user, using the azman console.

But when I am trying to run this code, I get the exception: "request for principal permission failed".

how to configure log4net for class library project

YogeshChoudhary12-Dec-05 23:03

YogeshChoudhary

12-Dec-05 23:03

how to configure log4net for class library project

Re: how to configure log4net for class library project

Anthony_Yio13-Dec-05 0:26

Anthony_Yio

13-Dec-05 0:26

I am not sure would it help cause I was using it for Winform .NET. Anyway, here is the link.

http://anthony-yio.blogspot.com/2005_01_01_anthony-yio_archive.html[^]

Sonork 100.41263:Anthony_Yio

-- modified at 6:27 Tuesday 13th December, 2005

Re: how to configure log4net for class library project

YogeshChoudhary13-Dec-05 0:46

YogeshChoudhary

13-Dec-05 0:46

Thanks for the reply. But the solution given in the website is for Winform or console but the same code didnt work for class library do you have anything for the class library.

Crystal Reprt

albCode12-Dec-05 22:56

albCode

12-Dec-05 22:56

How can I use CrystalReport in WebApplication.

Re: Crystal Reprt

Polis Pilavas12-Dec-05 23:04

Polis Pilavas

12-Dec-05 23:04

Why don't u google[^] it?

Regards,
Polis

Can you practice what you teach?

application pool getting recycled

savage_12-Dec-05 22:49

savage_

12-Dec-05 22:49

my application host server has a virtual memory and physical memory limit set (150mb for virtual, 100mb for physical) in iis application pool, now my application keeps getting recycled. event viewer says "process x from application pool y has reached its virtual memory limit."

how do i get around this?, ive used performance monitor to monitor my application, it doesnt seem to leak any memory.

any ideas?

What a character !!

IceWater4212-Dec-05 22:10

IceWater42

12-Dec-05 22:10

I have a string, oldWord, that contains exactly 1 space SOMEWHERE in it. I want to generate 26 copies of that word with the space being converted to a letter, 'a' through 'z'.

I tried this:

string oldWord;
string[] newWord;
...

for (int c = 0; c < 26; c++)
{
newWord[c] = oldWord.Replace(' ', 'a'+c );
}

The compiler complains about the parameter, 'a'+c , as being an "invalid char", as you probably expected. I've tried lots of different combinations, to no avail. Would you please tell me how i can code that parameter so i get the expected result?

Thank you.

Re: What a character !!

MarcelErz12-Dec-05 22:27

MarcelErz

12-Dec-05 22:27

Hi!

Do it like this:

newWord[c] = oldWord.Replace(' ', (Char)((int)'a'+c));

It converts the 'a' to a value, add the additional value and convert it back to a character.

Marcel Erz

Re: What a character !!

Anbuselvan12-Dec-05 22:40

Anbuselvan

12-Dec-05 22:40

Hi,

You can also try this ...

<br />
string oldWord = "Hello Welcome";<br />
string newWord = "";<br />
for (int c = 0; c < 26; c++)<br />
{<br />
  int newchar = (int)'a'+c;<br />
  newWord += oldWord.Replace(' ', (char)newchar );<br />
}<br />
System.Diagnostics.Debug.WriteLine(newWord);<br />

Result:

<br />
"HelloaWelcomeHellobWelcomeHellocWelcomeHellodWelcomeHelloeWelcomeHellofWelcomeHellogWelcomeHellohWelcomeHelloiWelcomeHellojWelcomeHellokWelcomeHellolWelcomeHellomWelcomeHellonWelcomeHellooWelcomeHellopWelcomeHelloqWelcomeHellorWelcomeHellosWelcomeHellotWelcomeHellouWelcomeHellovWelcomeHellowWelcomeHelloxWelcomeHelloyWelcomeHellozWelcome"<br />

Happy Programming!!! Smile | :)

Regards,

P.Anbuselvan
Sr.Software Engineer
Hyderabad

Re: What a character !!

Guffa13-Dec-05 3:27

Guffa

13-Dec-05 3:27

Here is another suggestion: Why not use a character counter:

int i = 0;
for (char c = 'a'; c <= 'z'; c++) newWord[i++] = oldWord.Replace(' ', c);

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

Re: What a character !!

IceWater4216-Dec-05 6:19

IceWater42

16-Dec-05 6:19

Thank you ALL for the excellent suggestions. I tried the 1st 2 suggestions before the 3rd was made ... they both worked great ... PLUS i got the added benefit of learning how to 'cast'.

Thanks again,

How to find the date of day before today ?

Yanshof12-Dec-05 22:03

Yanshof

12-Dec-05 22:03

Hi All

I need to find the date of the day before today and create string of this date.
I cant find the date of today and make less 1 from the date because i could get 0 in date (if i try to find the yesterday of 1.1.2005 i need to get 31.12.2004 ).

I sure that there is some build in method to do it -

Some one can help me ?

Thanks.

Re: How to find the date of day before today ?

akyriako7812-Dec-05 22:10

akyriako78

12-Dec-05 22:10

DateTime.Now.AddDays(-1);

Re: How to find the date of day before today ?

MarcelErz12-Dec-05 22:15

MarcelErz

12-Dec-05 22:15

Hi!

Just use the methode AddDays from the DateTime-class and give as parameter a negative value.

DateTime loDate = new DateTime();
loDate = DateTime.Now;
loDate = loDate.AddDays(-1);
MessageBox.Show(loDate.ToString());

other samples:

loDate = loDate.AddDays(-5); // Subtract 5 days
loDate = loDate.AddMonths(-3); // Subtract 3 months

Marcel Erz

Re: How to find the date of day before today ?

HakunaMatada12-Dec-05 22:25

HakunaMatada

12-Dec-05 22:25

Try using

DateTime dt = DateTime.Now ;
dt = dt.Subtract(new TimeSpan(1,0,0,0,0)) ;
Console.WriteLine(dt.ToShortDateString()) ;

Hope this helps. Smile | :)

Bikash Rai

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