ASP.NET

Re: Paging in Datalist....

10-Aug-06 20:25

Hi!

How can we achieving Paging in DataList?

Send me a sample coding....

T.Prabu

_AK_10-Aug-06 20:28

Pass the value from one page to another page.....

10-Aug-06 20:28

You can use custom paging in datalist.

Best Regards,
Apurva Kaushal

Prabs frm PGP10-Aug-06 20:23

Re: Pass the value from one page to another page.....

10-Aug-06 20:23

Hi!

I want to pass the value from one page to another page:

In my maker page i used datagrid and i hv to take that dg's row value (through., DataRowView) i transfered that value to nxt page:

Here in ItemDataBound event i wrote the coding for get the values to the DG's Row..

here i retrieve the value frm the DAtaRowView in a variable in a name as temp.

In ItemCommand Event i wroth that Response.Redirect("Models.aspx")

Now this temp value also transfer to that Models Page.., I tried the QueryString

like: Response.Redirect("Makers1.aspx?val="+temp); but its in Item Command event., but
that value in ItemDataBound Command so., It assigns only null value to that one..,

Here i can't use session also...

How can we solve this one...?

T.Prabu

T.Prabu

_AK_10-Aug-06 20:27

Re: Pass the value from one page to another page.....

10-Aug-06 20:27

You can use command argument property to first set the value and then in itemcommand event you can access that value and use it.

Best Regards,
Apurva Kaushal

Prabs frm PGP10-Aug-06 20:45

Re: Pass the value from one page to another page.....

10-Aug-06 20:45

Can you let me know abt that command argument?...

_AK_10-Aug-06 20:50

Re: Pass the value from one page to another page.....

10-Aug-06 20:50

suppose you are having an image button whose click event you are trying to capture in itemcommand event, then that image button will be having a property called command argument which you can set in the item bound event of the datagrid. And in itemcommand event you can access that command argument property, it will give you the corresponding value of that row.

Best Regards,
Apurva Kaushal

Prabs frm PGP10-Aug-06 21:08

Re: Pass the value from one page to another page.....

10-Aug-06 21:08

Hi Apurva.,

I am newer. i want toretrieve that imagebutton's imageurl wheich is in the datagrid.

I can retrieve that value only in databound event using datarowview...

I want to pass this value to next page...

In item command event only i can use response.redirect... with the query string..

I tried as u say, commandargument in itemcommand event it shows only the null value..,

If possible send me the sample coding...,

And also for the Paging in datalist also...

Thanks & Regards!..

T.Prabu

_AK_10-Aug-06 21:24

Re: Pass the value from one page to another page.....

10-Aug-06 21:24

suppose you are having an image button in a template column of datagrid, then this code you have to put in your onitembound event:

<br />
ImageButton ii = (ImageButton)e.Item.FindControl("imgbtn");<br />
				ii.CommandArgument=drv[0].ToString();

here drv[0] is datarowview and the value which you need to put.

And in itemcommand event you can retrieve that value like this:

string str = e.CommandArgument.ToString();

Prabs frm PGP wrote:
And also for the Paging in datalist also...

For custom paging you can get so much of article on net. you just need to search through google.

Best Regards,
Apurva Kaushal

Prabs frm PGP10-Aug-06 22:39

Re: Pass the value from one page to another page.....

10-Aug-06 22:39

Hi!

Thanks Apurva...

I got the solution with the help of u..

Thanks.,
Bye...,
T.Prabu

_AK_10-Aug-06 22:49

display hyperlink depends on user validatation

10-Aug-06 22:49

always welcome.... Smile | :)

Best Regards,
Apurva Kaushal

kuwl_mark10-Aug-06 20:15

kuwl_mark

10-Aug-06 20:15

i am creating a project in which i am creating a navigation links .which is use to redirect from page to page.
I want to create navigation links such a way that links should appear based on user rights.
For example if a person is login as administrator he will see all 30 links
If he is user he will see only 4 links. I am fetching the urls from database

Pls help me it is urgent

Re: display hyperlink depends on user validatation

_AK_10-Aug-06 20:26

Re: display hyperlink depends on user validatation

10-Aug-06 20:26

You can dynamically generate hyperlink control and then display it, depending upon the count from the database.

Best Regards,
Apurva Kaushal

varun_khanna1710-Aug-06 21:36

varun_khanna17

10-Aug-06 21:36

U can put these Hyperlinks in rows or column dependinf on u...
then in javascript what u can do is check whether user is admin or not..
write these Code:

<%if(session("user")="Admin" %>
t1.style.display='block';t2.style.display='block';
<%end if%>

<%if(session("user")="NOTADMIN" %>
t1.style.display='none';t2.style.display='none';
<%end if%>

--t1,t2 here stands for ids of row1,row2 respectively
--Block will display the row and none will not display that row
--this way u can do for n number of rows

Sorting DataGrid on Client Side

248912810-Aug-06 19:50

2489128

10-Aug-06 19:50

Hi, How to Sort Sort a DataGrid on Client Side.

Re: Sorting DataGrid on Client Side

minhpc_bk10-Aug-06 23:34

minhpc_bk

10-Aug-06 23:34

Ask this girl[^] for the sample code.

How to access a sever control from javascript??

kvPriya10-Aug-06 19:17

kvPriya

10-Aug-06 19:17

Hi,
I have an aspx page which refers to a master page. In the child page, I have to refer and retrieve the text of a server side textbox of the same page.And this text should be displayed in the browser's status bar.To display the text in status bar, I can use window.status in javascript. But, how can we access that server control's value from script??
Any suggstions....Please welcome....Thanq

-Priya

Re: How to access a sever control from javascript??

ake_krakbar10-Aug-06 21:32

ake_krakbar

10-Aug-06 21:32

I usually solve this by typing out the value from the server control to the page to a javascript variable that i can use by the script later. Typically:

myLiteral.Text = ""
myLiteral.Text += "var myVar=" + theValue;
myLiteral.Text += ""
Controls.Add(myLiteral)

Then use the variable myVar on the client!

Data type mismatch in criteria expression

frossie10-Aug-06 17:42

10-Aug-06 17:42

i keep having runtime errors everytime i try to update my database in the datalist. Can someone pls help me rectify them?

aspx. file
this is in the EditItemTemplate of the datalist control.

<br />
<EditItemTemplate><br />
                <table width="100%" height="100%" cellpadding="1" border="1"><br />
                    <tr><br />
                        <td style="width: 54px"><br />
                        <%#DataBinder.Eval(Container.DataItem, "ID")%><br />
                        </td><br />
                        <td style="width: 300px"><br />
                        <%#DataBinder.Eval(Container.DataItem, "checklist_Item")%><br />
                        </td><br />
                        <td style="width: 230px"><br />
                            <asp:TextBox ID="txtEventDate" text='<%#DataBinder.Eval(Container.DataItem, "date_Completed")%>' runat="server"></asp:TextBox</td><br />
                        <td style="width: 160px"><br />
                            <asp:TextBox ID="txtEventTrigger" text='<%#DataBinder.Eval(Container.DataItem, "date_Trigger")%>' runat="server"></asp:TextBox><br />
                            </td><br />
                        <td style="width: 100px"><br />
                <asp:Button ID="btnUpdate" CommandName="Update" Text="Update" runat="server" /></td><br />
                            </tr><br />
                </table><br />
            </EditItemTemplate><br />

aspx.vb file

Sub MyDataList_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles MyDataList.UpdateCommand<br />
            Dim tbox As TextBox<br />
            Dim ID As String<br />
            'Dim txtEventDate, txtEventTrigger As Date<br />
            'Dim ID, txtEventDate, txtEventTrigger As String<br />
            Dim txtEventDate, txtEventTrigger<br />
<br />
            '---retrieves the key for the row---<br />
            ID = MyDataList.DataKeys(e.Item.ItemIndex)<br />
            'MsgBox("1")<br />
<br />
            '---find the textbox control containing the title<br />
            tbox = CType(e.Item.FindControl("txtEventDate"), TextBox)<br />
            txtEventDate = tbox.Text<br />
            'MsgBox("2")<br />
<br />
            '---find the textbox control containing the price<br />
            tbox = CType(e.Item.FindControl("txtEventTrigger"), TextBox)<br />
            txtEventTrigger = tbox.Text<br />
            'MsgBox("3")<br />
<br />
            '---updates the database---<br />
            Dim sql As String = "UPDATE programs SET date_Completed='" + txtEventDate + "' , date_Trigger='" + txtEventTrigger + "' WHERE ID='" + ID + "'"<br />
            Dim comm As New OleDbCommand(sql, objConn)<br />
            'MsgBox("4")<br />
<br />
            objConn.Open()<br />
            'MsgBox("5")<br />
            comm.ExecuteNonQuery()<br />
            MsgBox("6")<br />
            objConn.Close()<br />
<br />
            MyDataList.EditItemIndex = -1<br />
            'MyDataList.DataBind()<br />
            LoadData()<br />
<br />
<br />
        End Sub

The error as displayed:

Data type mismatch in criteria expression. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.

Source Error: 


Line 76:             objConn.Open()
Line 77:             'MsgBox("5")
<code>Line 78:             comm.ExecuteNonQuery()</code>
Line 79:             MsgBox("6")
Line 80:             objConn.Close()
 
Stack Trace: 


[OleDbException (0x80040e07): Data type mismatch in criteria expression.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
   System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
   Tracking.Default1.MyDataList_UpdateCommand(Object source, DataListCommandEventArgs e) in C:\Documents and Settings\username\My Documents\Visual Studio 2005\Websites\WebSite2\Default.aspx.vb:78
   System.Web.UI.WebControls.DataListCommandEventHandler.Invoke(Object source, DataListCommandEventArgs e) +0
   System.Web.UI.WebControls.DataList.OnUpdateCommand(DataListCommandEventArgs e) +75
   System.Web.UI.WebControls.DataList.OnBubbleEvent(Object source, EventArgs e) +228
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
   System.Web.UI.WebControls.DataListItem.OnBubbleEvent(Object source, EventArgs e) +117
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +85
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4918

frossie

manowj10-Aug-06 18:57

manowj

10-Aug-06 18:57

Hi,

The Error might be [Datatype in the database must be numeric and you are assigning a string to it], If your database is ms-access use "#" for the date columns.

frossie10-Aug-06 20:08

10-Aug-06 20:08

can you show me an example code to put in access or the codefile?
becos i don really get what u say.

frossie

_AK_10-Aug-06 20:29

10-Aug-06 20:29

You can check the query which you are generating, check that query by executing it in backend first.

Best Regards,
Apurva Kaushal

manowj10-Aug-06 20:37

manowj

10-Aug-06 20:37

Hi,

check this out,

(1)
"UPDATE programs SET date_Completed=#" + txtEventDate + "# , date_Trigger=#" + txtEventTrigger + "# WHERE ID='" + ID + "'"

(2)
"UPDATE programs SET date_Completed=#" + txtEventDate + "# , date_Trigger=#" + txtEventTrigger + "# WHERE ID=" + ID

for (1)
provided [date_completed is date, date_trigger is date and ID is string] in database

for (2)
provided [date_completed is date, date_trigger is date and ID is numeric] in database

display this query string in ur browser and copy paste in database, run it out and check.

frossie10-Aug-06 21:03

Object reference not set to an instance of an object

10-Aug-06 21:03

ok thanks alot.

it finally solved that problem.

frossie

frossie10-Aug-06 22:08