|
I need to make record keys for DataGrid row items available to my client-side code. I've tried adding a template column with a hidden input, and width of zero, but the column still appears in the browser. Is there some better way of sending the record key for a grid row to the client?
|
|
|
|
|
what do you mean
Brady Kelly wrote: DataGrid row items available to my client-side code.
|
|
|
|
|
Let's say a row in the DataGrid contains "Closed Job Report", and the ID for that report is 17. I needed to send that 17 to the client somehow, without including it in a column.
I have found a way, by adding an attribute to the Item in OnItemDataBound, this causes each table row rendered by the grid to have that attribute.
|
|
|
|
|
ah I see what you mean now, well done!!
|
|
|
|
|
Brady Kelly wrote: without including it in a column.
Why not a column that is not visible?
led mike
|
|
|
|
|
Have you tried setting DataKeyField ?
|
|
|
|
|
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?
|
|
|
|