|
Is the column you are referencing in your where clause defined by an index ?
Use the "show execution plan" option in query analyzer to make sure the query is not doing table scans.
Optimize the query first, then the report should work fine.
|
|
|
|
|
Hi,
I m manjari.let me tell u the problem while doing my work in my company.when ever a person click the print option to print a document it should detect the person and that time instead of print dialog box our window should display with username and password.if valid then it will goes to print spool.I hv done the program after going to print spool it already detect the person but i want before goin to print spool it should detct.anybody plz help me as soon as possible.
thanks,
regards,
manjari
How i will design a a form in windows service to print a document.
|
|
|
|
|
manjari kar wrote: when ever a person click the print option to print a document it should detect the person and that time instead of print dialog box our window should display with username and password
If you want to show a username/password dialog before the print dialog then you should create one and call ShowDialog on the username/password dialog before the PrintDialog.
manjari kar wrote: How i will design a a form in windows service to print a document.
You cannot. A windows service has no user interface and can run without there being any user logged in.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
thanx for responding.plz giv eme ur answer depictly with code .becoz i tried a lot .but i didnt get result.plz help me.and nw again i briefly tell u the task.suppose in ms word or in notepad or in pdf file ,when a person is going to click the print option in file menu thattime our window should display instead of print dialog popup.if valid then it goes to print dialog popup for print that document.
i hv done my task like this.after clicking the print option printdialog popup is comming,then clicking ok my window is displaying and asking for username and password.but i want before that print dialog popup it should display.plz helpme and give me a right path.
my code is like this :
private void timer1_Tick(object sender, EventArgs e)
{
PrintServer myPrintServer = new PrintServer(@"HP LaserJet P2010 Series PCL 5e");
PrintQueueCollection myPrintQueues = myPrintServer.GetPrintQueues();
foreach (PrintQueue pq in myPrintQueues)
{
pq.Refresh();
PrintJobInfoCollection jobs = pq.GetPrintJobInfoCollection();
foreach (PrintSystemJobInfo job in jobs)
{
if (job.Submitter == "gyana.manjarikar")
{
job.Pause();
}
if (true)
{
//MessageBox.Show(job.Name.ToString());
this.Show();
}
else
this.Hide();
}
}
}
private void btnlogin_Click(object sender, EventArgs e)
{
int copies=10;
this.Opacity = 50;
PrintServer myPrintServer = new PrintServer(@"HP LaserJet P2010 Series PCL 5e");
PrintQueueCollection myPrintQueues = myPrintServer.GetPrintQueues();
foreach (PrintQueue pq in myPrintQueues)
{
pq.Refresh();
PrintJobInfoCollection jobs = pq.GetPrintJobInfoCollection();
foreach (PrintSystemJobInfo job in jobs)
{
//if (txtUserName.Text == "aaa" && txtPassword.Text == "bbb" && copies <= 10)
//{
// job.Restart();
//}
if (job.Submitter == "gyana.manjarikar")
{
if (txtUserName.Text == "aa" && txtPassword.Text == "bb" && copies <= 10)
{
timer1.Dispose();
job.Resume();
this.Hide();
}
else
{
lblErrormsg.Text = "Invalid UserName Or Password";
}
}
else
{
this.Show();
timer1.Start();
lblErrormsg.Visible = true;
lblErrormsg.Text = "Invalid User";
}
//if (job.Submitter == "")
//{
// job.Pause();
//}
//else
//{
// lblErrormsg.Visible = true;
// lblErrormsg.Text = "Invalid User";
//}
//if ( txtUserName.Text == "aa" && txtPassword.Text == "bb" )
//{
// job.Pause();
//}
//else
//{
// lblErrormsg.Visible = true;
// lblErrormsg.Text = "Invalid User";
//}
}
}
}
private void btncancel_Click(object sender, EventArgs e)
{
this.Opacity = 50;
this.Hide();
PrintServer myPrintServer = new PrintServer(@"HP LaserJet P2010 Series PCL 5e");
PrintQueueCollection myPrintQueues = myPrintServer.GetPrintQueues();
foreach (PrintQueue pq in myPrintQueues)
{
pq.Refresh();
PrintJobInfoCollection jobs = pq.GetPrintJobInfoCollection();
foreach (PrintSystemJobInfo job in jobs)
{
if (job.Submitter == "gyana.manjarikar")
{
job.Cancel();
}
}// end for each print job
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.Opacity =100;
}
}
}
plz help me where and what i will change here.
How i will design a a form in windows service to print a document.
|
|
|
|
|
that is unreadable.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
I have a program that runs with active user sessions. How to modify the MSI packaging so that installation would also add the program to Services?
|
|
|
|
|
First of all you must modify your program and make it into a service.
Writing a system service is different than writing a user mode program in a few ways.
You should have a look at some articles on the web, you can start from here[^] for example.
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
Hi -
I've got Visual Studio 2005 and I'm trying to create a SQL Server Project on a 2008 Server.
I'm trying to make a 'New Database Reference' with the following settings:
Data Source: SqlClient
Server: <servername>
Windows Authentication
I'm able to successfully test the connection and find the correct database (catalog).
The problem is that I get a message - "This Server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later"
Anyone see or overcome this before?
Thanks in advance!
|
|
|
|
|
You need to install VS 2005 SP1 and also a path on top of it.
Look into the following link[^]
|
|
|
|
|
I am trying to create a report in Crystal IDE, using XSD file as the datasource. It is not letting me do it. As soon as I select the XSD and click ok, I get the error that says "Failed to Load database information". I click OK and then I get "Unknown Database connector error". I am able to use other options like XLS,MDB, but XML would not work. Any ideas?
This works perfectly fine from my .net version of CR. Also, in the .net version I see the ADO.net option under "Available Data sources"->"Create New connection", I donot see that in the CR IDE.
Not sure why this is happenning.
Sudha
|
|
|
|
|
I dont think CR knows how to read XML. You need to convert the XML to MDB/DBF/SQL so that your CR template can read those tables not file. Or another way doing it is to use XML to datagrid and datagrid is your datasource.
|
|
|
|
|
I am trying to use XSD file.
|
|
|
|
|
Also, I am trying to do this directly in Crystal IDE, not via .net.
|
|
|
|
|
In your Crystal Report you reference the schema by opening the Field Explorer, right clicking Database Fields, selecting Database Expert, expanding the Create New Connection node, and the ADO.NET (XML) node then double clicking Make New Connection. At the ADO.NET (XML) dialog set the File Path to your XSD file by clicking the elipses and navigating to the schema file
|
|
|
|
|
That is what I am trying to do, but I do not see the ADO.NET option at all. All I see are:
Access/Excel
Database Files
ODBC
OLE DB
Universes
More DataSources.
I tried to use Database Files option, but as soon as I select the XSD file, I get the error "Failed to load Database Info". I click OK and then I get "Unknown Database connector Error".
Thanks for trying to help me.
Sudha
|
|
|
|
|
go to Create New Connection
go to Databases Files
on the drop down Files of Type select XML Files (*.xml;*.xsd)
point to your file and click Open.
|
|
|
|
|
That is when I get that error.
|
|
|
|
|
Do you have the Login and Password? Is the file locally stored on your Workstation?
|
|
|
|
|
yes it is. This is what I did to create the XSD file: I have an ODBC conn to MYSQL. Using this conn, from .net, I created the XSD file by adding a dataset object.I am trying to use this XSD in Crystal IDE and that is when I am getting the error.
|
|
|
|
|
If your template trying to access the server you need to have ODBC connector from your workstation to the server where the XML/XSD located. Go to Control Panel\Administrative Tools\Data Sources. Make sure the Server\XSD table listed with correct Login and password. Then your template will open using the connector from your Workstation to the server and drills to the server to get the XSD and frame it against your template.
|
|
|
|
|
Sudha. I currently have hundreds of CR rpt files that utilizing DBF, MDB, SQL and experiencing no issues at all. My last attempt is to look at the XSD from your Workstation using Microsoft Access and if the table opens that means you have connections and if the table does not open that means connections from the server is no good. If this does not help I give up.
|
|
|
|
|
My site is working fine in IE7. But it is not showing rightly in IE6.
I have used sitemap in masterpage which has broken down
Thanks for help
|
|
|
|
|
You might want to ask this in the ASP.NET forum[^].
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
I have long had this question floating around my mind since I first started web developing 6 years ago. What user permission applies to the viewer of a website and what user permission applies to the application such as .net or php running on the website? The reason I am confused is that when a user visits a website the application such as IIS or Apache serves them a page so that application would be the one the file permissions would apply to I imagine. When a user of a website submits data in a form then the data is handled by .net or PHP so logically the parser would be the one that the file permissions applied to unless every viewer of a website has the full permissions of the web server application. The reason I ask this is because when you set a file in a directory to something like chmod 644 then I want to know can a hacker exploiting a submission field get the 'group,' the 'everyone' permission or does his code apply to whatever rights the server itself has? Most importantly if I set a file to 777 on a webserver then how can any user looking at the site through a web page write to that file unless they are counting as .net when they view the web page and use form submissions. I have had a web page hacked when someone managed to re-write a configuration file even though it was set to 644 and there was very little amount of form submissions on the web site.
Thanks for any input. This is not entirely a .net question, but I just think this community is very bright.
Nick
|
|
|
|
|
I have a .net class library which is having Installer.cs that I am trying to configure as a custom action in my build script.
<binaries>
<binary name="EXTDLL" value="${output.dir}LVLTExtensions.dll" />
</binaries>
<customactions>
<customaction action="CA_EXT" type="1" source="EXTDLL" target="Install" />
</customactions>
<sequences>
<sequence type="installexecute" action="CA_EXT" value="-1" condition="Not Installed"/>
</sequences>
I want to call Installer.cs methods on customaction, but when I give target as method name on Installer.cs...I am getting error message on MSI execution{ERROR: DLL required for this install to complete could not be run. Contact your support personnel or package vendor. }
Please help me on this
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
