|
multiplication of columns MemberCount and Commission upto Levels 1 to 6 is to be done and result should be displayed into the column MemberGrandTotal
|
|
|
|
|
Hi Sir
I am new for .net.I'm Creating Student mark list program.
I have one doubt in sql.
for every sql operation i am opening sql connection after i'm closing the connection.
is this wright?due to this any problem will come?
|
|
|
|
|
The answer to this one is "It depends". Is your application a desktop application running a local database instance? If so, it may be acceptable to open up a connection and leave it open for the duration of your processing (with appropriate code in place to take care of database crashes). Is this running on an ASP.NET application? If so, you MUST release the connection as soon as practically possible.
"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
|
|
|
|
|
Dear Sir
I'm Using .net windows application & local instance only.
I'n my project i did't write code for closing the database,it is always open only.
What is My problem is Yesterday i asked my Crystal report view (first time) taking long time.
U replayed "//
If your database connection has not been pooled, then the first preview will take a lot longer than the second time where it's pulled from the pool.//" like this .thats y i'm asking i want to close or not(my database connection)
|
|
|
|
|
Again - this is up to you. Basically, when you open up a connection the first time, this takes quite a while - if you open it again and it's in a connection pool, the connection is taken from the pool (assuming you supply the same credentials). If you leave the connection open, then the first time it will take a while, but the next time it will be a lot faster because you won't have the overhead of opening the connection.
"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
|
|
|
|
|
Once again thnx for ur Replay Sir.
Sir
Crystal report Preview i want fast,For that tell any one simple way.
I'm Not too intelligent please solve my problem.
|
|
|
|
|
The data is not getting inserted into the database...
i have written the following code...
SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=MLM;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand("Insert into RegistrationForm(UserName,Pin_ID,SponserName,Sponser_Pin,Registration_Date,Main_Sponser_Name,Placement_Info,Title,Maritial_status,MemberName,CompanyName,Date_Of_Birth,Age_In_Years,Mother_Name,Address,City,State,PinCode,Phone_No,Mobile_No,Email_Id,Pan_No,Nominee_Name,Relation_with_member,Nominee_Birth_Date,Age,DD_No,Bank_Name,Branch_Name,Enter_Login_Password,Confirm_Login_Password,Enter_Pin_Password,Confirm_Pin_Password)values('" + TextBox30.Text + "','" + TextBox31.Text + "','" + TextBox26.Text + "','" + TextBox27.Text + "','" + TextBox28.Text + "','" + TextBox29.Text + "','" + RadioButtonList1.Text + "','" + DropDownList4.Text + "','" + DropDownList6.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox3.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + DropDownList5.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "'," + TextBox16.Text + "," + TextBox17.Text + ",'" + TextBox18.Text + "','" + TextBox19.Text + "','" + TextBox20.Text + "','" + TextBox21.Text + "','" + TextBox22.Text + "','" + TextBox23.Text + "','" + TextBox24.Text + "')", con);
string s1 = TextBox30.Text;
string s2 = TextBox28.Text;
string s3 = TextBox1.Text;
string s4 = TextBox7.Text;
string s5 = TextBox8.Text;
string s6 = DropDownList5.Text;
string s7 = TextBox9.Text;
string s8 = TextBox27.Text;
string s9 = TextBox26.Text;
Response.Redirect("Welcomeltr.aspx?TextBox30=" + s1 + " &TextBox28=" + s2 + "&TextBox1=" + s3 + "&TextBox7=" + s4 + "&TextBox8=" + s5 + "&DropDownList5=" + s6 + "&TextBox9=" + s7 + "&TextBox27=" + s8 + "&TextBox26=" + s9);
com.ExecuteNonQuery();
//com2.ExecuteNonQuery();
con.Close();
Thanks in advance
|
|
|
|
|
Several things come to mind looking at your code.
1. This isn't the ASP.NET forum.
2. Your variable naming convention sucks. TextBox28? TextBox29? What do they mean? Please - give variables a more meaningful name.
3. Your code is wide open to SQL Injection attacks.
4. You do a redirect before you ever attempt the execute on the SQL.
5. Your redirect is using unencode URL entries - what happens, for instance, if TextBox30 is "Hello there'.!***"?
"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 dictionary of x and y cordinates and with this cordinate i have drawn a polygon.After drawing the ploygon it is now combination of Lines And Curves.
Can any one guide me how to segregate points of dictionary that I can understand these points are for Line and those points are for Curves.
with regards
tarak
|
|
|
|
|
I'm not sure I understand the problem.
Surely, if you're drawing the lines and curves you know which points you've used for each, and can save that information.
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
hiii
molesworth
The drawing of polygon is in very later stage.
My aim is by visualizing the neighbouring point how can i under stand these set of points will be in straight line and those set of points will be in curve????
|
|
|
|
|
Ah, I think I understand. You want to draw a line when the points are on a line (or close to it) and a curve of some sort otherwise.
The simplest way that comes to mind is to calculate the slope of the line segments between pairs of points and if all the slopes are equal (within some reasonable limits) then the points lie on a straight line.
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
hi
molesworth
thanx for reply.
|
|
|
|
|
hi
molesworth
thanx for reply
But there may be lots of line in various direction..in that case how the slope is same for every line??
|
|
|
|
|
It seems I've misunderstood your problem. I was guessing from the description that you had a number of points (x,y) and wanted to draw lines through them. If the points lie on a straight line, then you want to draw only that straight line through them, but if they don't then you want to draw a curve through them.
Perhaps you can explain with a bit more detail what you are trying to do.
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
Mr.molesworth
thanx for reply
yes u are right that i have number of points(x,y) near about 1000.If i plot all these points in graph paper then it looks like a polygon.And polygon is combination of lots of curve and lines. And in curve there are lot of combination of small length of straight line.Basicaly if i join two point it becomes straight line.
And in curve the each small straight lines bend very slightly and it appears in graph like a curve. But i dont want to plot these point on the graph paper.
Only i have set of points(x,y).
How can i calculate that some set of points will be used for drawing one or more than one curve and other set of points will be used for drawing the line or lines..
awaiting for ur reply....
|
|
|
|
|
TARAK NATH ROY wrote: i have number of points(x,y) near about 1000.If i plot all these points in graph paper then it looks like a polygon.And polygon is combination of lots of curve and lines
OK, I think I understand a bit better now. You have a large list of points, and want to draw a figure from them, using straight lines and curves to best fit the shape. Although to be technically correct, a polygon is a shape made of only straight lines, I get what you mean.
So, you need to go through the list, finding the sections which are best drawn as straight lines, and which are best as curves. My previous suggestion about matching slopes is probably still a reasonable way to try, but over limited ranges of points.
If you calculate the slope between points (Xn, Yn) and (Xn+1, Yn+1) as (Yn+1 - Yn) / (Xn+1 - Xn) then you can compare the slope values as you step through the list (increasing n).
If consecutive slopes are equal, or better, if the difference between them is less than some small constant, then the group of points are all very close to being a straight line. If you get a change in slope, greater than your limit value, then you've entered a curve region.
As you go through the points you can either copy them to separate line and curve lists, or possibly note the indices where the type of line changes.
Drawing the straight lines is easy, however you may have to look at your data more closely to find the best curve drawing method to give a good match.
Here's a rough pseudo-code version of what I'm describing above :-
lastSlope = 0;
for (int n=0; n<numPoints; ++n)
{
slope = (Y[n+1] - Y[n]) / (X[n+1] - X[n]);
if (abs(slope - lastSlope) < smallValue)
{
}
else
{
}
lastSlope = slope;
}
I hope that helps you a bit... 
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
As an alternative to my last post, you could always try just drawing straight lines between the points, and seeing what it looks like.
I have an audio waveform display in the project I'm currently working on, and I just join all the sample values with straight lines, which looks fine since there are so many of them in the view.
You might get away with just doing that...
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
After installing WSE 3.0 Runtime, the option for WSE setting is not available when you right click on the slolution.Even there is no "WSESettingsVS3.Addin" file available at "C:\Documents and Settings\All Users\Application Data\Microsoft\MSEnvShared\Addins " location. Does anybody know the reason behind this ? 
|
|
|
|
|
Dear Friends.
Actually i need to debug my setup projects. which is is Release mode.
i can able to debug my projects in Debug mode.
whats is wrong in my coding
public override void Install(System.Collections.IDictionary stateSaver)
{
try
{
System.Diagnostics.Debugger.Launch();
//----
// My Stuff here
//----
}
catch (Exception ex)
{
}
}
And also i tried this instead of
System.Diagnostics.Debugger.Launch();
#if DEBUG
if (System.Diagnostics.Debugger.IsAttached)
System.Diagnostics.Debugger.Break();
#endif
Please tell me, the solution to debug my project in Release mode.
|
|
|
|
|
Seems you don't have a clear idea about the Debugging API. What you exactly want to do? Tracing any problem happens during the setup? ...you can use logging for that.
Moim Hossain
R&D Project Manager
BlueCielo ECM Solutions BV
|
|
|
|
|
Dear Friends.
How to run .net application on Macintosh operating system. .net WMI works on Macintosh Operating System or not.
Please help me resolved this problem.
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
Eventure Technology
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
What you need is The Mono Project, which should do what you are looking for.
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
but The Mono Project not support all namespace of .net for example:-Wmi,Drive Info and Etc
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
Eventure Technology
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Ah, sorry - I didn't take in the reference to WMI in your original post.
Mono is an ongoing project, and continually being added to. Unfortunately, if you need something that isn't currently implemented there's not much you can do. I'm surprised DriveInfo isn't in yet though.
As far as I know Mono is the only real way to get .Net apps running under OS-X. Perhaps you can write work-arounds using the features which are implemented?
edit : DriveInfo is implemented in Mono. Perhaps the features of WMI that you need are also available. It would be worth checking.
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
