|
i have used backend as sqlserver, is it necessary that the client machine, where i'll be deploying my application that machine should have sqlserver installed in it. Otherwise, any prerequisites i should include while creating setup file.
|
|
|
|
|
praveenvkumarv wrote: is it necessary that the client machine
No!!!
Database should be in your server side. All client should store/Retreive data from Single Database Server. Isn't It.
|
|
|
|
|
my application is a windows application.
|
|
|
|
|
As far as I understand you've got a client/server application, where there is an SQL server on server side and some application on the client side. So, you've got two choices to deploy the app on the customer side:
1. Deploy the SQL server and the client application on the same machine, which in general is not a good idea,
2. Deploy your stuff on two separate machines - one for SQL, i.e. the server, and one (or several) machine(s) for the client application.
Regards,
Lev
|
|
|
|
|
i want to create a setup file. i used sqlserver 2005 as backend and c# as frontend.Now i want to create a setup file, i have created tables in sqlserver and creating setup file in vs 2005, how do the tables from sqlserver will be created when creating setup file in visual studio 2005 .
|
|
|
|
|
you can write your custom code for doing this things during installation of your application.
|
|
|
|
|
You can export the structure of your SQL DB to SQL queries (like CREATE TABLE) etc., and execute those queries during the first start of your application, after the install.
One tool to export the db structure is EMS Data Export for SQL Server link[^]. This is a part of EMS SQL Management Studio for SQL Server
|
|
|
|
|
Hi,
My app needs to write to the event log. It works fine on my machine (Windows XP) - I'm logged in with admin permissions. When I deploy to a Windows Server 2008 machine, it won't raise events because it says it can't find the specified source even though my code is supposed to create the source if it doesn't exist.
Any ideas? 
|
|
|
|
|
For writing eventlog, create an applicationpool with rights as LocalSystem and assign this pool to site you have deployed.If still problem lemme know
Cheers!!
Brij
|
|
|
|
|
Brij wrote: create an applicationpool with rights as LocalSystem and assign this pool to site you have deployed
Brij, I beleive he is talking about windows application. So there is no concept of Application Pool. 
|
|
|
|
|
hi every body!. please help me this question:
I used functions such as fillrectange, fillelipse,drawelipse ect..to draw on the picturebox. and now i want save it to change file of image: jpg, bmp... Thank you very much!
|
|
|
|
|
Hi,
try to use the Image-Property of the Picturebox:
<br />
PictureBox.Image.Save(...)<br />
Regards
Sebastian
|
|
|
|
|
use Graphics.Save() mathod
Cheers!!
Brij
|
|
|
|
|
you must be joking. or just guessing? 
|
|
|
|
|
would u give an example how to save an image?
|
|
|
|
|
Hi,
a PictureBox is a Control for showing images, not for modifying/saving them; it is like a picture frame with a glass plate. When you draw on a PictureBox, you don't modify the image, you are drawing on top of the glass that protects your image from fingerprints; the image will never know what you did.
In order to modify an image, you should use Graphics.FromImage, draw using that Graphics, then save the image; you can visualize the modifications by painting to any Control you choose (say a Panel) and even by assigning the image to a PictureBox; whatever you choose, the Control must be informed that a repaint is needed, so don't forget to call its Invalidate().
|
|
|
|
|
hi every body
you can show me how to write the code?. thank you very much:
private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
Graphics g = picturebox.CreateGraphics();
g.DrawImage(picturebox.Image, new Point(0, 0));
Bitmap bmp = new Bitmap(picturebox.Image);
bmp.Save("2.bmp");
}
With this code:
if I insert a file image into picturebox then i can save it. But when I use
the fuctions: FillElipse, FillRectange, Drawline to draw tree,sun, moon ...on picturebox then saving is failure.
And it report fail at line : g.DrawImage(picturebox.Image, new Point(0, 0));
-->Value cannot be null.
Parameter name: image
modified on Wednesday, December 10, 2008 9:46 PM
|
|
|
|
|
Hi,
you clearly did not get it.
A PictureBox HOLDS an image when you assign something an image to its Image property, which you did not do, so your g.DrawImage and new Bitmap lines are bound to fail.
Most Controls (including PictureBox unfortunately) allow you to paint ON TOP of them, which is what you are doing; a simple Panel would serve the same purpose equally well.
A CreateGraphics is not necessary and even a bad idea here. A Graphics.FromImage is recommended.
I suggest you read my previous message again, and start from scratch; I am not going to provide all 10 lines this might take, I am not in the spoon feeding business. It is up to you to read suggestions and documentation, try, debug and learn.
Good luck.
|
|
|
|
|
Hello. I need a help . I m using CrystalReportViewer to display a table from dataset. I want to see specific details of particular id dynamically.
Suppose the table is like this..
A -- B -- C
A1 -- AAA -- BBB
A2 -- BBB -- CCC
,, i can see full details in table but i want to see specific details like if a user enters A1 in textbox1, only A1 details will be shown..
I tried from past 2 days but i can't find a way... i was doing all things from interface, not by programming (by writing codes).. please tell me how to link that textbox with crystal report.. so i can see those data..
Thanks a lot...
|
|
|
|
|
for this u can use crystalreport and file and add parameter field
and create
ParameterFields myParams = new ParameterFields();
ParameterField myParamGuestName = new ParameterField();
ParameterDiscreteValue myDiscreteValue = new ParameterDiscreteValue();
myParamGuestName.ParameterFieldName = "guestname";
myParams.Add(myParamGuestName);
crystalReportViewer.ParameterFieldInfo = myParams;
enjoy this code
diwaker sharma
|
|
|
|
|
sorry dude, i cant understand .. i have crystal report in my file ... where i write these code ?
Do i need to fill dataset ?
My existing code is like this ..
private void button1_Click(object sender, EventArgs e)
{
sqlDataAdapter1.Fill(dataSet11);
crystalReport11.SetDataSource(dataSet11);
crystalReportViewer1.ReportSource = crystalReport11;
}
|
|
|
|
|
|
First you need to add a parameter to your report.
Then (still in the report) add a select query (from memory: right click report - set select - choice your ID column and set equal to parameter)
Then in code you do:
<br />
private void button1_Click(object sender, EventArgs e)<br />
{<br />
sqlDataAdapter1.Fill(dataSet11);<br />
crystalReport11.SetDataSource(dataSet11);<br />
crystalreport11.setparameter("parametername",value);<br />
crystalReportViewer1.ReportSource = crystalReport11;<br />
<br />
}<br />
This is all from memory so you might have to search a bit
O and nobody is going to just write the code for you. But this should help you on your way.
|
|
|
|
|
System.Data.SqlClient.SqlException was unhandled
Message="Parameterized Query '(@A varchar(50))SELECT DS.*\r\nFROM DS\r\nWHERE (A =' expects parameter @A, which was not supplied."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
I get this error in this line
---- sqlDataAdapter1.Fill(dataSet11);
What I did is ... Added a textbox1, button1, crystalreportviewer1 and crystalreport11, crystalreport.rpt..
in crystalreport.rpt, I added a Parameter Field , named "AAAA" and in Set Select Editor, I set equal to parameter and added A=@A in formula editor.. Then i write this code and error happens..
sqlDataAdapter1.Fill(dataSet11);
crystalReport11.SetDataSource(dataSet11);
crystalReport11.SetParameterValue("AAAA", textBox1.Text);
crystalReportViewer1.ReportSource = crystalReport11;
|
|
|
|
|
hey .. just worked tom .. thanks a lot my friend ...
can i have your messenger id if you dont mind ...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
