|
Hi Guys,
I have a requirement in which i have to create folders and few excel files based on the no of launches and users during runtime.
when i click "download" button, i will have info of no of launches and no of users , so based on no of launches it should create those many folders and based on no of users in each launch, those many excel files in each folder should be created.
launches 5. then 5 folders to be created with the name of each folder is the launch name
if in launch 1, users 6 => in Launch1 folder, 6 excel files with the file name as the user name to be created. ( i mean these excel files are not default files but i have a template for this, that template with the user name should be created for this.)
if in launch 2, users 19, in Launch2 folder, 19 excel files with the file name as the user name to be created.
all this should happen at runtime...
please help me doing this
thanks
ramm
|
|
|
|
|
for creating Folders:
//if you want to create multiple folders then use for loop.
System.IO.Directory.CreateDirectory(@"D:\\your folder name");
for creating Excel file:
Microsoft.Office.Interop.Excel.Application m_objExcel;
Microsoft.Office.Interop.Excel.Workbooks m_objBooks;
Microsoft.Office.Interop.Excel._Workbook m_objBook;
Microsoft.Office.Interop.Excel.Sheets m_objSheets;
Microsoft.Office.Interop.Excel._Worksheet m_objSheet;
Microsoft.Office.Interop.Excel._Worksheet m_objSheetIntro;
Microsoft.Office.Interop.Excel.Range m_objRange;
object m_objOpt = System.Reflection.Missing.Value;
m_objExcel = new Microsoft.Office.Interop.Excel.Application();
m_objBooks = (Microsoft.Office.Interop.Excel.Workbooks)m_objExcel.Workbooks;
//Opening the Excel Sheets.
m_objBook = (Microsoft.Office.Interop.Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Microsoft.Office.Interop.Excel._Worksheet)(m_objSheets.get_Item(1));
//Store excel in folder
m_objBook.SaveAs(@your path name here + "\\your file name here.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
|
|
|
|
|
Hello Experts!!
I want to set password to my table in sqlserver2005.i dont knw how to set pwd to table.can anybody suggest me options? I am new with sql2005.
|
|
|
|
|
Hi,
Right Click on Table and go to the Properties.
In properties window, select permissions and it asks for users .
U can enter the user list for the permission grant.
Hope this works out.
Thanks
Ramm
|
|
|
|
|
KIDYA wrote: I want to set password to my table in sqlserver2005.i dont knw how to set pwd to table.can anybody suggest me options? I am new with sql2005
Wrong post... Any how, you can restrict access rights..
Database Name\Security\Logins
In logins you can search for that option...
|
|
|
|
|
Hello All,
I have to draw concentric circles in such a manner that even if the form is resized the circles are displayed in the center of the form. I tried using DrawEllipse but I don't get the desired effect.
Can someone help.
You need to google first, if you have "It's urgent please" mentioned in your question.
 _AnShUmAn_
|
|
|
|
|
Have you hardcoded the parameters in the DrawEllipse method?
Following code works fine:
gx.Clear(this.BackColor);
gx = this.CreateGraphics();
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 10), (this.Height / 2 - 10), 20, 20);
|
|
|
|
|
I don't hardcode the values. I get the center of the form and then try to draw the concentric circles
You need to google first, if you have "It's urgent please" mentioned in your question.
_AnShUmAn_
|
|
|
|
|
So where is the problem then? Can you show some code and rephrase the problem?
|
|
|
|
|
Of course! Based on the size of the form I have to draw concentric circles ( A user can resize the form). So the center of the circles should remain at the center of the form(assuming square shaped form) always. Also the circles should shrink/grow as the user resizes the form. I hope it's clearer now.
In essence I have to create circles dynamically so that the center for two or more circles remain as the center of the form and the radius for each can be calculated in terms of a ratio.
You need to google first, if you have "It's urgent please" mentioned in your question.
_AnShUmAn_
|
|
|
|
|
The code I had posted does the same. What did you tried? Some code would be of help.
|
|
|
|
|
Your code only draws one circle at the center of the dialog. What if I want to draw two circles of different radius at the same center.
You need to google first, if you have "It's urgent please" mentioned in your question.
 _AnShUmAn_
|
|
|
|
|
Use the method two times. Was it this tough?
|
|
|
|
|
You didn't read the documentation of DrawEllipse probably.
DrawEllipse - Draws an ellipse defined by a bounding rectangle specified by a pair of coordinates, a height, and a width. So we need to draw the bounding rectangle at the same center coordinates. Right?
When I use your code it draws an ellipse starting at the coordinates(left top corner) you provide and with the width and height, and so the circles are not concentric.
Anyways I have resolved the problem now.
Thanks for your time and effort in helping me.
You need to google first, if you have "It's urgent please" mentioned in your question.
_AnShUmAn_
|
|
|
|
|
Somehow, these look concentric to me.
gx.Clear(this.BackColor);
gx = this.CreateGraphics();
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 25), (this.Height / 2 - 25), 50, 50);
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 50), (this.Height / 2 - 50), 100, 100);
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 75), (this.Height / 2 - 75), 150, 150);
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 100), (this.Height / 2 - 100), 200, 200);
|
|
|
|
|
d@nish wrote: gx.DrawEllipse(Pens.Red, (this.Width / 2 - 25
aren't you hardcoding the values for the rectangle. you are fixing the centers by subtracting some values based on the radius. isn't it? your circles won't get drawn with the same center when you increase or decrease forms size.
You need to google first, if you have "It's urgent please" mentioned in your question.
_AnShUmAn_
|
|
|
|
|
Only thing I have fixed is the radius of the circles, and that is because this is just some sample code.
You need to handle the Resize event for the form as well and only then, no matter how you resize the form, the circles will be drawn with form's center as their center.
|
|
|
|
|
Are you some sort of idiot?!
How can you have fixed the problem when you cant even see the simple logic that is shown in the code provided by d@nish?
If you put his code is the form's paint event then it will always draw in the centre of the form. And as for saying it only draws one circle - then no f%&^ing $^!t. you want two circles then you use DrawEllipse method two times! Guess how many times you call the method if you want three circles?!? 3 times!!!!!
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Hi..
In my project, want to create Timed license key in c#. for example, if give one month license, the license allowed to work only a single month after that the software indicate date expiry. How can handle this..
Thanks...
|
|
|
|
|
you could have a config file that stores the date the application was first used (not secure)
you could store the date in the system registry (still not secure, but better)
you could get third party licensing software (security depends on the product)
Take a look here[^] for a good example.
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
|
Hello
I am running into "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" and I managed to get around it by setting oParam.Size to length of command text instead of the parameter itself!?!
The stored proc signature is
<br />
CREATE OR REPLACE PROCEDURE spXXXXX (<br />
TestId varchar2,<br />
bAllTestCleared OUT varchar2<br />
)<br />
...
And my code/C# - yes first place I checked is that I have set parameter size of course:
<br />
void SomeTest()<br />
{<br />
IDbConnection oConn = null;<br />
IDbCommand oCmd = null;<br />
IDataParameter oParam = null;<br />
IDataParameter oOutParam = null;<br />
<br />
string strTestId = null;<br />
<br />
object oReturnValRaw = null;<br />
<br />
try<br />
{<br />
strTestId = Guid.NewGuid().ToString();<br />
...<br />
oConn = DBUtil.GetDefaultDBConnection();<br />
oConn.Open();<br />
<br />
oCmd = oConn.CreateCommand();<br />
oCmd.CommandText = "spXXXXX";<br />
oCmd.CommandType = System.Data.CommandType.StoredProcedure;<br />
<br />
oParam = oCmd.CreateParameter();<br />
oParam.Value = strTestId;<br />
oParam.ParameterName = ":TestId";<br />
oParam.DbType = DbType.String;<br />
((OracleParameter) oParam).Size = strTestId.Length;
oParam.Direction = ParameterDirection.Input;<br />
oCmd.Parameters.Add(oParam);<br />
<br />
oOutParam = oCmd.CreateParameter();<br />
oOutParam.ParameterName = ":bAllTestCleared";<br />
oOutParam.DbType = DbType.String;
((OracleParameter) oOutParam).Size = 1;
oOutParam.Direction = ParameterDirection.Output;<br />
oCmd.Parameters.Add(oOutParam);<br />
<br />
oCmd.ExecuteNonQuery();<br />
<br />
oReturnValRaw = oOutParam.Value;<br />
...<br />
}<br />
catch (Exception ex)<br />
{<br />
...<br />
} finally {...}<br />
}<br />
Any suggestion? Is this a bug?
http://forums.oracle.com/forums/thread.jspa?messageID=3258848
Thanks
dev
modified on Monday, June 29, 2009 2:47 AM
|
|
|
|
|
Hi,
I just completed two articles on Silverlight. The first is real basic 1.0 stuff. The second is 2.0 and more architechuraly involved but geard toward developers. I would like some community feed back and any performance results you find while testing the code. I am working on an older Pentuim 4 willimina with low memory. I'm getting bad performance results, I'd like to know what beefier systems report.
Thanks,
~TheArch
XAML Graphics Series - Part 2 Silverlight 2.0 Desktop Art Animation[^]
|
|
|
|
|
|
Hi,
the error message "not all code paths return a value" is clear: there is at least one way of traversing your method without encountering either a "return value;" statement or an abnormal exit (an Exception being thrown).
PS: showing your code in PRE tags would improve readability and make it easier to spot the problem.
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
