Comments by vinayoukuri

vinayoukuri 25-Jul-13 8:09am View

Do you like to select such records or you want to stop inserting such records into table.

vinayoukuri 24-Jul-13 1:58am View

Read about SqlDependency Caching

vinayoukuri 23-Jul-13 8:24am View

i have updated again

vinayoukuri 23-Jul-13 8:15am View

I have updated the query to group by qty_device_id.

vinayoukuri 23-Jul-13 7:28am View

please check this ..

SELECT Tbl_Device.Device_Name,
Tbl_ReceivedQty.Qty_Device_ID,
Tbl_ReceivedQty.Qty_User,
Tbl_ReceivedQty.Qty_Date,
temp1.sumOfQty
FROM Tbl_Device
INNER JOIN Tbl_ReceivedQty
ON Tbl_Device.Device_ID = Tbl_ReceivedQty.Qty_Device_ID
inner join (select Qty_Device_ID, sum(Qty_Received) as 'sumOfQty' from Tbl_ReceivedQty group by Qty_Device_ID) temp1
on Tbl_Device.Device_ID = temp1.Qty_Device_ID
where Qty_Date between '2013-07-21' and '2013-07-23'

vinayoukuri 23-Jul-13 6:29am View

Please check your Date values(#7/13/2023 15:22:58#)they are same. the condition will return always null for such data.

vinayoukuri 23-Jul-13 5:34am View

Whar are you working on mysql or mssql?

vinayoukuri 23-Jul-13 3:01am View

You can specify them in web.config. If you want to set it in IIS, Click on ConnectionStrings icon under Asp.net section.There you can click on existing connection string and edit it or click Add on Actions and the interface is intuitive where you can cofigure the connectionstring easily.

vinayoukuri 22-Jul-13 8:06am View

Please clarify below question, before answering your question.

Is each student is member of the application database?

vinayoukuri 22-Jul-13 7:19am View

please provide the code you have written. To write an extension method, the method should be static and the method parameter should be the instance of class for which the extension method is applied.
Example :
public static void removeSelected(this ListBox lst)
{
// Sample Code
lst.remove(lst.selected.value.Tostring)
}

Comments by vinayoukuri (Top 10 by date)