ASP.NET

Abhijit Jana wrote:

You can't use over here. You need to used '@' when you are using parameter only.

using(SqlConnection objConnection = new SqlConnection)<br />
{<br />
objConnection.Open();<br />
string query = "Select * From goods where G#=@GParam";<br />
using (SqlCommand command = new SqlCommand(query, objConnection))<br />
{<br />
command.Parameters.Add(new SqlParameter("@GParam", SqlDataType.yourtype, value)); // Do replace with your value here.<br />
SqlDataReader reader = command.ExecuteReader();<br />
if (reader.HasRows)<br />
{<br />
while (reader.Read())<br />
{<br />
// Do sth<br />
}<br />
}<br />
}<br />
}

benams wrote:

where can I get an asp .net based forum?..

benams wrote:

where can I get an asp .net based forum?..
It doesn't need to be free...I'm willing to pay for it.

greendragons wrote:

I have some issues with sql on my vista so unfortunately i have to use ms access..

greendragons wrote:

Do u have yahoo id..i want to solve my some queries.

greendragons wrote:

that i can get just date part from datetime object..?

DECLARE @DateOnly DATETIME<br />
SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)

greendragons wrote:

For c#

DateTime dt=DateTime.Now;
int year=dt.Year;
int month=dt.Month;
int day=dt.Day;