Datagrid help

[powerranger]

I have a datagrid which contains links. Once the user clicks on one
of the link, it supposes to refresh the reform and saves the data in a
hidden field. I don't know if it is possible. And also, once the user
clicks on the link, can it run the csharp code in the codebehind?

Thanks.

[momo]

Hello all,

I need help with this. I have a datagrid (dg1) with checkboxes and I want
when some rows are selected to populate another datagrid (dg2) with the
selected rows from (dg1).

Thanks

Momo

[VLAD]

I am using Provider=MSIDXS.1 and following code to fill datagrid.


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim strCatalog As String

' Catalog Name

strCatalog = "TestCatalog"

Dim strQuery As String

If TextBox1.Text <> "" Then

DataGrid1.Visible = True

strQuery = "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where FREETEXT('" & TextBox1.Text & "')"

Dim connString As String = "Provider=MSIDXS.1;Integrated Security ..='';Data Source='" & strCatalog & "'"

Dim cn As New System.Data.OleDb.OleDbConnection(connString)

Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)

Dim testDataSet As New DataSet()

cmd.Fill(testDataSet)



Dim source As New DataView(testDataSet.Tables(0))

DataGrid1.DataSource = source

DataGrid1.DataBind()

Else

DataGrid1.Visible = False

End If

End Sub

End Class



The result I am getting in datagrid is in plain text

How do I make datagrid to show url in clickable format?
Or how can I make datagrid item in hyperlink format?

[VLAD]

I am using Provider=MSIDXS.1 and following code to fill datagrid.


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

Dim strCatalog As String

' Catalog Name

strCatalog = "TestCatalog"

Dim strQuery As String

If TextBox1.Text <> "" Then

DataGrid1.Visible = True

strQuery = "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where
FREETEXT('" & TextBox1.Text & "')"

Dim connString As String = "Provider=MSIDXS.1;Integrated Security .='';Data
Source='" & strCatalog & "'"

Dim cn As New System.Data.OleDb.OleDbConnection(connString)

Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)

Dim testDataSet As New DataSet()

cmd.Fill(testDataSet)



Dim source As New DataView(testDataSet.Tables(0))

DataGrid1.DataSource = source

DataGrid1.DataBind()

Else

DataGrid1.Visible = False

End If

End Sub

End Class



The result I am getting in datagrid is in plain text

How do I make datagrid to show url in clickable format?
Or how can I make datagrid item in hyperlink format?
Thanks in adv.

[Alvin Bruney]

search this newsgroup for today. i've posted code to add a hyperlink.

--
Regards,
Alvin Bruney
Got tidbits? Get it here...
[url]http://tinyurl.com/2bz4t[/url]
"VLAD" <VLADP@camba.org> wrote in message news:%23f0$2QI1DHA.1924@TK2MSFTNGP10.phx.gbl...
I am using Provider=MSIDXS.1 and following code to fill datagrid.


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim strCatalog As String

' Catalog Name

strCatalog = "TestCatalog"

Dim strQuery As String

If TextBox1.Text <> "" Then

DataGrid1.Visible = True

strQuery = "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where FREETEXT('" & TextBox1.Text & "')"

Dim connString As String = "Provider=MSIDXS.1;Integrated Security ..='';Data Source='" & strCatalog & "'"

Dim cn As New System.Data.OleDb.OleDbConnection(connString)

Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)

Dim testDataSet As New DataSet()

cmd.Fill(testDataSet)



Dim source As New DataView(testDataSet.Tables(0))

DataGrid1.DataSource = source

DataGrid1.DataBind()

Else

DataGrid1.Visible = False

End If

End Sub

End Class



The result I am getting in datagrid is in plain text

How do I make datagrid to show url in clickable format?
Or how can I make datagrid item in hyperlink format?

[scorpion53061]

Alvin,

"Alvin Bruney" <vapor at steaming post office> wrote in message
news:OpHg%23$J1DHA.1272@TK2MSFTNGP12.phx.gbl...
search this newsgroup for today. i've posted code to add a hyperlink.

Please repost it. I must have missed it. I am in the ADO.NET ng.

[Alvin Bruney]

itemcreated or itemdatabound event handler

if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem)

{

//column 1 is an itemtemplate column

Label lbl = (Label)e.Item.FindControl("Dig");

if(lbl != null)

lbl.Text = "<input type=radio name='samegroup' value=" +
e.Item.Cells[1].Text + ">";

}


--
Regards,
Alvin Bruney
Got tidbits? Get it here...
[url]http://tinyurl.com/2bz4t[/url]
"scorpion53061" <Its the end of the world as we know [email]it@here.com[/email]> wrote in
message news:OCkrcCK1DHA.1740@TK2MSFTNGP12.phx.gbl...

> Alvin,
>
> "Alvin Bruney" <vapor at steaming post office> wrote in message
> news:OpHg%23$J1DHA.1272@TK2MSFTNGP12.phx.gbl...
> search this newsgroup for today. i've posted code to add a hyperlink.
>
> Please repost it. I must have missed it. I am in the ADO.NET ng.
>
>

[Mike]

I need to allow the user to double click on a row within the grid and when
that happens I need to get detailed information on that row and display this
informatin below the grid on the same page.

example:

header1 header2 header3
-----------------------------------------------------
2 scooby 555-1212 -- when
this is double clicked the following needs to appear.

---------footer---------------------------------

Information on Scooby;

Name: textbox
Address: textbox
Phone: textbox

and this information can be updateable. Is there any examples online showing
this in C#?

[Ken Cox [Microsoft MVP]]

Hi Mike,

It sounds a bit like a hierarchical grid. In that case, you might want to
look here:

[url]http://www.denisbauer.com/ASPNETControls/HierarGrid.aspx[/url]

"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:e3kG10bQEHA.3348@TK2MSFTNGP09.phx.gbl...

>I need to allow the user to double click on a row within the grid and when
> that happens I need to get detailed information on that row and display
> this
> informatin below the grid on the same page.
>
> example:
>
> header1 header2 header3
> -----------------------------------------------------
> 2 scooby 555-1212 -- when
> this is double clicked the following needs to appear.
>
> ---------footer---------------------------------
>
> Information on Scooby;
>
> Name: textbox
> Address: textbox
> Phone: textbox
>
> and this information can be updateable. Is there any examples online
> showing
> this in C#?
>
>
>

[Mike]

on my web app, i need to have a input box to allow the user to set the
number
of rows they see in the grid,, Now i'm going against oracle so how can i do
that?

example:
when the page loads I pull all rows back, but if the user only wants to see
10 or 5 I can I make that change to the grid and only show 10 or 5?

[Ken Cox [Microsoft MVP]]

You can set the PageSize property if you are using paging. Is that what you
meant?

If so, take the input from the user and use that to set the number of rows
per page.

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclasspagesizeto pic.asp[/url]

"Mike" <me@me.com> wrote in message
news:OHlpG99gEHA.3944@tk2msftngp13.phx.gbl...

> on my web app, i need to have a input box to allow the user to set the
> number
> of rows they see in the grid,, Now i'm going against oracle so how can i
> do
> that?
>
> example:
> when the page loads I pull all rows back, but if the user only wants to
> see
> 10 or 5 I can I make that change to the grid and only show 10 or 5?
>
>

[John McClamrock]

What exactly is a DataGrid?

John

[Ken Cox [Microsoft MVP]]

Hi John,

It is an ASP.NET server-side control that renders in the browser as an HTML
table full of data. Click the button here and you'll see a datagrid rendered
as HTML:

[url]http://www.dotnetjunkies.com/quickstart/aspplus/samples/webforms/intro/VB/Intro8.aspx[/url]


"John McClamrock" <ehbryan@hotmail.com> wrote in message
news:eP0ls9jCFHA.2380@tk2msftngp13.phx.gbl...

> What exactly is a DataGrid?
>
> John
>

[John McClamrock]

Is there a way to show the ASP.NET VB Source for it so I can study it?

--

John

[Ken Cox [Microsoft MVP]]

Sure!

[url]http://www.dotnetjunkies.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/intro/Intro8.src[/url]

[url]http://www.asp.net/Tutorials/quickstart.aspx[/url]


"John McClamrock" <ehbryan@hotmail.com> wrote in message
news:uMa7sElCFHA.4004@tk2msftngp13.phx.gbl...

> Is there a way to show the ASP.NET VB Source for it so I can study it?
>
> --
>
> John
>

[ajm4961]

Hi
I do have a similar thing working but I dont use the buttons, I use an edit
column, like this . . . .

<asp:DataGrid id="MyDataGrid"
Autogeneratecolumns=false
OnCancelCommand="Grid1_cancel"
OnEditCommand="Grid1_edit"
OnUpdateCommand="Grid1_update"
DataKeyField="Associationid"

Runat="Server">
<columns>

<asp:EditCommandColumn
edittext="Edit"
Canceltext = "Cancel"
UpdateText = "OK"
HeaderText="Click To Edit"
/>

cheers
ajm

[shaggydagy]

hi: I'm using a datagrid populated from a php file through loadvars, this
datagrid is a list of news and the columns are: -date -title -I also have the
newsID, but i dont want to show this one, I just want it for sending the
parameter on click. so far this works, the thing is that when the user clicks
on one row I want to send the newsID -using load vars- and show the news detail
returned by loadvars in some text fields I have on stage. this is the first
time I use the data grid so I'm kinda stuk in here, I don't know how to
interact with the rows the user clicks on or what actions to use. the behavior
I expect is when an user clicks a row, the row call the loadVars.load method
sending the newsID from the clicked row as a parameter. got it? any comments
will be welcome. thanx

[thedanster]

I have done something similar. What I did was use the dataGrid's onChange
event to trigger the update of the text field values. Something like this:
gridHandler = new Object(); gridHandler.change = function(event) { // this is
the stuff you want to have happen. // the following line is gathering the
record from the grids dataprovider, you can reference that
gridName.dataprovider instead of //a recordSet. I do not know exactly how you
have things laid out. Also, the type of textfield (InputText,textarea, dynamic
TextBox may require you to assign the field value to a different property.
textField.text = recordSetName.getItemat(gridName.selectedIndex).fi eldName; }
gridName.addEventListener('change',gridHandler); I assume you are using MX2004
pro. I do not know if it matters. My capitalization is probably not correct
for some of the methods or properties. Good luck DAN

[shaggydagy]

I have to adpt some things but thanx for your comment it really helped. Now I'm on my way, thanx again.

[dollar]

i don't know what I changed in my datagrid, it can't trigger
the item_command event now, pls help.



--
dollar
------------------------------------------------------------------------
Posted via [url]http://www.codecomments.com[/url]
------------------------------------------------------------------------