|
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 ...
|
|
|
|
|
|
It looks like you are trying to fill your dataset with an select query that requires an variable (@A)
Wich is missing. (that is what the error says)
first off all this isn't needed.
You have 2 options:
You select the complete table and do the filtering on the report (that is the way I explained it in earlyer post)
OR
You do the filtering in the select command and NOT on the report (in this case you don't need the parameter on the report)
Both are possible and acceptable, you can do both but that's not needed.
If you choice the second option you need to provide a sqlparameter
something like:
sqldataadapter1.selectcommand.commandtext = "SELECT * FROM table WHERE id=@A";
sqldataadapter1.selectcommand.parameters.addwithvalue("@A",textbox1.text);
sqldataadapter1.fill(dataset11);
crystalReport11.SetDataSource(dataSet11);
crystalReportViewer1.ReportSource = crystalReport11;
and then your report doesn't need the parameter nor needs to filer it (the set select from last post) since you already filterd the data.
(once again this if from memory)
|
|
|
|
|
Another problem, suppose there are two AgentID ... If i enters one agent Id and search for it , it works fine, but when i changes the value in textbox and enters 3nd agent id, it throws an error The SelectCommand property has not been initialized before calling 'Fill'.
I have to search agentid and my search changes frequently .. so its not happing now..
Please suggest something.
|
|
|
|
|
Did you set the selectcommand?
sorry without your code I can't really say what's wrong with it
post your code that you use to fill the dataset
|
|
|
|