|
|
Hello
Im using:
SQL Server 2005 - VS 2008
Im trying to read data with using DataReader.
when I want to replace my data with variable there is an error :
Must declare the scalar variable "@G#".
Behind code :
objConnection.Open();<br />
string query = "Select * From goods where G#=@G#";<br />
objDataAdapter.SelectCommand.Parameters.AddWithValue("@G",Textbox.Text);<br />
using (reader = new SqlCommand(query, objConnection).ExecuteReader())<br />
{<br />
if (reader.HasRows)<br />
{<br />
while (reader.Read())<br />
{<br />
}<br />
}<br />
}
TIA
|
|
|
|
|
comp_j wrote: string query = "Select * From goods where G#=@G#";
What was that ?
G# is your field name ?
comp_j wrote: @G#"
You can't use over here. You need to used '@' when you are using parameter only.
|
|
|
|
|
Yes, it is my field name.
Abhijit Jana wrote: You can't use over here. You need to used '@' when you are using parameter only.
I didnt understand what you said. plz explain it with a sample code.
|
|
|
|
|
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));
SqlDataReader reader = command.ExecuteReader();<br />
if (reader.HasRows)<br />
{<br />
while (reader.Read())<br />
{<br />
}<br />
}<br />
}<br />
}
Hope this works...
|
|
|
|
|
It worked
Thank you so much.
|
|
|
|
|
you are most welcome friend.
|
|
|
|
|
where can I get an asp .net based forum?..
It doesn't need to be free...I'm willing to pay for it...
|
|
|
|
|
benams wrote: where can I get an asp .net based forum?..
You are already in a best ASP.NET 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.
So, you want to develope a ASP.NET Web forum ?
Have a look into it.
Kigg
|
|
|
|
|
you need only two controls, gridview and detailsview to design a forum.
Obviously, some database tables, and stored procedures or SQL queries ...
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
|
I am creating a site for social gathering as a part of my project...i want that unaccepted friend request should be deleted after 10 days. For this im using current date time and substracting it with the date time selected from database(datetime when friend request was sent)..its giving value of datetime but i just want date part of it not time so that i can convert into int and compare it with 10..if greater than 10 then delete that record..
|
|
|
|
|
How you are planning for implement it. I will suggest you to forget about to ASP.NET, Implement this part using SQL Server only ( IF your DB is SQL Server ).
Create a SQL Server Job Agent, which will check for some status from DB, if this is unaccepted then delete the request.
Hope you understood what I mean.
|
|
|
|
|
I have some issues with sql on my vista so unfortunately i have to use ms access..
|
|
|
|
|
greendragons wrote: I have some issues with sql on my vista so unfortunately i have to use ms access..
Why what is the problem, for what you want to move total database to MS-SQL to Access ?
|
|
|
|
|
Not moved db..instead i cant find option to open database in sql configuration manager..sql server surface area coniguration and sql server config manager r the only two icons i can see. I cant' find option to create db , add tables n all..i tried hard..even sql express was not working before but anyhow i managed to enable that bt still it shows account login failed..
|
|
|
|
|
You need SQL Server Management Studio for it. Please Install SSMS.
|
|
|
|
|
Do u have yahoo id..i want to solve my some queries..they are headache from long time please..my id is dorian_yates2007@yahoo.co.in
|
|
|
|
|
greendragons wrote: Do u have yahoo id..i want to solve my some queries.
You are welcome. Check my ID from my profile Page. Feel free to drop me mail.
Thanks.
|
|
|
|
|
Sure..but what about my problem is ther anyway that i can get just date part from datetime object..?
|
|
|
|
|
greendragons wrote: that i can get just date part from datetime object..?
U are asking for C# or SQL ?
here it for SQL
DECLARE @DateOnly DATETIME<br />
SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)
Details Source : Check
|
|
|
|
|
|
greendragons wrote: For c#
This is genral syntax.
DateTime.Now.ToShortDateString();
Some more clarification :
DateTime dt=DateTime.Now;
int year=dt.Year;
int month=dt.Month;
int day=dt.Day;
Hope this will help you
|
|
|
|
|
Thnx alot it's working..
Timespan ko = date1.subtract(dtc);
int day= ko.days;
now i can eaisly check dates THNX!
|
|
|
|
|
You are welcome !
|
|
|
|