dude..then its the wrong forum for you...choose the right forum to post your query so that you will get an answer to it

Pradip Kishore

you can use a java script calander function and call it in the "onfocus" event of the textbox while you are in edit mode of the gridview.. For java script calender function you can look at This[^]">

Pradip Kishore

modified on Friday, February 6, 2009 6:13 AM

Hi All, I have a table (tblEmp) from which I am exporting data to a excel sheet.The table contains 5 fields(empid,empname,age,address,accountno) Issue: Now I want that when ever I export the data from tblEmp table , the accountno field should come as **** in the excel sheet Please let me know how can I do this by vb.net. Thanks in advance.

Pradip Kishore

Hi Francis, Thanks a lot for the quick response. I have a requirement that when even I checked on certain data items in the gridview(GV) then the color must be changed (which i did),but now the problem is that when I click on any of the coloumn headers,the colors of the items which I had checked got vanished and the data is shown in the GV as fresh data as if no items have been checked. Please let me know how to prevent the color change when somebody clicks on any of the coloumn headers of the GV..? Thanks in advance.

Pradip Kishore

Hi, I have a datagridview control in which I populate data from a data table.When I click on the coloumn header of the gridview control,then the data which are displayed are sorted in the reverse order on which it was originally diaplayed. Issue:Now I want that the data should not be sorted when ever I click on any of the coloumn headers of the data gridview i.e I want all the coloumn headers of the gridview controls should be read only irrespective of clicking on it.When I will click on the gridview column header no actions should not be there in th gridview. Please help me out in this issue.Its very urgent. Thanks in advance.

Pradip Kishore

Hi, I have a gridview control in which i have added two comboboxes(cmbCity,cmbPincode) at the runtime.I populate the cmbCity combobox from the database at the form load event. Now my requirement is that when ever i select an item from cmbCity ,the relevent picode should be automatically populated into cmbPincode. Please help me out how to handle the cmbCity_SelectedIndexchanged event inside a gridview control.. I am using winforms.(vb.net & sql server 2000)

Pradip Kishore

Hi, I have a gridview control in which i have added two comboboxes(cmbCity,cmbPincode) at the runtime.I populate the cmbCity combobox from the database at the form load event. Now my requirement is that when ever i select an item from cmbCity ,the relevent picode should be automatically populated into cmbPincode. Please help me out how to handle the cmbCity_SelectedIndexchanged event inside a gridview control..

Pradip kishore

Hi Thanks for your answr. But my requirement is that when the page will be loaded then the default selected item in the combobox should be "all" i added "all" as combobox.iteams.add("all") now i want to make "all" as my default selected item of the combobox. Please revert back soon.

i m pradip kishore from india,working in vb.net & asp.net

Hi, I am retrieving some values from database & populating them in a combobox.Prior to populating the values from the combobox,i manually added an item as "All" and i want that this item should be the default selected item(with index -1) when the values will be populated from the database into the combobox. Can anybody help me how to do this..? Thanks in advance

i m Pradip Kishore

Hi thanks for your response.. but can you show me some sample code or any links by which i can be able to do this..? thanks in advance..

pradip kishore

hi IS there any way to optimize a stored procedure for quick data retrival.. please help me thanks in advance..

pradip kishore

hi thanks for your response IS there any way to optimize a stored procedure for quick data retrival.. please help me thanks in advance..

i m pradip kishore

hi all i am having a stored procedure in my database which will take 2 parameters and return a resultset which i want to display in a crystal report.when i am executing the store proc. alone with the paramaters in the query analyser of sql server 2000,it is taking around 2.5 min.but when i pass the parameters from a vb.net page page,it z showing an error:{"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."} please help me out to solve this problm.. thanks in advance

i am Pradip Kishore

Hi i have used forms authentication for securing some of the web pages of my site.i want to grant admin previledge to one of the user so that he will be only having access to admin.aspx...for that i have modified my web.config as follows: ..location path="admin.aspx".. ..system.web.. ..authorization.. ..allow users="admin".. ..deny users="*".. ...authorization.. ..systeb.web.. can anybody help me how can i configure only one user to have access to admin.aspx...since my site is forms authenticated..now any user can access to admin.aspx...so how can i configure admin status for a particular user.. its urgent.. thanks in advance..

Pradip Kishore

hi all i want to know how to create dynamic links/urls like.. http://www.abc.com/demo/server01/Tab.asp?Tab=2&PROJECT\_ID=75" i want to know how to create the urls from.. "tab.asp?tab=2&project_id=75 " how to create these id values automatically and how to access them when i want to hyperlink them to another page... for ex: i have table like: name profession skills -------------------------------------- pradip software .net john telecom cdma ... .... ..... i want to make my each entry of name,profession,skills to be hyperlinked so that when ever i will click on any item...it will generate a link like the above mentioned and accordingly navigate to the detailed page... its urgent..please help me.. thanks in advance..

pradip kishore

Hi i have used forms authentication for securing some of the web pages of my site.i want to grant admin previledge to one of the user so that he will be only having access to admin.aspx...for that i have modified my web.config as follows: ..location path="admin.aspx".. ..system.web.. ..authorization.. ..allow users="admin".. ..deny users="*".. ...authorization.. ..systeb.web.. can anybody help me how can i configure only one user to have access to admin.aspx...since my site is forms authenticated..now any user can access to admin.aspx...so how can i configure admin status for a particular user.. its urgent.. thanks in advance..

pradip kishore

hi when ever i am using forms authentication to secure some particular pages of my site using forms authentication..i only mentioned the urls of those page which i want to be secured by structuring the web.config file as : location path="account.aspx" system.web :/authorization/ /deny users="?" / /authorization/ /system.web/ /localpath/ similarly i did for few pages of my site which i want to secure..but when i open other remaining pages..they are also being secured automatically(which i dont want..).....please help me to fix this problem.. its urgent.. thanks in advance

pradip kishore

from where would i get the authenticate form..is it built in or i have to design one..if built in..will you please tell me how to incorporate it into my project..??? please reply back soon thanks in advance..

pradip kishore

hi novice thanks for your vital support do i have to use the forms authentication..or simple i set the cookie after the validation of the user credentials in the login form..? if i dont use the forms authentication,then how i can make the user to sign out while pressing sign out button.. please replay back soon.. thanks in advance

pradip kishore

hi thanks for your response do you mean that i have to add as many location path in the web.config file as the no of secure pages i have... can you please show me how to write it for 2 web pages(account.aspx,transaction.aspx) in the web.config file thanks in advance

i m pradip kishore from india,working in vb.net & asp.net