|
SqlConnection myConnection =
new SqlConnection(connstring );
SqlDataAdapter myAdapter =
new SqlDataAdapter(
"SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice FROM Products",
myConnection);
//Fill the DataSet
DataSet ds = new DataSet();
myAdapter.Fill(ds,"Products");
//DataBind the Repeater
// MyRepeater.DataSource = ds.Tables["Products"].DefaultView;
// MyRepeater.DataBind();
// Populate the repeater control with the Items DataSet
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = ds.Tables[0].DefaultView;
objPds.AllowPaging = true;
objPds.PageSize =10;
objPds.CurrentPageIndex = CurrentPage;
lblCurrentPage.Text = "Page: " + (CurrentPage + 1).ToString() + " of "
+ objPds.PageCount.ToString();
// Disable Prev or Next buttons if necessary
cmdPrev.Enabled = !objPds.IsFirstPage;
cmdNext.Enabled = !objPds.IsLastPage;
MyRepeater.DataSource=objPds;
MyRepeater.DataBind();
this is my code what is the use of( ds.Tables[0].DefaultView)this;
can u explain me??
regards
saravanan
|
|
|
|
|
I tmeans that the first table in the dataset is to be attached to the datasource of the control...DefaultView property returns a DataView you can use to sort, filter, and search a DataTable...
for eg... ds.Tables[0].DefaultView.RowFilter = "city='New York'"
Koushik
|
|
|
|
|
ds.Tables[0].DefaultView referes to opening view or customized view of the table that may include a filtered view, or a cursor position.
|
|
|
|
|
how to make a control visible and hidden when i click a button
thks
|
|
|
|
|
Hi
Takae look at it
<br />
document.getElementById(groupid).style.display=="none"<br />
document.getElementById(groupid).style.display="block";<br />
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
Hi,
To hide the Contorl use the following code in javascript:
document.getElementById("controlName").style.visibility = "hidden";
To Visible the control use the following code in javascript:
document.getElementById("controlName").style.visibility = "visible";
Regards,
Sandeep Kumar.V
|
|
|
|
|
i will attend an online exam of .net next week of a big company. It will be too difficult. How can pass and how can i prepare for that and can i get some sample questions.
Thanks
yesu
|
|
|
|
|
|
Can anyone give me a example? I want to remember Username and password, I don't know how to do?
Regard
Socheat
................
|
|
|
|
|
Hi,
Your question is not saying anything.
Not able to answer.
Try in google.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
I mean to i want to use cookie but I don't know
................
|
|
|
|
|
Where you want to remember your username and password ? In mind or somewhere else ? 
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
I mean that i use cookie to remember, but i don't know
................
|
|
|
|
|
My friend Cookies are not safe to use. If your application is not very concern about security then you can use cookies
it is very simple
<br />
Cookie["UserName"] = UserNameTextBox.Text;<br />
Cookie["Password"] = PasswordTextBox.Text;<br />
string username= Cookie["UserName"];<br />
string password= Cookie["Password"];<br />
<br />
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
So do you have any comment for me?
Thanks and Regards
Socheat
................
|
|
|
|
|
|
Claerly specify what you want to do? your question is not clear?
Regards,
Satips.
|
|
|
|
|
Am sorry, I mean that i want to use cookies, so please help me
................
|
|
|
|
|
I am doing the project of electronic PO form, and I got stuck. I am using wins 2000 server, front end ASP version 3.0, back end SQL database.
I have 2 questions to ask if anybody knows any of these, please let me know I really appreciate.
1/. To the PO form, do you know how to display PO # on
the form. This # usually shows up at the top right
corner of the form (6 digit # such as 026191). I set
up in database by using identity increment in PO #
column so that every time the user adds new orders,
the PO # will automatically increase.
To ASP file, how can I display the #?
2/. After the user fill out the form, they will submit to whoever approves the orders like a manager, it should be default. At the left bottom it shows the name of the person who orders. At the right bottom it shows the name of the approval person like manager. Do you know how to set up this?
If you have any ideas, please let me know.
Thank you very much for your help.
JoinCP
|
|
|
|
|
hi,
I have a Asp.Net application in which i have to print a page. the thing is that i have to print the next page by clicking the print button option in my previous page. pls give me a proper code using javascript print function.
Regards
Vijay.
|
|
|
|
|
So far what you have tried for this application.
What error it shows?
we are here to help you, not to do your work?
Regards,
Satips.
|
|
|
|
|
hi satips,
I have tried using onclick=window.print() in javascript for the button click in that particular window. it works fine. but the thing is i have to use the button in another form and when i click the button, the form which needs to be printed(ie.., the next form) should be printed. Can we pass the particular aspx pagename inside the window.print() function?. pls help me..
Regards
Vijay
|
|
|
|
|
Yes you can pass the particular aspx pagenmae inside the window.print() function.
But be careful in using the javascript. did u use the onblur function in your javascript.
Regards,
Satips.
|
|
|
|
|
Thanks for ur reply dude. but i did'nt use that onblur function. can u please tell me what's the purpose of that function and why do we use it?
Regards
Vijay.
|
|
|
|
|
how to take (postgres or orther database) Database backup,restore using asp.net codebehind(C#.net coding) save to client.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
