|
I'm using an Access database in Visual C# - how can I delete a record from the database permanently? When I use .RemoveAt(int pos) it removes it only from the dataset, but when I reload the program the record is back.
|
|
|
|
|
You need to write delete query and execute it.
|
|
|
|
|
How I could get Last day of the current month in SQL Server?
I want to get records with respect to Date that lies with in the Current month or later. Please help me out.
|
|
|
|
|
AFAIK, there is no inbuilt functions available. Use Month() for comparing using month.
|
|
|
|
|
Please post this in the SQL forum. This forum is for C#.
|
|
|
|
|
I knocked this solution up for you:
select
dateadd(d,-1,
cast(cast(datepart(month,dateadd(m,1,getdate())) as varchar(2))+
'/'+
'1/'+
cast(datepart(year,dateadd(m,1,getdate()))as char(4))as datetime))
The way the query works is to calculate the first day of the next month then to subtract one day from this.
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
|
Hi friends,
I have a homework, i worked for days but I got stuck in a point. I can't go out of this point.
I am very glad if you can help me.
I make effort to get a query from from northwind database sample. I want max sales of employees according to product.
There are 9 employees(sales persons). There are 77 products type. Salespersons sell this products. I want ,which product was sold maximumly according to sales turnover. The result must be like below
salesperson product sales amount
salesperson1 product a x
salesperson2 product b y
. .
. . .
.
salesperson9 product h w.
I tryed below script, I can find max sales of each salespersons but I can't add productname column to this query.
select t.firstname,t.lastname,max(t.sales) as sales
from (select employees.Firstname,employees.lastname,products.productname,
sum("order details".unitprice*quantity*(1-discount)) as Sales from ((Employees inner join orders on employees.employeeID=orders.employeeID) inner join "order details" on orders.orderID="order details".orderID) inner join products on products.productID="order details".productID
group by employees.lastname,employees.firstname,products.productname
) as t
group by t.firstname,t.lastname
order by t.firstname
Note: I got answer from Jacob Sebastian like below, bu i didn't understand exactly that response. It works but I didn't understand, especially top1 clause. The result consists of 9 row but top1 gives one row according to I know and link between a and b is very complex.
SELECT
FirstName,
LastName,
(SELECT TOP 1 ProductName FROM (SELECT
e.FirstName,
e.LastName,
p.ProductName,
SUM(od.UnitPrice * od.Quantity*(1-Discount)) AS Sales
FROM Orders oh
INNER JOIN [Order Details] od ON oh.OrderID = od.OrderID
INNER JOIN Products p ON p.ProductID = od.ProductID
INNER JOIN Employees e ON e.EmployeeID = oh.EmployeeID
GROUP BY e.FirstName, e.LastName, p.ProductName ) b
WHERE a.FirstName = b.FirstName AND a.LastName = b.LastName
ORDER BY Sales DESC
) AS ProductName,
MAX(Sales)
FROM (
SELECT
e.FirstName,
e.LastName,
p.ProductName,
SUM(od.UnitPrice * od.Quantity*(1-Discount)) AS Sales
FROM Orders oh
INNER JOIN [Order Details] od ON oh.OrderID = od.OrderID
INNER JOIN Products p ON p.ProductID = od.ProductID
INNER JOIN Employees e ON e.EmployeeID = oh.EmployeeID
GROUP BY e.FirstName, e.LastName, p.ProductName
) a
GROUP BY FirstName, LastName
ORDER BY FirstName, LastName
modified on Monday, January 07, 2008 3:27:58 AM
|
|
|
|
|
Please post this on the SQL forum, especially as you have had this answered before. It's only polite to continue this on the original thread.
|
|
|
|
|
I am sorry, but there are less people in sql form. Here, replies are faster
and most of people in c# form know sql.
|
|
|
|
|
omegazafer wrote: I am sorry, but there are less people in sql form. Here, replies are faster
and most of people in c# form know sql.
That's an abuse of the forum system. How do I find an answer to a problem in future if it's not in a logical area? Why not ask a C# question in the C++ forum because the syntax is a little bit similar? There's a reason why these forums are organised the way they are, and it's not to provide a shortcut for somebody who's too lazy or incompetent to use the appropriate forum.
|
|
|
|
|
I have data in txt format and want to save the data in my table in SQL database. How can I do this without using DTS?
|
|
|
|
|
minniemooo wrote: I have data in txt format
txt file ? Then open it using your program, read contents and insert into DB.
|
|
|
|
|
|
Ok the following is a lambda:
Func<..> func = i => i * 3;
And this is an anonymous delegate
Func<..> func = delegate (int i) {return i * 3; ) ;
But what about this?:
Func<..> func = (int i) => { return i * 3;}
Is this considered a lambda, due to the fact it uses the lambda syntax..
Or is it considered an anonymous delegate due to the fact that it can not be converted to an linq.expression
Im I right if I say that it is infact an anonymous delegate and that only the "one line" forumulas w/o any { } body are real lambdas?
If it is considered a lambda, since it uses the lambda syntax after all. and it also benefits from type deduction and all that.
Is there any word or way to make a difference between one line lambdas that can be turned into linq.expressions and those that only can fill the role of plain old delegates?
modified on Monday, January 07, 2008 3:06:45 AM
|
|
|
|
|
I want to implement some reports in C#, what will be the best approach?
|
|
|
|
|
|
Hi All,
I am new in c#.I want to read the file till End.how can I do?
please urgent!
Regards,
chanzeb
|
|
|
|
|
use File.ReadAllText(filePath)
|
|
|
|
|
I have VB.NET code shown below.
Module Module1
Sub Main()
Dim objClass1 As New class1()
objClass1.MyProg(Nothing)
End Sub
Public Class class1
Public Function MyProg(ByRef objStruct As MyStruct)
End Function
End Class
Public Structure MyStruct
Public a As Integer
End Structure
End Module I need to convert this to C# equivalant. So I wrote the following,
class Program
{
static void Main(string[] args)
{
Program p = new Program();
p.MyProg(null);
}
public void MyProg(ref MyStruct objMyStruct)
{
}
}
struct MyStruct
{
} In VB.NET code compiles correctly. But C# shows error saying that "invalid parameters". How can I pass a null value to a reference parameter ? I know a structure instance can't be null. But how does this happened with VB.NET ? Any idea's ?
|
|
|
|
|
Hi,
a parameter that is to be considered a ref (or an out) needs a ref (or out) keyword
both at the caller and the callee.
however "ref null" is not acceptable since null "is not an assignable variable".
So you need to use a variable as in:
objStruct dummy=null;
objStruct dummy=new objStruct();
p.MyProg(ref dummy);
|
|
|
|
|
Thanks. I did the same. But how come this worked for VB.NET, stupid VB.NET
|
|
|
|
|
hi all
I need to insert a date value to the database through the form(using insert button).in the database i have declared date as datetime type.while inserting the data iam getting some problems.is there any way to insert only date (without time)through the form.
pintoo
|
|
|
|
|
No. Time will be inserted automatically. You can avoid showing the time when you do select. Look into Convert[^] function.
|
|
|
|
|
Hi All
I wount to creat Form In .Net Have One ProgressPare .
And I Wount to Call this Form In Any OPeration Fill DataTable From DataBase The ProgressPare Value is Equal The Persenteg of number Rows Is Load in to Datatable to The Number Of Rows from DataBase .
I wount to know the Idea Who I Can do that ?
Thanks For Any Body Hellp me
Thaer
|
|
|
|
|
Thaer Hamael wrote: I wount to creat Form In .Net Have One ProgressPare .
What is ProgressPare ? You can use ProgressBar control. Set the Max value to the rowcount of your datatable.
|
|
|
|