|
Hi all,
I have a dataset having 1000 records and I want to bind the gridview with the dataset with only 10 records at a time. suppose I want to bind recordno-20 to recordno-30 then how to fetch a part of data from the dataset.I am using asp.net 2.0 with vb.net.I cannot change my main storedproc for this.
kindly provide some solutions for that....
Thanks and Regards
bikash 
|
|
|
|
|
why reinvent the wheel? GridView does this already. RTFM
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Here is a Solution
http://www.codeproject.com/KB/aspnet/Paging_without_a_Wizard.aspx[^]
Hope it Helps
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
DataTable have method Select() and try to use that method to filter your data with every 10 rows.
In your Next button filter data with next 10 rows based on last row of current result,in Previos button filter data with 10 previous rows based on current data result.
Or you can use Paging property of GridView
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
hi,
can we check if the selected value of the drop down list box has been changed?
scarface
|
|
|
|
|
yes when ever selected value of dropdown is changed the event selected index changed is called if ispost back property of dropdown list is set to true.
or you can check it on client side also without postback.
Government Dyal Singh College Lahore.
|
|
|
|
|
Here is an example of how it can be done. On the main page i have a label that reads the value of the dropdownlist and once the dropdownlist updates it re-populates the label.
the main page
<asp:label id="Label1" runat="server" xmlns:asp="#unknown"></asp:label><br />
<asp:dropdownlist id="DropDownList1" autopostback="true" runat="server" xmlns:asp="#unknown">
<asp:listitem value="Update1">Update1</asp:listitem>
<asp:listitem value="Update2">Update2</asp:listitem></asp:dropdownlist>
and the code behind
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = DropDownList1.SelectedValue;
}
This is a quick example just to point you in the right direction. Hope it helps.
|
|
|
|
|
Use selected IndexChange event of DropDownList
|
|
|
|
|
I have used ffmpeg.exe for convert .wmv or .avi file to .flv file. its working fine in local machine but when i upload it web server its not working. Also i don't get any error, my web server is windows server.
I think need some setting in IIS Server.
Please help me.
Thanks
Rajesh
|
|
|
|
|
vnsraj wrote: its working fine in local machine
How do you access it in local machine
vnsraj wrote: i upload it web server its not working.
be specific. what is not working? what are you doing. give better detail
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Hi,
I have an asp.net page in my application hose size is very large about 650k.I am using only one update panel and few server side controls.The size of .axd file is about 400k.How could i minimize the size of .axd file?
|
|
|
|
|
dev sheoran wrote: n my application hose size is very large about 650k.
What is hose Size?
dev sheoran wrote: The size of .axd file is about 400k.How could i minimize the size of .axd file?
Can you please confirm your requirement.
Thanks !
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Page take long time to load due to heavy files(mainly .axd files).I am using few server side controls(textBox,dropdownlist,button and updatePanel).
I want to minimize the size of .axd files which contribute most to the total size(including .css,.js,images).I have set the scriptMode to "release".
<scriptmanager id="scriptManager" runat="server" scriptmode="release">
But didn't gain much.
I also have set the debug="true" in web.config file.
<compilation debug="true">
|
|
|
|
|
Hi,
i want to create web service which sends alert mails after some interval of time. please, if any one can guide me in the same.
thanks in advance......
|
|
|
|
|
Ratnadeep_Raul wrote: i want to create web service which sends alert mails after some interval of time. please, if any one can guide me in the same.
If you want to send mail using Web Service then who will going to initiate the Web service call on time interval ?
You can thing about Windows Service which will call your service to send mail on time interval. You have to scheduled it / Or use TimerCallBack in winservice to Call web service method on specific time.
If web service is only for send mail then you can do it directly from Windows service also.
Let me know if any issue.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
can u please focus more on creating windows service.
|
|
|
|
|
Ratnadeep_Raul wrote: can u please focus more on creating windows service.
What do you mean ? 
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
hi everyone,
I am using asp.net using VB,
i want to initiate workflow instance programatically through my code, workflow is deployed in sharepoint portal. please, need this urgently......
thanks in advance...
modified on Thursday, March 26, 2009 6:25 AM
|
|
|
|
|
Hi!!
I have this error message:
"The object must implement IConvertible."
in this line
myAdapter.Fill(ds, "Table1");
my code is:
private void BindData()<br />
{<br />
<br />
try<br />
{<br />
SqlConnection myConnection = new SqlConnection(ConnectionString);<br />
SqlCommand myCommand = new SqlCommand("SP_S1", myConnection);<br />
myCommand.Parameters.Add("@ch1", SqlDbType.VarChar, 30).Value<br />
= DropDownList1.SelectedItem;<br />
<br />
myCommand.CommandType = CommandType.StoredProcedure;<br />
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);<br />
DataSet ds = new DataSet();<br />
<br />
myAdapter.Fill(ds, "Table1");<br />
myConnection.Open();<br />
myCommand.ExecuteNonQuery();<br />
GridView1.DataSource = ds;<br />
<br />
GridView1.DataBind();<br />
myConnection.Close();<br />
}<br />
catch (Exception)<br />
{ }<br />
<br />
<br />
}<br />
someone could help me?
Thanks.
|
|
|
|
|
try to make this changes
myCommand.Parameters.Add("@ch1", SqlDbType.VarChar, 30).Value<br />
= DropDownList1.SelectedValue;
Also try to search on google [^]like first.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thank you very much Blue_Boy it works
|
|
|
|
|
No problem.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi,
I am using a Master Page with Header, Footer, Left Column, Center (where Content Place Holder will be) and Right Column.
Now, my I have a SQL Database Driven Menu Control in the header like this:---
http://img403.imageshack.us/img403/8099/dddl.jpg[^]
Now it is working fine. The thing I want it, suppose the user clicks on "Forum".
The "Forum" related webpage will be loaded and corresponding page will be displayed in the center (content place holder section).
At this time, what should happen is that corresponding Menu Hierarchy should be displayed in the Left Column, something like this:---
http://img207.imageshack.us/img207/6738/dd2n.jpg
I am using C# in ASP.NET, please suggest some solution with code if possible...
thanx in advance
|
|
|
|
|
You want "Support" menu control on Left Column ,when user clicks header Forum ?
|
|
|
|
|
yes... same way if user clicks on ABC, ABC Menu should be there on the left hand side, and the new menu on left hand side should also offer URL features.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
