Vista Forums - .NET General

Best Approach to data storage in memory

Simon Whale — Wed, 18 Nov 2009 16:12:01 GMT

Thanks Gregory

it gives me some food for thought!

Simon

"Gregory A. Beamer" wrote in message
news:Xns9CC76E727E338gbworld@newsgroup

Quote:

> "Simon Whale" wrote in news:OO6kRmGaKHA.5300
> @TK2MSFTNGP02.phx.gbl:
>

Quote:

>> My question is what would be best for editing entries? List(of t) or
>> datatable?

>
> The list is lighter weight, so, if it is prudent, I would head that
> direction. But, there are factors that may make the list an issue.
>
> For example, if the list is rarely edited before committing, then making
> editing easier is not your primary concern. The primary concern is
> reducing errors on saving and using the most maintainable code possible.
> In this instance, the DataTable might be better, especially if you use
> TableAdapters to commit data.
>
> What you have to look at is the most common path combined with
> maintainability. That is first run. Then, see if there are any other
> issues , like performance, that makes you rethink your chosen path.
>
> One more thing to think of. If you are using the built in CRUD
> methdology with DataSets, you end up with a translation "layer" for your
> entries to turn them into a List(of T) and back. This is one potential
> source of error. I am not saying avoid this, but ask your motivation
> before you introduce this extra "complexity" into the app.
>
> Peace and Grace,
> Greg
>
> --
> Vote for Miranda's Christmas Story
> http://tinyurl.com/mirandabelieve
>
> Twitter: @gbworld
> Blog: http://gregorybeamer.spaces.live.com
>
> *******************************************
> | Think outside the box! |
> *******************************************

Can a prog find its own Name?

Barry Flynn — Tue, 17 Nov 2009 20:15:58 GMT

Looks good.

Thanks

Barry

"Scott M." wrote in message
news:%23FKwut9ZKHA.2160@newsgroup

Quote:

>
> "Barry Flynn" wrote in message
> news:%23Fr3HL8ZKHA.4932@newsgroup

Quote:

>> Win Forms program - VB 2005.
>>
>> I am converting a VB6 program to VB 2005.
>> The program wants to know its own name - ie the name of the .exe that has
>> been executed.
>> It gets this from App.exename
>>
>> In VB 2005, I have replaced this with My.Application.Info.AssemblyName.
>> However, if the program has been renamed after it was Built, that returns
>> the name it was Built as, rather than the name of the .exe that has
>> actually been executed.
>>
>> Is the name of the actual .exe available?
>>
>> Thanks
>>
>> Barry

>
> Will this work?
>
> [C#]
> System.Diagnostics.Process p =
> System.Diagnostics.Process.GetCurrentProcess();
> String n = p.ProcessName;
>
> -Scott
>
>

Exchange Server not sending or receiving email.

moyondizvo — Tue, 17 Nov 2009 17:02:05 GMT

What is your ".NET" (dotnet) question? This newsgroup is for general
questions about Microsoft's .NET programming platform.

-Scott

"moyondizvo" wrote in message
news:FA3FA808-EAF4-4DD0-A650-5FD786F5107D@newsgroup

Quote:

> I'm running Exchange Server 2003 on a SBS 2003 SP2 machine. Every other
> day
> email cannot be sent out or received until after I restart the Exchange
> Store
> Service. Any assistnace to help me overcome this will be greatly
> appreciated. Thank you in advance.

can't update or download troubleshooter

Allly55 — Mon, 16 Nov 2009 14:17:01 GMT

"Allly55" wrote in message
news:9D84C2D0-2E4B-41E6-A180-A6F7B3343E13@newsgroup

Quote:

> Can't update windows can't download troubleshooter think I've made a
> mistake
> buying windows 7 laptop should have stuck with XP any suggestion please
> --
> Allly55

Yes. You should seek help with your Windows 7/ laptop issue either through
the laptop maker's technical support (*they* are responsible for supporting
the OEM Windows 7 they installed on the laptop), or in a discussion
group/forum for Windows 7 issues. Here are the Windows 7 forums:

http://social.answers.microsoft.com/...egory/windows7

Issue retriving data from mssql 2005

Mikael — Mon, 16 Nov 2009 12:19:01 GMT

Mikael wrote:

Quote:

> Different queries accessing a storedprocedure sometimes hang until they are
> timedout.
>
> Calling the stored procedure mannually (Management Studio)(from the client
> computer that also executes the program) returns 1090 rows in one sec.
>
> EXEC spa08v1GetTransactions NULL ,'20091006','20091006'
>
> Executing the stored procedure from a simple app, just counting the rows
> gives me a timeout at 956 rows. This runs nicely against my test enviroment.
>
> SqlCommand cmd = new SqlCommand();
> cmd.Connection = new
> SqlConnection("Server=MyServer;Database=MyDatabase;Trusted_Connection=True;");
> cmd.CommandType = System.Data.CommandType.StoredProcedure;
>
> cmd.CommandText = "[dbo].[spa08v1GetTransactions]";
> SqlParameter p = cmd.Parameters.Add("port_key",
> System.Data.SqlDbType.Int);
> p.Value = DBNull.Value;
>
> p = cmd.Parameters.Add("from_date",
> System.Data.SqlDbType.SmallDateTime);
> p.Value = DateTime.Parse("2009-10-06");
>
> p = cmd.Parameters.Add("to_date",
> System.Data.SqlDbType.SmallDateTime);
> p.Value = DateTime.Parse("2009-10-06");
>
> cmd.Connection.Open();
> SqlDataReader dr = cmd.ExecuteReader();
>
> int i = 0;
>
> while(dr.Read())
> {
> //Console.WriteLine(dr[3]);
> i++;
> }
> cmd.Connection.Close();
>
> Console.WriteLine(i);
> Console.Read();
>
>
>
> Running on test and production:
> Microsoft SQL Server 2005 - 9.00.3080.00 (X64) Sep 6 2009 09:15:46
> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on
> Windows NT 5.2 (Build 3790: Service Pack 2)
>
> App. running 2008 - 3.5
>
>
> I had the same issue last monday and it helped dropping and recreating the
> stored procedure, but it dosent help me today.
>
> I also tried the DBCC FREEPROCCACHE without any luck.
>
> Any idears (Besides restarting the production server :)
>

One thing that jumps out at me is you do not ever dispose of the SQL
objects. That shouldn't cause any issue as described, necessarily.

When "the same thing" works in one code, but not another, always check
permissions of the user.

--
Mike

Re: horizontal grid

Mansi Shah — Mon, 16 Nov 2009 09:08:10 GMT

Hi,

You can use DataList instead of GridView, it provides facility to
display records in Horizontal direction.

You can use datalist's "RepeatDirection" property.

Regards,
Mansi Shah

*** Sent via Developersdex http://www.developersdex.com ***

How to remove HTML special characters and tags from a Google RSSfeed?

JimTheAverage — Mon, 16 Nov 2009 02:10:58 GMT

On Nov 18, 9:14*am, "ib.dangelm...@newsgroup"
wrote:

Quote:

> > Is there an easy way of doing this that I am overlooking?

>
> The maybe easiest way to parse HTML is to use a (hidden) webbrowser
> control in a form e.g.:
>
> {
> * WebBrowser webBrowser = new WebBrowser();
> * webBrowser.DocumentCompleted += OnDocumentCompleted;
> * webBrowser.DocumentText = "

> \"test.html\">blabla >&< bla

> body>";
>
> }
>
> private void OnDocumentCompleted( object sender,
> WebBrowserDocumentCompletedEventArgs e )
> {
> * MessageBox.Show( ((WebBrowser)sender).Document.Body.OuterText );
>
> }
>
> Another (easy) possibility is by using the html agility pack (free
> library somewhere on the web):
>
> using ( StringWriter sw = new StringWriter() )
> {
> * new HtmlToText().ConvertHtml(htmlString, sw);
> * sw.Flush();
> * return sw.ToString();
>
> }
>
> Hope it helps.

Ops ... sorry, forgot to include the "HtmlToText" class for the html
agility pack:

public class HtmlToText
{
public HtmlToText()
{
}

public void Convert(string path, StringWriter sw)
{
HtmlDocument doc = new HtmlDocument();
doc.Load(path);
ConvertTo(doc.DocumentNode, sw);
}

public void ConvertHtml(string html, StringWriter sw)
{
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(html);
ConvertTo(doc.DocumentNode, sw);
}

private void ConvertContentTo(HtmlNode node, TextWriter outText)
{
foreach(HtmlNode subnode in node.ChildNodes)
ConvertTo(subnode, outText);
}

public void ConvertTo(HtmlNode node, TextWriter outText)
{
string html;
switch(node.NodeType)
{
case HtmlNodeType.Comment:
// don't output comments
break;

case HtmlNodeType.Document:
ConvertContentTo(node, outText);
break;

case HtmlNodeType.Text:
// script and style must not be output
string parentName = node.ParentNode.Name;
if ((parentName == "script") || (parentName == "style"))
break;

// get text
html = ((HtmlTextNode)node).Text;

// is it in fact a special closing node output as text?
if (HtmlNode.IsOverlappedClosingElement(html))
break;

// check the text is meaningful and not a bunch of whitespaces
if (html.Trim().Length > 0)
outText.Write(HtmlEntity.DeEntitize(html));
break;

case HtmlNodeType.Element:
switch(node.Name)
{
case "p":
// treat paragraphs as crlf
outText.Write("\r\n");
break;
}

if (node.HasChildNodes)
ConvertContentTo(node, outText);

break;
}
outText.Write(" ");
}
}

The code is based on some example included in the html agility pack.