|
sir, i does not properly get you
Are you want to say that I add Database as Prerequiste of Installation Package and After installation of application, when user run the application first time, then it ask for Server Name and store server name in some place like text file or registry ? Please correct me
|
|
|
|
|
I think what he want to say is, your database creation progrom should ask the database information, as sql expressoin cant be reachable accross network, so you also need to change the connection string. after getting the database info you update your configuration file.
|
|
|
|
|
Mycroft Holmes wrote: over 300 SQL server instances on ours
Oh boy. 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Yeah I work for a bank, they have 4 data centers, 2 production and 2 DR. They run 2 discreet networks UAT and production. Deployment is a PITA
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: have 4 data centers, 2 production and 2 DR
Sounded like with that many instances, you are at a good sized shop.
Mycroft Holmes wrote: Deployment is a PITA
I imagine so. ![Beer | [beer]](https://www.codeproject.com/script/Forums/Images/beer.gif) helps after a tough day in any shop 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Paul Conrad wrote: you are at a good sized shop.
Yeah but I work in one department and IT hate me, I have a mandate to "get the job done" and worry about enterprise requirements later. Therefore I'm not subject to the endless meetings IT seem to require before they allow you to start coding, it also means there is no such thing as a requirements document either so it has it's drawbacks.
Thanks for the beer, I may wait as it is 9:30 on a Sunday and thats a bit early even for me!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
This article, Finding SQL Servers on the Network[^] may be worth looking at. Not sure how it responds to SQL Express or SQL 2008.
The above article is based on odbc, this other one, Enumerating SQL servers on a Network[^] looks good, too.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
modified on Saturday, July 26, 2008 9:08 PM
|
|
|
|
|
Hi
I've a Table Table1.And it's structure is
RoleID RoleDescription Department
1 Manager Accounts
2 Senior Manager Finance
and I want to have a Table like
Columnname Columnvalue Date
RoleID 1 2/5/2008
RoleDescription Manager 2/5/2008
Department Accounts 2/5/2008
RoleID 2 2/5/2008
RoleDescription Senior Manager 2/5/2008
Department Finance 2/5/2008
Can anyone tell how?
thanks in advance
Sri
|
|
|
|
|
I realy dont understand what you just asked
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Dear gurus,
I am developing a charting application that should plot [double] values against [DateTime] values. In a single turn, there can be as much as 10 million data points.
What I do is to extract the data from SQL Server and use ChartDirector to plot it. For about 1 million data, extraction takes 25 seconds and plotting takes 20 seconds.
This is a lot of time to wait for user. Can you please suggest me any?
like sampling to reduce the data, or fast extraction, or fast plotting?
Thanking you!
|
|
|
|
|
The obvious one is to reduce the number of data points over the entire time frame IE get 1 data point per week/month. Allow the user to drill into a specific week/month at which time you may show all or data points. You can't actually see 10mio datapoints, the values would become irrelevant over such a large size.
BTW 45 sec to get 10mio rows of data seems eminently reasonable to me.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you, Mycroft Holmes.
But the problem is that I cannot afford to miss out the outliers among the data. If I pick out 1 data poing per month, there is high chance that any outlier may miss out.
Should taking the mean withing the time span solve the problem?
Thanking you.
|
|
|
|
|
mahabir wrote: If I pick out 1 data poing per month,
There is a trading graph the shows hi/low and volume for period per period (Day per year). That will solve your problem. There are at least 3 other methods of displaying the data without dumping our millions of rows!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
By using ADO to deal with excel, I can create the table in Excel successfully, but when I try to insert a new column, the SQL command failed.
ALTER TABLE tablename INSERT COLUMN col1 FLOAT
Why?
system
|
|
|
|
|
Question comes instantly to mind - WHY THE FREAKIN HEEL ARE YOU USING EXCEL AS YOUR DATABASE. Unless there is an overriding business reason to do this you are setting yourself up for a disaster. Please use SQL Express if possible, Access if you really must use office but Excel NNnnnnnooooooo!
Sorry that I cannot help you with this I am not even sure it is possible. Quite possibly I would not even if it is possible!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes, the customer need a report in an Excel file.
system
|
|
|
|
|
followait wrote: customer need a report in an Excel file
Ok thats a different problem. Do not create a database for outputting to excel. If you do a search in the articles here you will find many examples for output to excel from both SQL and UI.
You have 2 choices, output a csv file and allow excel to do the conversion when it is opened. This is by far the simplest method and probably the widest used.
Alternatively you can manually create an excel sheet by manipulating the excel application object. This will give you formatting options but will take a lot more work and require the excel application to be installed on the client computer.
3rd option it to use a reporting engine to render an excel report. This give you the best format but will require you get a handle on a report engine.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The client I'm working for is using LINQ to SQL behind a BLL of sorts. So each CRUD operation gets its own context. Here's an example of the Save method:
<br />
public static Step Save(Step step)<br />
{<br />
using ( KRATDataContext context = new KRATDataContext( Helpers.EnvironmentState.CurrentConnectionString ) )<br />
{<br />
Step oldStep = step.StepID > 0 ? context.Steps.Single( p => p.StepID == step.StepID ) : null;<br />
<br />
if ( oldStep == null )<br />
{<br />
context.Steps.InsertOnSubmit( step );<br />
}<br />
else<br />
{<br />
oldStep.Description = step.Description;<br />
oldStep.PotentialHazard = step.PotentialHazard;<br />
oldStep.ActionsToReduceRisk = step.ActionsToReduceRisk;<br />
oldStep.InitialRiskCellID = step.InitialRiskCellID;<br />
oldStep.PostRiskCellID = step.PostRiskCellID;<br />
oldStep.DateCreated = step.DateCreated;<br />
oldStep.RiskAnalysisID = step.RiskAnalysisID;<br />
oldStep.DisplayIndex = step.DisplayIndex;<br />
}<br />
context.SubmitChanges();<br />
<br />
return step;<br />
}<br />
}<br />
<br />
I have implemented functionality which allows a user to change the display order of a "Step" record by clicking an up/down arrow which essentially swaps the value of DisplayIndex for two separate records. Like this:
<br />
protected void Swap(int stepId1, stepId2)<br />
{<br />
Step step1 = Step.GetOne(stepId1);<br />
Step step2 = Step.GetOne(stepId2);<br />
<br />
Swap(step1, step2);<br />
<br />
using( System.Transactions.TransactionScope txCtx = new System.Transactions.TransactionScope()){<br />
Step.Save(step1);<br />
Step.Save(step2);<br />
<br />
txCtx.Complete();<br />
}<br />
}<br />
The important fact being demonstrated here is that each save operation has its own DataContext. So when the 2nd call to Save() is made I get an exception because I have explicitly turned off DTC (ie. I don't allow remote DTC operations). But these two records are in the same table.
So here's what I'm looking for:
1) Can someone else confirm this for me, but duplicating the error I get.
2) Is there a way around this, other than using the same DataContext object?
3) I'll need to double check, but this doesn't happen to me when I use the EnterpriseLibrary connection objects with TransactionScope. So is this a bug? Or at least something that should be changed so it works the way EnterpriseLibrary does?
#2 is important because while fixing this issue for the specific case above (both objects are based on the same database table) I have other cases where I'll have to create specialized methods in my data access layer which allow me to use the same data context so I can wrap operations on different tables with the same DataContext.
As always, I appreciate the help.
[Edit]
Here's the exception detail:
System.Transactions.TransactionManagerCommunicationException was unhandled by user code
Message="Communication with the underlying transaction manager has failed."
Source="System.Transactions"
InnerException: System.Runtime.InteropServices.COMException
Message="Error HRESULT E_FAIL has been returned from a call to a COM component."
Source="System.Transactions"
[/Edit]
|
|
|
|
|
Ok, well I came up with a solution for this (for anyone interested).
The DataContext is not aware of any other contexts (through thread local storage) in any way. So I basically decided to use thread local storage to store my DataContext for the current thread (HttpRequest).
Here's how it works. The DataContext classes generated for a dbml file is a partial class, so I added a class file to the same project which contains a static factory method, GetDataContext(). GetDataContext checks HttpContext.Current.Items to see if a DataContext object already exists. If not, it creates and new one, stores it in HttpContext.Current.Items and the returns the new instance. If the object already exists, it just returns the existing object to the caller.
<br />
public static DataContext GetDataContext()<br />
{<br />
if(HttpContext.Current == null)<br />
return new DataContext(connectionString);<br />
<br />
if(HttpContext.Current.Items.Contains("DataContext"))<br />
{<br />
return (DataContext) HttpContext.Current.Items["DataContext"];<br />
}<br />
<br />
return new DataContext(connectionString);<br />
}<br />
Now, I am able to use TransactionScope to wrap my business logic without having to use DataContext directly. Plus there are other benefits, my Save method no longer requires the additional database call to retrieve the record and copy the changes before calling SubmitChanges(). So compared with my previous post, my Save method now looks like this:
<br />
public static Step Save(Step step)<br />
{<br />
KRATDataContext context = KRATDataContext.GetDataContext();<br />
<br />
if ( step.StepID <= 0 )<br />
{<br />
context.Steps.InsertOnSubmit( step );<br />
}<br />
<br />
context.SubmitChanges();<br />
<br />
return step;<br />
}<br />
Which requires one less database call, always a plus  . This all solves my Transaction problem because it uses the same connection object (because we're using the same DataContext which owns the Connection object) and so there is no longer any distributed transactions (DTC) required.
|
|
|
|
|
My database table has got 5 fields and through my C#.Net code I'm adding the 6th field (using dataset and .WriteXmlSchema() )...........but it works fine for the first time............aftr tht since the DataSet schema has already been updated with the 6th column, it throws an error "6th Field already exists in database table"............
so i just want to do something like this :
if (check whther Access Database Column is already present for the ABC Table)
{
do {nothing}
}
else
{
do {add the 6th column - for which i already have the code}
}
|
|
|
|
|
Post your real code to see where is problem.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Hello Friends,
Please let me know if there's an easy to change the Report Title of Crystal Report at Runtime Coz I could see that once you create the Crystal Report there's no option to change the title else I have to start from the scratch creating a new Crystal Report and at that point of time adding the title what I want.
Please share if you know something about this.
Thanking you in anticipation.
|
|
|
|
|
yes you can change it...assuming you mean some text thats displayed as a title. there isnt much you can do with the version of CR(2008) at runtime, at least as far as dynamic charts go, but assuming you know what section your title is in, you can loop through that sections report objects, looking for text objects, i cant remmeber if there are title objects, and then you can change the text of the objects yo ufind...something like
int i = 0;
CrystalReport rpt = new CrystalReport(the class should be the name of your rpt file - the extension)
foreach (TextObject to in rpt.Section1.ReportObjects)
{
to.Text = i;
i++;
}
this way you can see what the index of the box you want changed is.. i recomend reading anything by Brian Bischof(sp?) or picking up one or more of his books if you'll have to deal with CR alot, even ones written in an older version helped me alot. i think i have Crystal Reporting for .NET.
I gave up on CR a while ago so there may be an easier way, this was just the first method that came to mind. hope it helps.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
If you don't need to do it at run time, then you can change the title of the report by right mouse clicking on the file name (myreport.rpt), go to properties, then the Summary tab and change the name of the report. I thought this was a bit strange, but it works for me. Crystal Reports 10.
|
|
|
|
|
I didn't meant to change the name of the report. I'm talking about the last section in the Crystal Report creation wizard which asks you to enter a title for the report and that title gets displayed every time you execute the report ( e.g Sales Summary Report - 2008 ). The top most title on the report page.
To be more clear, I'm talking about the : PAGE HEADER (SECTION 2) of the Crystal Report. And I don't see any option to change the title name.
Please comment.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
