|
|
|
excuse me are you from iran
|
|
|
|
|
|
I am trying to use Lognormal distribution in one of my projects and require the inverse Cumulative distribution function.
Any help would really be appreciated
|
|
|
|
|
|
Thank you Richard, I was not looking for a code. using lognormal means that I need to use the inverse of an ERF or ERFC. I know that both are implemented in c#, and was merely looking for some help in directing my search.
|
|
|
|
|
|
This form search in one table (Name,Address,Age)
Name| operate | value
Address| operate | value
Age | operate | value
Ex:
Name | = | JON
Address| like | New
Age | between | 18 50
Please help me the best solution for this problem
|
|
|
|
|
select * from tablename where
name = 'JON' and
address like '%New%' and
age between 18 and 50
|
|
|
|
|
Thanks Guy,
This problem is difficult. User can select the operator ">" or "<" or "between" ,...- not fix.
After user select some operator and input some values, we will create sql query
|
|
|
|
|
Peter Leow supplied the script here is some more
Create a form with 3 text boxes a button (Search) and a grid.
when the user clicks the search button trap the event and
make a connection to the database
pass in the query based on the data entered into the textboxes (using PLs query example)
get the dataset from the sql command object
bind the datatable to your datagridview
Improve the query by using parameters - see "Little Bobby Tables"
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks Guy,
This problem is difficult. User can select the operator ">" or "<" or "between" ,...- not fix.
After user select some operator and input some value, we will create sql query
|
|
|
|
|
Create a class Criterion with 4 string properties: Name, Operation, Value, SecondValue - yes, the SecondValue is required in such rare case like that "between". Also create a collection class for it, e.g. Criteria:List<Criterion> .
The most complicated part is the ToSQL() of Criterion. In many cases, simple concatenation will suffice.
Then start your query with
string query = "SELECT * FROM MYTABLE WHERE 1=1 "
then simply iterate thru the collection and add
query += " AND " criterion.ToSQL();
Well, that is still open to SQL Injection. Update the ToSQL function and do another loop to add the parameters then (next step - doing it in one step is surely still beyond your level, but with two steps, you could do it).
|
|
|
|
|
thank your comment. i will try with this solution
|
|
|
|
|
My funtion done:
private void radButton1_Click(object sender, EventArgs e)
{
string query = "SELECT * FROM Mytable WHERE 1=1 ";
if (txtValue1.Text.ToString()!= "")
{
query += " AND " + OpeReturn(FullName.Name.ToString(), cboOpe1.SelectedIndex.ToString(), txtValue1.Text.ToString());
}
if (value2.Text.ToString() != "")
{
query += " AND " + OpeReturn(TotalAmount.Name.ToString(), cboOpe2.SelectedIndex.ToString(), value2.Text.ToString());
}
query.ToString();
SearchContractBindingSource.DataSource = RemoteClient.remoteData.QueryHopDongBan(query);
}
private string OpeReturn(string field, string ope, string value)
{
switch (ope)
{
case "0":
return field + " like " + "'%" + value + "%'";
case "1":
return field + " not like " + "%" + value + "%";
case "2":
return field + " like " + value + "%";
case "3":
return field + " like " + "%" + value;
case "4":
return field + " = " + value;
case "5":
return field + " != " + value;
case "6":
int index = value.IndexOf(" ");
string value1 = (index > 0 ? value.Substring(0, index) : "");
string value2 = (index > 0 ? value.Substring(index + 1) : "");
return field + " > '" + value1 + "' AND " + field + " < '" + value2 + "'";
case "7":
return field + " > " + value;
case "8":
return field + " >= " + value;
case "9":
return field + " < " + value;
case "10":
return field + " <= " + value;
default:
return " 1 = 1 ";
}
}
Thank All!
|
|
|
|
|
Message Closed
modified 12-Apr-14 1:54am.
|
|
|
|
|
|
OK, I'm sure there is about 1,000 widgets out there on the web. It's just a matter of you typing into Google what you're looking for.
|
|
|
|
|
|
Shady George wrote: what's a widget?
You know, a thing-a-ma-doodle.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Oh right, one of them. That'll be in .NET 3.Silly won't it?
|
|
|
|
|
Sounds like a deal - but only if I get the domain thrown in.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Create using Jquery and server side code.
|
|
|
|
|
my sql server procedure is
"
Collapse | Copy Code
CREATE PROCEDURE [dbo].[Attendence]
@EmployeeId int
as
if not exists(select * from TblAttendence where convert(varchar(10) ,CreateDate,23) =convert(varchar(10) ,GETDATE(),23) and EmployeeId =@EmployeeId)
select * from TblAttendence where convert(varchar(10) ,CreateDate,23) =convert(varchar(10) ,GETDATE(),23) and EmployeeId =@EmployeeId
Else
update TblAttendence set LastLoginTime=GETDATE() where EmployeeId=@EmployeeId and convert(varchar(10) ,CreateDate,23) =convert(varchar(10) ,GETDATE(),23)
GO
|
|
|
|