I am using the Ajax control toolkit TabContainer. When I place it on the page in design view instead of seeing the Tab control I see a little brown box. I looks fine when I run the page - it just doesnt display how it will look in the design view. Am I doing something wrong or is it supposed to be this way ? Thanks

I'm trying to create a schema.ini file to impport data from a csv file and have hit a snag. According to this article - http://msdn2.microsoft.com/en-us/library/ms709353.aspx - the first line in the schema needs to be the file name. My problem is that I get uniquely named files and have no idea what they will be untill I get them. Is there a way to omit the first line in the schema or just specify the filename as *.csv ? Thanks, Nathan

I'll try that - the next field in the csv row has exactly the same types of data in it and doesnt have any problems being saved to the database

If the customer home phone contains anything other that digits it cannot be saved to the database. Thanks, Nathan

I inherited a program that takes data from a csv file and inserts it into a database. The data is in the following format: 8/20/2007 12:14:21 PM,HDFM,"Nick Yockell","Nate Wittrock",239-850-3931,239-850-2514,"Used 2004 Harley Davidson ","bought bike CUSTOMER WANTS TO BRING HIS YAMAHA R6 IN TO TRADE AND SEE HOW MUCH PAYMENTS WOULD BE. ",Deliver,aa32ed31-f0c8-4f43-a7d4-830d9f29edcd For some reason the function that saves the data to the database is having a problem with the customer phone number (5th column). The database column is a varchar(50) - the same as the customer business phone number. If the customer home phone contains anything other that digits it cannot be saved to the database. However, the customer business phone can contain anything and gets saved just fine. Is there anything in the two functions that could be causing this ? private void ProcessFile(string filename, string vendor) { string path = string.Empty; string LoggingDate = DateTime.Now.ToString(); switch (vendor.ToLower()) { case "vpulse": path = DIRECTORYPATHVPULSE; break; case "calllogpro": path = DIRECTORYPATHCALLLOGPRO; break; } try { OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+path+"\\"+";Extended Properties=\"Text;HDR=No;FMT=Delimited()\""); //OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+this.txtSource.Text+"\\"+";Extended Properties=\"Text;HDR=No;\""); OleDbCommand ExcelCommand = new OleDbCommand(@"SELECT * FROM "+filename,ExcelConnection); OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand); ExcelConnection.Open(); DataSet ExcelDataSet = new DataSet(); ExcelAdapter.Fill(ExcelDataSet); ExcelConnection.Close(); //Process File ProcessFileRecords(ExcelDataSet, vendor.ToLower()); //Email Copy to Alliance Group this.EmailFile(path, filename, vendor); } catch (Exception exc) { string errorText = exc.ToString(); System.Diagnostics.EventLog.WriteEntry("Alliance Level 2 DataRetreiver", errorText); } finally { //Archive Copy this.ArchiveFile(path, filename); } } private void ProcessFileRecordVPulse(object[] record) { string logdate = string.Empty; string dealership = string.Empty; string salesperson = string.Empty; string customername = string.Empty; string homephone = string.Empty; string businessphone = string.Empty; string product = string.Empty; string comments = string.Empty; string sellstage = s

I have a requirement to mark duplicate records when I pull them from the database. However, I only want to mark the 2nd, 3rd, 4th etc record - not the first one. The code I have below creates a column called Dupes but marks all the duplicates - including the first one. Is there a way to only mark the 2nd, 3rd, 4th etc record ? SELECT *, cs.CallStatusDescription as CSRStatusDesc, cs2.CallStatusDescription as CustomerStatusDesc, (Select MAX(CallAttemptNumber)From CallResults cr Where cl.Id = cr.CallLogId) as CallAttemptNumber, Dupes = (select count(id) from CallLogs where (CustomerHomePhone != '' AND cl.CustomerHomePhone = CustomerHomePhone) OR (CustomerBusinessPhone != '' AND cl.CustomerBusinessPhone = CustomerBusinessPhone) AND DealerId= 'hdsh' AND CSRStatus IS NULL and datediff(d, logdate, getdate()) <= 21), FROM CallLogs cl left Join CallStatus cs on cs.Id = cl.CSRstatus left Join CallStatus cs2 on cs2.Id = cl.Customerstatus Where SaleStage IN ('1', '2', '3', '4', '5', '6') And (LogProcessFlag = 1 Or LogProcessFlag = 0) And DealerId='hdsh' And Logdate Between '08/01/2007' And '08/31/2007'

And what is the way ?

My site uses forms authentication (login control etc) to grant users access to the site. Is there a way to programatically get their username once they have logged in ? Thanks

I have currency values in a dropdownlist that are formatting to look like $50, $100 etc using {0:C0} I need to remove the $ symbol before converting the string to an Int32 I tried using LoanAmount.Replace("$", ""); but this doesnt work. What should I be doing ?

I have a dataset called ReturnedDataset. It contains 1 row with 1 cell - how do I reference it ? In vb.net I would do something like - DataSet21.issues(0).title but I cant seem to find the correct syntax for c#. Thanks

I have a requirement to show two instances of the same wizard on 1 page. The problem I am having is that when I hit the next button on one wizard it validates the step it relates to but then also validates the steps on the other wizard. One way I thought of to solve this problem is by assigning the controls on each step to their own uniquely numbered validation group. And then wiring the next button on each step to the same validation group. Is this the best approach ?

I am trying (and failing miserably) to access a button in the custom navigation section of a custom template step on a wizard control. I need to set its validation group - however, the code fails when trying to find the control. Here's the code I am trying to use: Button Test1NextButton = (Button)Test1.ContentTemplateContainer.FindControl("Test1NextButton"); Test1NextButton.ValidationGroup = "1" + NewValidationGroupNumber.ToString(); Can anyone tell me what I am doing wrong ?

I need to set the validation group name for all the controls on a page during the Page Load event. Is there a way to do this using a Foreach type statement ?

I have a textbox that should be validated thats on a webcontrol. The webcontrol is on a step in a wizard control. When I click the next button the validation for the textbox does not fire. Is there a way to make the validation just for the webcontrol on the step in focus fire ?

I am trying to change the text shown on the navigation buttons on the Wizard control. I have tried using the following code: Wizard1.StepNextButtonText = "click me"; Wizard1.StartNextButtonText = "Go"; Wizard1.FinishCompleteButtonText = "End"; For some reason, this only works for Step Next buttons - I cannot change the text on the buttons on the Start or Finish steps. I have tried setting the StepType as "Auto" or "Start" & "Finish" but this does not fix the problem. Does anyone know what I am doing wrong ?

Sorry - my question was more about whether a label is the correct control/method of persisting the value.

I need to store a value on a page (and hide it from the user) and maintain it even when the page is posted back. I know I can do this by using a label (and setting it to visible = false). But is the best way of doing it ? Thanks.

OK - I meant MS Atlas.

Does anyone know if I can use Ajax with VS2003 & ASP.Net 1.1 ? Thanks

I'm trying to use this code to change the color of a row when I put the mouse on it. protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='blue'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='white'"); } } Do I need to be using hyperlink columns for all my data ? Or should it work for bound columns as well ? Thanks