ASP.NET

21-Aug-06 18:00

in code behind pages, and inside ItemDataBound , how i get the data if the datagrid mode is edit mode, that means..

dim a as string

a = xxxxxxxxx

xxxxxxx is the coding to reterive the data from the selected row inside datagrid in edit mode ?

how i write tis xxxxxxxxx code ?

Best regards,

Chee ken

postmaster@programmingknowledge.com

postmaster@programmingknowledge.com21-Aug-06 18:06

21-Aug-06 18:06

   Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand <br />
<br />
        Dim ID As Int32 <br />
<br />
        ID = Convert.ToInt32(e.Item.Cells(0).Text)

There is an example at:
http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

_AK_21-Aug-06 18:07

21-Aug-06 18:07

If you want to check the edit mode then you can put this check for that;
if(e.Item.ItemType==ListItemType.EditItem)

Best Regards,
Apurva Kaushal

cheeken2u21-Aug-06 20:22

21-Aug-06 20:22

if(e.Item.ItemType==ListItemType.EditItem)

this code put inside ItemDataBound or Editcommand ?

Best regards,

Chee ken

_AK_21-Aug-06 20:25

21-Aug-06 20:25

This has to be put in the OnItemDataBound. So this code(under this condition) will get executed for the which is in edit mode.

Best Regards,
Apurva Kaushal

cheeken2u22-Aug-06 17:22

22-Aug-06 17:22

Thanks for your help.

Best regards,

Chee ken

_AK_22-Aug-06 18:14

Anyone who knows how to read error?

22-Aug-06 18:14

always welcome.. Smile | :)

Best Regards,
Apurva Kaushal

blurMember21-Aug-06 17:33

blurMember

21-Aug-06 17:33

I was trying to export my gridview to excel.

    protected void btnExcel_Click1(object sender, EventArgs e)<br />
    {<br />
        Response.Clear();<br />
        Response.Buffer = true;<br />
        Response.ContentType = "application/vnd.xls";<br />
        Response.Charset = "";<br />
<br />
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();<br />
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);<br />
<br />
        dgDisplay.RenderControl(oHtmlTextWriter);<br />
        Response.Write(oStringWriter.ToString());<br />
        Response.End();<br />
     <br />
    }<br />
public override void VerifyRenderingInServerForm(Control control)<br />
    {<br />
        //base.VerifyRenderingInServerForm(control);<br />
    }<br />
<br />

Can someone explain to me what this error means?

RegisterForEventValidation can only be called during Render();

thanks in advance. Much appreciated.

Re: Anyone who knows how to read error?

Suresh Pirsquare22-Aug-06 0:35

Suresh Pirsquare

22-Aug-06 0:35

The Following link may help u out of your probs

http://geekswithblogs.net/azamsharp/archive/2006/01/09/65368.aspx[^] Smile | :)

Thanks & Regards,
Suresh Dayma

Re: Anyone who knows how to read error?

blurMember22-Aug-06 7:57

blurMember

22-Aug-06 7:57

thanks for the above link.

thanks in advance. Much appreciated.

How to convert datagrid'data into dataset ?

cheeken2u21-Aug-06 17:25

Re: How to convert datagrid'data into dataset ?

21-Aug-06 17:25

Anybody know how to save data from datagrid into dataset?

Best regards,

Chee ken

Navi1521-Aug-06 23:05

Navi15

21-Aug-06 23:05

Check out this link

http://www.devx.com/tips/Tip/28651

hope it will help u.

Navi

Event firing

kalyanPaladugu21-Aug-06 13:15

kalyanPaladugu

21-Aug-06 13:15

I have a button on a ASP.NET page. I have some code in the page_load event.
Every time i click the button first the page_load event is firing first and then
the button_click event. How can i make the button_click event to fire first and
later the page_load event.

Thanks
Kal

Re: Event firing

enjoycrack21-Aug-06 14:03

enjoycrack

21-Aug-06 14:03

hi there,

I think you mean that you want the code in block Page_Load not execute when the button is clicked, right? if so, you just put the code into block if(!Page.IsPostBack), it'll not execute when user clicks the button

Hope this helps...

<< >>

ASP.Net Configuration - website administration tool external access

cdengler21-Aug-06 11:45

cdengler

21-Aug-06 11:45

I'm sure this has been brought up before, but I just can't seem to locate the answer.

I have an internal application that needs to allow access to an admin to manage roles and users on the ASP.Net 2 Website Administration Tool that we all love so much Sigh | :sigh:

My question is, is there a way to provide access to this "site" area to someone who is NOT on the local server?

Any help is much appreciated... thanks

Datagrid SQL Select Parameter Problem [modified]

Soot21-Aug-06 9:55

Soot

21-Aug-06 9:55

Ok first, I'll outline my project. It is a web application made to search and display records of archived technical documents. What I have right now is a page that uses datagrids (via drag and drop from Visual Studio 2005) to display columns of data from my SQL Test server.

What I need now is a way to create a simple form text box and create and pass a variable to the SELECT statement within the datagrids. All my attempts at this thus far, using both ASP and C# and MSDN knowledgebase, have ended in frustration.

Here is the code of the datagrid:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="OVERVIEW" HeaderText=" " SortExpression="OVERVIEW" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="
<%ConnectionStrings:trdConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:trdConnectionString2.ProviderName %>"
SelectCommand="SELECT [OVERVIEW] FROM [SUDS_TRD] WHERE [IDENT]='1'">
</asp:SqlDataSource>

What I need to do is where it says [IDENT]='1', is have that "1" be a parameter passed from an HTML form, perhaps looking like this WHERE [IDENT]='"% strIDENT %"', yet I do not know how to pass a parameter from an HTML form into that SELECT statement. Any help would be great as this is a problem holding up my project.

To reiterate, I need to:
A. create an html form text box
B. pass that textbox as a variable
C. place that variable into the SELECT statement for the ASP datagrid.

Any help would be great, example code, whatever it takes; the simpler the better =) Please just don't send me to MSDN's Datagrid Knowledge Base page as 1/2 the stuff there doesn't even work =[.

Thanks for any help in advance!

Jesse Myse
jessemyer06@aol.com

-- modified at 15:55 Monday 21st August, 2006

Re: Datagrid SQL Select Parameter Problem

Ramasubramaniam21-Aug-06 10:42

Ramasubramaniam

21-Aug-06 10:42

Hi,

You can not pass HTML text box and construct an query dynamically. You should go for server side coding. Imagine there is a button control on click of the control you have to construct the query dynamically based on the values entered on the textbox. So onclick event of the button you can construct the query like,

button1_onclick()
{
string strQuery = "";
strQuery = "Select field1, field2 from table1 where field1 like %'" + textbox1.text.trim() + "%'";
then execute the query with adaptor or something....
}

Ram

How to handle two checkBox in gridview ?

Hussein Madani Ghomi21-Aug-06 9:43

Hussein Madani Ghomi

21-Aug-06 9:43

i have a problem , i want handle two checkbox in tow column of gridview as when checked a checkbox then other checkbox enable=false , but i don`t know Cry | :((

please send me a sample .by ASP.NET 2.0

Best Regards
Hussein Madani Ghomi
+98-912-5577-832

Re: How to handle two checkBox in gridview ?

Grapes-R-Fun21-Aug-06 15:36

Grapes-R-Fun

21-Aug-06 15:36

Hussein, what's your email address?

Nila Fridley

Re: How to handle two checkBox in gridview ?

Hussein Madani Ghomi22-Aug-06 3:11

Hussein Madani Ghomi

22-Aug-06 3:11

Hi
Dear Nila
My email : H_Madani_gh@yahoo.com

Best Regards
Hussein Madani Ghomi
+98-912-5577-832

Re: How to handle two checkBox in gridview ?

_AK_21-Aug-06 20:10