|
I have a grid and i want to do pagging, i have a form in which i am taking 3 inputs , ID , and 2 dates and showing records in that grid on the base of that ID and dates. for example my Qry returns 25 records and it shows in 3 pages when i click page number 2 all values remain same ,when i click on 3rd page it makes it page size to 5 but values remains same.
any help in this respect will be higly appreciated.
K Dastgir
|
|
|
|
|
|
i guess problem is due to parameters i am passing in Qry strin that every time parameters are passed again and results comes same instead of next page
on Page load i have this code
If Not Page.IsPostBack Then
bind SQL
end if
BindSQL()
'DSgrid is a data.dataset
'DB is a object of a class where i make connection
dsgrid = db.getRecords("SELECT attendence.EmpNo, Strength.Name,convert(varchar,Strength.DOJ,101)as DOJ,Strength.EmpStatusid,convert(varchar,attendence.Date,101)as DDate,convert(varchar,attendence.InTime,108) As InTime,convert(varchar,attendence.OutTime,108)As OutTime,attendence.Present AS Status,convert(varchar,(OutTime-InTime),108)As WorkedHrs FROM attendence INNER JOIN Strength ON attendence.EmpNo = Strength.EmpNo Where attendence.EmpNo ='" & cempid & "'AND attendence.Date >= '" & mfromdate & "' And attendence.Date <= '" & mtodate & "' Order by Date")
Dim mtcheck As Integer = dsgrid.Tables(0).Rows.Count()
If mtcheck = 0 Then
lblerror.Visible = True
Label3.Visible = False
Label5.Visible = False
lblerror.Text = "No Record Found"
Else
DG_CheckBox.DataSource = dsgrid
DG_CheckBox.DataBind()
End If
End Sub
Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub
K Dastgir
|
|
|
|
|
Didnt understood this function
Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub
I Think it should be like this
Sub DG_CheckBox_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub
Hope this helps u...
|
|
|
|
|
sorry it was my mistake it is DG)checkbox_pagechanger(...)
result is same
can it be the parameters passing in the qry making this problem
K Dastgir
|
|
|
|
|
I have Change your code please,
'Bind GridView Method
Public Sub BindGridView()
Dim oDS As New DataSet
strSql = "Your Query"
oDS = db.ExecuteDataSet(strSql)
DG_CheckBox.DataSource = oDS
DG_CheckBox.DataBind()
End Sub
'Return Dataset
Public Function ExecuteDataSet(ByVal strsql As String) As DataSet
Dim dtad As SqlDataAdapter
Dim dtst As DataSet
dtst = New DataSet
dtad = New SqlDataAdapter(strsql, GetConnection)
' GetConnection Get the sql connection
dtad.Fill(dtst)
CloseConnection()
Return dtst
End Function
Protected Sub DG_CheckBox_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles DG_CheckBox.PageIndexChanging
Try
DG_CheckBox.PageIndex = e.NewPageIndex()
BindGridView()
Catch ex As Exception
End Try
End Sub
U Can use EmptyDataText if your query doesnt returns any records.
eg: EmptyDataText = "No Record Found"
Else u can use your code also for showing error "No Record Found"
Hope this helps u...
|
|
|
|
|
Hi,
I am looking for a rental system like for videos or property, it must be open source. Does any one know of something like this?? It must preferably have a back office and must be integrated into a payment gateway, like Pay Pal for example. But the payment gateway is not required, I'm also looking for a rental calendar, where a user can look at what dates a property has been booked for.
Please can someone help me out.
Regards
ma se
|
|
|
|
|
<asp:dropdownlist id="ddlNames" runat="server">
<asp:listitem>item 1
<asp:listitem>item 2
<asp:listitem>Heer i want to allow user to add item 3
in the 3rd lstitem i want to allow user to edit his own item.
Savindra
-- modified at 8:18 Wednesday 9th May, 2007
|
|
|
|
|
savindra.bandi wrote: eer i want to allow user to add item 3
you can add item at run time
<br />
DropDownList1.Items.Add(new ListItem("text","Value"));<br />
savindra.bandi wrote: n the 3rd lstitem i want to allow user to edit his own item.
I think you can't do it using drop down list .
You can go with different approach by Adding one more TextBox
When user selects item from drop down list it will get into text where you can Edit it and After editing Add back to drop down list ...
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Tnx mr sandeep,
I will look wat I have...
|
|
|
|
|
Hi to all
i used Radiobuttonlist for displaying the two radio buttons Gross & Net
& also i am having a checkbox on form when i click this checkbox then
this radio buttons should be enabled. I make this radiogross disabled on page load event. but it is not getting enabled.
|
|
|
|
|
I guees u should not use Radion Button List...
|
|
|
|
|
You can use this code make AutoPostback property true of the Checkbox
Write this code in Page load
<br />
if (CheckBox1.Checked)<br />
{<br />
RadioButtonList1.Enabled = true;<br />
}<br />
else<br />
RadioButtonList1.Enabled = false;<br />
<br />
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Hi to all
<asp:RadioButtonList id="radioGross" runat="server" Width="193px" AutoPostBack="True" RepeatDirection="Horizontal"><br />
<asp:ListItem Value="1">Gross</asp:ListItem><br />
<asp:ListItem Value="2">Net</asp:ListItem><br />
</asp:RadioButtonList></TD><br />
& also i am having a checkbox on form when i click this checkbox then
this radio buttons should be enabled. I make this radiogross disabled.on page load event
|
|
|
|
|
Hi,
Anybody pls explain me why do we use a COM Component and Is COM Component very useful for .net application and if so pls explain me how it's useful for .net as i'm a newbie in .net and i'm eager to learn more about COM components as many users are highlighting more importance to COM component. pls help me with this issue...
Regards
Vijay.
|
|
|
|
|
vijay_83 wrote: why do we use a COM Component
COM componenets are very usefull if you want to use other OS applications in your own projects such as Excel,Winword , Internate Browser etc
vijay_83 wrote: Is COM Component very useful for .net application
Yes Actually DOT NET interanally uses COM+ technology COM is used to communicate with different languages.
Also COM has a major role in MSIDL Microsoft Interface defination Language
vijay_83 wrote: many users are highlighting more importance to COM component
No thats not true Using COM objects makes application bulky causing high memory usage.
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Thanks a lot sandeep, it was very useful for me. can u plz redirect me with some example links for how we use COM component with dotnet application?
Regards
Vijay.
|
|
|
|
|
How much changes is reflected in the new Asp.Net Ajax 1.0 than it's previous version Atlas. What are the new features and what changes. Does the previous version compatable with the new version ?
I seek ur suggestion positively.
Bijay Bhaskar Deo
Thanks & Regard
|
|
|
|
|
Asp.Net Ajax 1.0 is simple,good, easy to use yet powerful
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Thanks, But it isnot the answer i am seeking. Can u suggest me how much matching or difference it from Atlas
Bijay Bhaskar Deo
Thanks & Regard
|
|
|
|
|
No they are not compatible. When I upgraded I had to change all naming prefixes from
|
|
|
|
|
Asp.Net Ajax 1.0 was previously called Atlas. They are mostly the same, but as development went along some things were changed so the former is not compatible with the latter.
|
|
|
|
|
Could nay one tell me or give me clear idea about the difference between Abstract and virtual keyword.i searched google but i cuoldnt get satisfiable solution.this was an interview question
thanks in advance
|
|
|
|
|
Virtual keyword is used to declare methods which allow derived classes to override the implementation, as some default implementation is already specified in the base class method. Where as abstract keyword is used to declare methods with empty body and derived classes have to write the implementation. This is the basic difference.
Regards,
Prakash Kalakoti
|
|
|
|
|
Virtual Keyword :
<br />
The virtual keyword is used to modify a method, property, indexer or event declaration, and allow it to be overridden in a derived class. <br />
When a virtual method is invoked, the run-time type of the object is checked for an overriding member. The overriding member in the most derived class is called, which might be the original member, if no derived class has overridden the member.<br />
<br />
<br />
Abstaract Keyword
<br />
The abstract modifier can be used with classes, methods, properties, indexers, and events. Use the abstract modifier in a class declaration to indicate that a class is intended only to be a base class of other classes. Members marked as abstract, or included in an abstract class, must be implemented by classes that derive from the abstract class.<br />
Virtual properties behave like abstract methods, except for the differences in declaration and invocation syntax
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
