Hi, I am using Regular Expression control for Custom validation. I am trying to validate the logical Drive so My requirement is: First Character should be C-Z,Second Character":", and third Character "\" and Remaining character anything. i.e. "D:\....." I am using expression like "^([C-Zc-z]{1}:\)*" But its not validating my requiremt correctly. Any Correction will be great help. Thanks

Binod K. (Miles to go before I sleep)

Hi, In my Grid view i am using One radio button field to select record and one Check box field to indicate Status. I have give header of Radio button as "Select", i want this column should occupy minimum space. I tried all the option, but my problem didnt solved <asp:TemplateField HeaderText="Select" HeaderStyle-Width="10px" ControlStyle-Width="10px" ItemStyle-Width="10px" > <ItemTemplate> <input name="MyRadioButton" type="radio" value='<%# Eval("RejectId") %>' /> </ItemTemplate> </asp:TemplateField> Any one can help me. Thanks

Binod K. (Miles to go before I sleep)

Thanks Tamer, Now i am pretty much clear about it. I hosted my application on IIS, tested using URL from different machine, it creates folder on server machine only. Again thanks for your addition.

Binod K. (Miles to go before I sleep)

thanks for your thought Imran. As its web application, One will run the application through URL from local machine. There is no general point to use application from server. So where the folder will be created ? Does i require to map Server Path. Thanks

Binod K. (Miles to go before I sleep)

Hi, In my application i require to create a folder by customername, when any new customer is added. But the folder should be created on the Server not on workstation. if is use following code, where the folder will be created, C Drive of Local Machine or C drive of Web Server. Dim diCust As DirectoryInfo = Directory.CreateDirectory("C:/TestCustomer") I want to create on Server. Please Speak. Thanks

Binod K. (Miles to go before I sleep)

Hi, I have a grid view and in item template i have placed one Radio buton. Below the grid i have Edit and Delete button. On the click of these button i want to call java script validation, to check whether the any of the Radio button is selected or not. I dont want sever validation. Your reply with some valuable link or Code will be great help. Thanks

Binod K. (Miles to go before I sleep)

Hi, I have taken refrence of Microsoft Excel 11.0 Object Library in my project to export data in Excel. And included following Name spaces Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices.Marshal Now i have declared following variables. Dim objExcel As New Excel.Application When i execute the code it gives Access Denied Error. I check all the sharing and Security settings. Your comments will be highly appreciated. Thanks

Binod K. (Miles to go before I sleep)

Hi, I am using following code to generate report. I am using template for report header.It works fine. I want report should generate on individual sheet for each office. Currently Data of all sheet display on single sheet. How i will add sheet dynamically for each office. Private Sub CreateConsolidatedXLSheet(ByVal RptDate As String, ByVal endtime As String, ByVal conDate As String, ByRef ConsRptDS As DataSet) Dim rpttype As String = "SummaryRpt" Response.ClearContent() 'Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ".xls") Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ".xls") Response.ContentType = "application/vnd.ms-excel" Dim headerfile As String = Server.MapPath("Reports\Header_" + rpttype + ".html") Dim hreader As System.IO.StreamReader = New System.IO.StreamReader(headerfile) Dim headerdata As String = hreader.ReadToEnd() hreader.Close() Dim username As String = TTUser.GetDisplayNameFromDB(context.User.Identity.Name) headerdata = headerdata.Replace("##curdate##", Format(CDate(RptDate), "MMMM-dd,yyyy")) Response.Write(headerdata) Dim drow As DataRow Dim dcolum As DataColumn Dim numcols As New ArrayList() Dim slno As Int16 = 1 Dim LRow As String = ConsRptDS.Tables(0).Rows.Count.ToString For Each drow In ConsRptDS.Tables(0).Rows Response.Write("<tr>") Dim colix As Int16 For colix = 0 To drow.ItemArray.Length - 1 Dim strnum As String = "" If colix = 0 Then Response.Write("<td x:str>") Response.Write(drow(colix)) 'tz.GetPST(drow(colix))) Response.Write("</td>") Else Response.Write("<td x:num >") Response.Write(drow(colix)) Response.Write("</td>") End If Next Next Response.End() End Sub

Binod K. (Miles to go before I sleep)

Hi, Anyone could provide me solution. I have table like this Date | Status -------------------------------- 12/07/08 | 2 12/07/08 | 3 12/07/08 | 3 13/07/08 | 2 13/07/08 | 3 13/07/08 | 2 ---------------------------------- I want count of status on each day. For Clear understanding output should like this Date | Total 2 | Total 3 --------------------------------- 12/07/08 | 1 | 2 13/07/08 | 2 | 1 ---------------------------------- Thanks

Binod K. (Miles to go before I sleep)

Hi, I am switching from VS 2005 to VS 2008. Till now we are using VSS that come with Visual Studio 6.0 as a Version Control. I heard VS 2008 having inbuilt VSS feature, but after installing i did not get any option to create VSS project or connect to VSS Project. Any one having idea/tutorial/link, that would be great help. Thanks

Binod K. (Miles to go before I sleep)

Hi, I am running web application in debug mode. I have put some breakpoints but control doesnt stop at break points. I am using :---- Code Behind: Vb.Net Frame Work: 1.1 IE: 7.0; IIS: 5.1 I have gone through all the option of Virtual Directory Properties. Your suggestion will be highly appreciated. Thanks

Binod K. (Miles to go before I sleep)

Hi, I didnt come across any such method ? But you can acieve it using this code. ----------------------------------------------------------------------- string s = "select * from person"; DataSet ds = GetDataSet(s); GridView1.DataSource = ds; GridView1.DataBind(); Response.ContentType = "application/ms-excel"; Response.AddHeader("Content- Disposition", "inline;filename=ExcelFile.xls"); ------------------------------------------------------------------------ I am not convince with Christian Graus answer. Excel is optional at Server. But it is required at Client Machine. If it is not installed at Client Machine, user cannot display the excel file, but he can download.

Albert, you are correct, User id is just as visible as a username. But statement ?UserID=1234 or ?UserName='Albert' makes difference in visibility. For a end user its impossible to retrieve information from database. All the best for endeavour.

Hi, User Id is obviously prefered and secure choice, because username is understandable to others. But Whether its Id or Name both must be associated with Password and without the combination of both,access of applicaiton is not possible. But if i know the username,databasename, and tablename and i have the access of Database server, i can fetch the user information from database. Same is possible with user Id as well. But its diffcult to guess which Id belong to which User. Hope this will bring u decide ID or Name.

appu, you didnt mention here, how you populate listview data. I guess u must have used Dataset as data source for Name,Address,CountryID and StateID, and for this you must be sending some SQL Query. So in where clause you can call the function. Another way is u dont call the funciton, LEFT OOUTER JOIN the Seed Data table for Country and State in SQL Query and populate the list view. Hope now you got some more Idea.

You Can export the value in excel Sheet: You are required to keep textboxes and Combo boxes value in any container like dataset or array List .....and assign these source to GridView. For example: string s = "select * from person"; DataSet ds = GetDataSet(s); GridView1.DataSource = ds; GridView1.DataBind(); Response.ContentType = "application/ms-excel"; Response.AddHeader("Content-Disposition", "inline;filename=ExcelRPT.xls"); Good Luck !

Hi, I have a User Control thats having few Dropdown list on it. I am using this at one Web page. I registered the control using @Register on ASPX page. From the Code behind i am populating the dropdown list of User Control. But its not recognizing the dropdown list, and giving error at compile time. What I am missing apart from Registration of control. Thanks !

Problem Solved. Thanks.

Yes, Navaneeth. ViewState Property is True ( EnableViewState="True").

Hi, I am populating DropDownList using Data Source, and assigning Value and binding it using following code. ddlCustomer.DataSource = dsSeedData.Tables["Cust"]; ddlCustomer.DataTextField = dsSeedData.Tables["Cust"].Columns["CustomerName"].ColumnName.ToString(); ddlCustomer.DataValueField = dsSeedData.Tables["Cust"].Columns["Customer_ID"].ColumnName.ToString(); ddlCustomer.DataBind(); When i fetch value, it fetch first value from Dropdown, after click on Save button. After postback it reset all the value. To fetch i m using following code. object[] param=new object[50]; param[0] = ddlCustomer.SelectedItem.Value; What should be approach to Solve this problem. Thanks.