|
Hi
I have the following:
SqlDataSource_GridView_roomSchedule.SelectCommand =
"SELECT room_code, room_schedule.parentarea, instance_variant, Room_ID, project_room_description, level, areaslevel3.arealevelid " +
"FROM room_schedule, areaslevel3, areaslevel2, areaslevel1" +
"WHERE room_code like'" + searchroomcode + "'" +
"AND room_schedule.parentarea = areaslevel1.arealevelid AND" +
"areaslevel1.parentarea = areaslevel2.arealevelid AND" +
"areaslevel2.parentarea = areaslevel3.arealevelid AND" +
"areaslevel3.arealevelid in" +
"(SELECT areasLevel3_id" +
" FROM room_schedule_permission" +
" WHERE username = '" + username + "' AND" +
" permission_start_date < getdate()AND" +
" permission_expiry_date > getdate())";
I get the error Incorrect syntax near keyword 'like'.
but when I put this code in sql query analzyer and hardcode the values where string values are it works fine, any help would be appreciated
thanks 
|
|
|
|
|
a-+s-+p-+ wrote: "WHERE room_code like'" + searchroomcode + "'" +
I think you need to add '*' to the right and left of the searchroomcode
"WHERE room_code like'*" + searchroomcode + "*'"
if the searchroomcode is not of type string, remeber to call ToString()
"WHERE room_code like'*" + searchroomcode.ToString() + "*'"
I hope this helps
Mohamed Gouda
Egypt
|
|
|
|
|
Use a stored proc and stop writing inline SQL
only two letters away from being an asset
|
|
|
|
|
I found the problem, there was no space bwteen the speech marks so it wasnt reading the statement right
cheers!!
i love inline sql! 
|
|
|
|
|
a-+s-+p-+ wrote: i love inline sql!
Why ? You love unreadable code ? Or is the fact that it is unmaintainable that seems so great to you ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
No but the fact I've got twenty different databases using the same code makes writing inline sql the more viable option
I see your job is to provide witty or useless comments on each post especially this page..
|
|
|
|
|
try to do like this
"Select * from Visitors where VisitorName like '" & TextBox1.Text & "%'"
Raghvendra
|
|
|
|
|
I have a datagrid displaying data summary
And when the client selects a row, the details of the selection appears down the datagrid in some text boxes and lables
I want the page to scroll down and the focus is set on one of the details' fields.
Mohamed Gouda
Egypt
|
|
|
|
|
How do you mean the focus is set on one of the fields?
Do you want the user to be able to click on a row and then go to another page with those details?
|
|
|
|
|
a-+s-+p-+ wrote: Do you want the user to be able to click on a row and then go to another page with those details?
No the field is in the same page as the datagrid
but the datagrid has to display 10 records per page, which occupy most of the page.
so the user needs to scroll down to read the details
I need to have that done automatically on the selectedIndexChange event of the datagrid
Mohamed Gouda
Egypt
|
|
|
|
|
ah rite so they click on a link and it takes them down to the next part of the page?
is that right
normally with a hyperlink you would put a # on the end then put a div and name that # i think
|
|
|
|
|
a-+s-+p-+ wrote: you would put a # on the end then put a div and name that # i think
It works but ....
I used Response.Redirect() to achive your idea but the Redirect method resets the selection
Any altrnative to Response.Redirect() ?
M. Gouda
foreach(Minute m in MyLife)
{
myExperience++;
}
|
|
|
|
|
I need to check that gridview is empty.
so I use
if(gridview1.Rows.Count==0)
{
Button1.Visible=fase;
}
But this never works coz it seems that the gridview has rows.
I'm using the emptytemplate to be displayed automatically when there is no data returned.
My problem is the I'm using a sql datasource so I have no dataset or datatable to check against if no data is returned.
Help please!
|
|
|
|
|
Nada Adel wrote: so I have no dataset or datatable to check against
Why not? The gridview doesn't have a datasource property?
only two letters away from being an asset
|
|
|
|
|
use emptytemplate
Best Regards,
Chetan Patel
|
|
|
|
|
can you write the exact code to use the emptytemplate?
|
|
|
|
|
if (gridview.EmptyDataTemplate == true)
maybe this
|
|
|
|
|
Why are you using gridview1 and button1 as variable names ? This isn't real world code, you're just playing about ?
Nada Adel wrote: My problem is the I'm using a sql datasource so I have no dataset or datatable to check against if no data is returned.
That stuff is nasty to begin with.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I'm actually using other variable names, these names are only to point out my problem. Do you have a solution for my problem?
|
|
|
|
|
Hi All
I have a Web Solution contain Asp WebSite project & Asp web service
and when i Add web refrance to link web service with the website
it gives me this error
but i don't know wht is this error reffer to
-----------------------------the error------------------
Cannot serialize member System.ComponentModel.Component.Site of type System.ComponentModel.ISite because it is an interface.
Kareem Elhosseny
|
|
|
|
|
Hi Friends,
I have a GridView in which the row or the data is getting selected on the checkbox click.
I want to enable paging in the GridView such that when i go to next page then the previuos selection
remains as it is...means i can perform operations on current selection as well as previous selection.
Do anyone have any idea?
Thanks in advance,
|
|
|
|
|
I'm not sure if you can do that
Paging is a custom tool for asp.net and therefore may be hard to manipulate
Can you explain a bit more about what the problem is, might be able to think of another solution
|
|
|
|
|
yeah sure!
I have GridView, in which there is a checkbox control on teh selection of which i performs some operations like download the data etc.
Now i ahve a no. fo records in the GridView and I want to do paging,
and if i select 1 and 3 records on page 1 by checking the checkbox and goes to page2
and select record say 8 and 9 from page to and I click the download button
It should download records 8 and 9 as well as 1 and 3 which are from teh previous selection.
I do not want to lose the checkbox selection if i navigates from page to apge.....
|
|
|
|
|
you could try storing the values in a session, i.e. put the checked rows ID in a session and then when the user clicks the button it then downloads all things that match the row id values
|
|
|
|
|
Sorry!
but i m not getting it,can please explain in detail
see I am nto able to do paging,since i m binding the GridVeiw manually
like gdview.datasource=some dataset
gdview.databind()
now the code in PageIndexChanging is
protected void gdview_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gdview.PageIndex = e.NewPageIndex + 1;
gdview.DataBind();
}
now when i run teh app. and go to page 2 on GridVeiw it doesn't show the next record
and when i debug after placing the breakpoint at
protected void gdview_PageIndexChanging(object sender, GridViewPageEventArgs e)
it goes to some Deassembly tab
D:\AjaxControlToolkit\AjaxControlToolkit\ExtenderBase\ExtenderControlBase.cs
like this........ 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
