Need to View / Edit a DLL

I was given an ASP.NET application that connects to a SQL Server Database.

The Database was backed up off the old server and we installed it on our servers just fine.

The ASP.NET application attempts to make a database connection but that function is in a DLL file and it seems to be hardcoded to the old SQL Server machine (I'm guessing the IP Address is hardcoded).

I need to look into the DLL that is being called in the ASP code when making the connection. To edit it so it connects to my new SQL Server instance, or at least view the contents so I can accurately recreate the funtionality in a new DLL file.

Are there any tools that can help with this

Posted On: Friday 28th of December 2012 04:21:11 AM Total Views:  207
View Complete with Replies

Related Messages:

Textbox not capturing username   (147 Views)
Hi.. does anyone know how to get loginname control value in textbox I am using loginname control after login,where it will display the username of the user. Now i want to get that username value to textbox. How do i suppose to do that
ASP.NET form to SQL tables?   (116 Views)
Does anyone know of an application that can convert a form that is in to a SQL tableThank you!
Datas are inserted but not stored in the database   (178 Views)
i got an problem in page in the form we can use more controlse that all the controls are worked well and event's also fired and that the page message also displayed properly but these are the data's are not in the database if you have any tips for me pls send yours reply for me. rpkaran This post has been edited by rpkaran: 24 June 2010 - 03:36 AM
datapager   (94 Views)
i had a listview and a datapager in my page. I had problem with my datapager. After i click next button to second page and then click search button to perform a new search, the listview will display second page instead of first page for my new search. what makes my datapager act like this
help needed   (145 Views)
hi ;i wanna insert data which is stored in a ".txt" file into an access file using anyone help!!!
Unable to cast object of type 'System.Int32' to type 'Syst   (331 Views)
hi i'am encountering this problem here in my code it triggers on my reservationid which data type is int and autonumbered it cannot read the value for the reservationid here's the line of code of mine in the line wherein it says like this"txtReservationID.Text = dr1.GetString(0); " string conn = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnectionString"].ConnectionString; using (SqlConnection dbconn2 = new SqlConnection(conn)) { using (SqlCommand cmd2 = dbconn2.CreateCommand()) { cmd2.CommandType = System.Data.CommandType.Text; // Notice the @EmployeeID. This is a parameter that // I am going to pass to the query. //cmd.CommandText = "SELECT FirstName, LastName FROM Employee WHERE EmployeeID = @EmployeeID"; cmd2.CommandText = "SELECT Reservation_ID, Email, Transaction_Date,Transaction_Time FROM tbl_Reservation WHERE Email = @Email and Transaction_Date = @Transaction_Date and Transaction_Time=@Transaction_Time "; // Adds a parameter to correspond with the parameter in the query // If you don't need a parameter, then don't add this line. //cmd2.Parameters.AddWithValue("@Email", txtEmail.Text.ToString().Trim()); cmd2.Parameters.AddWithValue("@Email", txtEmail.Text); cmd2.Parameters.AddWithValue("@Transaction_Date", txtTransactionDate.Text); cmd2.Parameters.AddWithValue("@Transaction_Time", txtTransactionTime.Text); dbconn2.Open(); using (SqlDataReader dr1 = cmd2.ExecuteReader()) { // I am only expecting one row to be returned // because only one employee will have this employeeID, // so I use an IF statement if (dr1.Read()) { // a record was returned // write the data that is being returned to the textboxes // The "0" element of the datareader is the first column that // is being returned. This would be the "FirstName" column txtReservationID.Text = dr1.GetString(0); txtConEmail.Text = dr1.GetString(1); txtDateRequest.Text = dr1.GetString(2); txtTimeRequest.Text = dr1.GetString(3); dbconn2.Close(); } } } }
Finish Button Click   (222 Views)
i wanted to open another page when inserting of data is succesffully done..otherwise a page that will redirect the user to fill up again the registration to correct their mistakes..can you give me some info how to do that here's my code in aspx.cs protected void Wizard1_FinishButtonclick(object sender, WizardNavigationEventArgs e) { insertDataIntoDB(txtFirstName.Text.ToString().Trim(), txtMiddleName.Text.ToString().Trim(), txtLastName.Text.ToString().Trim(), }
Drag and Drop files to page : upload functionality   (266 Views)
Hi , I want to Drag and drop documents, files, images to page. It should upload the file. I think we need to write ActiveX control / browser plug-in. By default, the browsers do not support this functionality. Can anyone help me writing ActiveX control in C#
Input string was not in a correct format error   (218 Views)
Hi! In my website, I have a button that is suppose to show or hide a panel depending if it is hidden or not. When I click on the button, I get this error: Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format. I searched the web a little bit, and it seems this error has to do with type casts, but this has nothing to do with my function. Here's my code: Code for the button in the aspx page: Code in the code behind file (I'm using C#): protected void btnNouvSite_Click(object sender, EventArgs e){ panNouvSite.Visible = !panNouvSite.Visible; } Anybody has an idea what my problem is
Need a column to sort by Absolute Value   (231 Views)
My problem is this, I have a search results screen that displays a table of data that is retrieved from a database. Each column can be sorted (asc, desc) by clicking the column header. One of the columns contains amounts, I need to be able to sort the column by the absolute value of those amounts when the user checks a checkbox, and then clicks the column header. The sort is done by using a Compare function. I am able to sort by absolute value by changing the compare function return to: Return Decimal.Compare(Math.Abs(p1.decOriginalAmount), Math.Abs(p2.decOriginalAmount)) However, i am not sure where to place the if statement that refers to the checkbox. I am using VS2005. Private Sub repResults_ItemDataBound( _ ByVal sender As Object, _ ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) _ Handles repResults.ItemDataBound Dim tDataSource As nsMyCDTs.cdtGetSearchResultsOutput Dim uicDetails As nsMyWebContext.DetailsUIC Dim uicOpenClaim As nsMyWebContext.OpenClaimUIC 'Dim decAbsoluteValue As Decimal 'Dim sDisplayValue As String Try If (e.Item.ItemType = _ System.Web.UI.WebControls.ListItemType.Item) OrElse _ (e.Item.ItemType = System.Web.UI.WebControls.ListItemType.AlternatingItem) OrElse _ (e.Item.ItemType = System.Web.UI.WebControls.ListItemType.Header) Then If e.Item.ItemType = ListItemType.Header Then With DirectCast(e.Item.FindControl("lnkOriginalAmount"), _ nsArchWeb.CONTROLS.LinkButton) .Text = nsTextSvc.GetLiteral _ nsMyResources.SearchResults.c_slblOriginalAmount) .CommandName = c_sSortColumn .CommandArgument = CStr(nsMyCDTs.enSortNames.OriginalAmount) End With Else With DirectCast(e.Item.FindControl("dvOriginalAmount"), nsArchWeb.CONTROLS.DataCurrency) .Value = tDataSource.decOriginalAmount .CurrencyCode = tDataSource.sOriginalCurrency End With End If End If Finally Cleanup(tDataSource) tDataSource = Nothing Cleanup(uicDetails) uicDetails = Nothing Cleanup(uicOpenClaim) uicOpenClaim = Nothing End Try End Sub Public Class CompareSortByOriginalAmountAscending Implements System.Collections.IComparer Public Function Compare(ByVal o1 As Object, ByVal o2 As Object) As Integer _ Implements System.Collections.IComparer.Compare ' Two null objects are equal If (o1 Is Nothing) AndAlso (o2 Is Nothing) Then Return 0 End If ' Any non-null object is greater than a null object. If (o1 Is Nothing) Then Return 1 End If If (o2 Is Nothing) Then Return -1 End If ' Cast both objects to specific type, and do the comparison. ' These casts should never fail. Dim p1 As cdtGetSearchResultsOutput = DirectCast(o1, cdtGetSearchResultsOutput) Dim p2 As cdtGetSearchResultsOutput = DirectCast(o2, cdtGetSearchResultsOutput) Return Decimal.Compare(p1.decOriginalAmount, p2.decOriginalAmount) End Function End Class
From Cd To Database   (257 Views)
o, I am looking for a script which i can use to transfer data from any CD to the database. Does anybody know if its possible If yes then please reply with a solution, Thanx
ASP.NET C# input string was not in a correct format (query string)   (132 Views)
folks, I'm in a bit of a bind. I have a page that is to do a function on page load that requires an ID number (integer) passed by a querystring - but I get the error that says "Input string was not in a correct format". My code to get the the value of the querystring and do the function is simple and straight forward. int custID = Convert.ToInt32(Request.QueryString["CustomID"]); RemoveItem(custID); I've tried the following ways as well. //1) int custID = int.Parse(Request.QueryString["CustomID"]); //2) string custID = Request.QueryString["CustomID"]; int intCustID = Convert.ToInt32(custID); RemoveItem(intCustID); //3 int custID = 0; int.TryParse(Request.QueryString["CustomID"], out custID); RemoveItem(custID); //this one only returned the value of 0. I'm kind of at a loss. How do I convert the "CustomID" from the querystring into an integer This post has been edited by mb2000inc: 11 July 2012 - 12:59 PM , Hi... sorry it took me so long to get back to you.... been busy. So, does give me a value. Actually, I am using a Telerik RadGrid instead of a regular Gridview - I probably should have mentioned that before - not that it has any affect on the query string... it still spits out a value for the sring. I'm currently using the "GridButtonColumn". I guess I can try to use the HyperlinkColumn, but again, I'm not sure it would change the outcome of the querystring. So, how would one convert the string value to an int (not repeating my previous tries. ) pages error "Could not load file or assembly Xheo.licensin   (161 Views)
I'm building website with VS2010. Yesterday I have install fresh Win7, install VS2010. Then open website in VS, and get below error. I have install all IIS features. I have also install all VS tools from installation, and almost all warnings has gone, except one has left Xheo.Licensing. I'm suprised that on the web there is no solution for this issue. I have checked a lot posts. Any idea Here is error when try to open my page: Server Error in '/backup v10' Application. -------------------------------------------------------------------------------- Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'Xheo.Licensing, Version=2.0.3300.0, Culture=neutral, PublicKeyToken=798276055709c98a' or one of its dependencies. The system cannot find the file specified. Source Error: Line 37: Line 38: Line 39: Line 40: Line 41: Source File: D:\BACKUP FILES\SPLETNE STRANI\VISUAL STUDIO\Backup\backup v10\web.config Line: 39 Assembly Load Trace: The following information can be helpful to determine why the assembly 'Xheo.Licensing, Version=2.0.3300.0, Culture=neutral, PublicKeyToken=798276055709c98a' could not be loaded. WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Attached image(s)
DataGrid RowCommand event   (156 Views)
Hi , i am populating a datagrid on the FormBound event and found that when i click one of my Link Button column cells to fire the RowCommand event the row count of my datagrid was going to 0 and i was getting an error. After some research it was suggested that i bind my datagrid on the PreRender form event instead as the RowCommand event was losing the datagrid data due to the post back. But when binding my datagrid on the Pre Render event i get the same result. Any ideas was great, thanks. The code below populates my datagrid fine and my count variable does go to the correct row count value as expected. When i hit my RowCommand event i do the same row count which at this point is 0. protected void Page_PreRender(object sender, EventArgs e) { Sage.Entity.Interfaces.IAccount account = (BindingSource.Current as Sage.Entity.Interfaces.IAccount); Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get(); string connStr = service.GetConnectionString(); System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr); conn.Open(); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("select z_ACCOUNT_PERSID as Id,Z_PERSON as ZPerson,Z_FAMILY as ZFamily,Z_CLASSIFICATION as ZCLASSIFICATION,Z_STATUS as ZSTATUS,MODIFYDATE as ModifyDate,MODIFYUSER as ModifyUser from z_account_pers WHERE ACCOUNTID = '" + account.Id.ToString() + "'", conn); cmd.CommandType = System.Data.CommandType.Text; System.Data.OleDb.OleDbDataReader reader = cmd.ExecuteReader(); grdZACCOUNTPERSS.DataSource = reader; grdZACCOUNTPERSS.DataBind(); int count = grdZACCOUNTPERSS.Rows.Count; }
loading listbox with random sort?   (144 Views)
I have a listbox like so Dim nameList As New ArrayList nameList.Add("Alex") nameList.Add("Bob") nameList.Add("Carl") nameList.Add("David") nameList.Add("Zee") listBoxNames.DataSource = nameList listBoxNames.DataBind() I want to load it randomly each time the page is loaded.
Deleting a file from a directory   (193 Views)
I am able to view a directory and also upload a file to a directory, I am having trouble deleting a file in the directory Here is my code for the Default.aspx Page Accessing a shared folder protected void Button2_Click(object sender, EventArgs e) { if(FileUpload1.HasFile) try { FileUpload1.SaveAs(@"\\ned-505\c$\CaleroShared\" + FileUpload1.FileName); Label1.Text = "File has been successfully uploaded"; } catch (Exception ex) { Label1.Text = "ERROR: " + ex.Message.ToString(); } else { Label1.Text = "You have not specified a file."; } }         and here is the code in my Default.aspx.cs page using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace NetworkFolderAccess { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button3_Click(object sender, EventArgs e) { string fileName = ""; fileName = Convert.ToString(FileDelete); try { if(File.Exists(fileName)) { File.Delete(fileName); Label2.Text = "File deleted successfully"; } else { throw new FileNotFoundException(); } } catch(FileNotFoundException ex) { Label2.Text += ex.Message; } catch(Exception ex) { Label2.Text += ex.Message; } } } } This post has been edited by TheGame1083: 25 September 2009 - 12:03 PM
MultiViews   (125 Views)
I had to set up the 3rd case which was misspelled on the CS. That is why it was not working. case 2; break;
Membership Login Control with Drop-Down Not Working!   (182 Views)
The main problem is there isn't a control on the page called LoginUser.However, I'd also be concerned that displaying a list of usernames on a login page isn't deemed a security risk. Mark,Darlington Web Design | Experts, Information, Ideas & Knowledge | ASP.NET Tips & Tricks
ListBox control problem   (141 Views)
I am used to Visual Foxpro and am trying to learn 4. I am having problems with a bound listbox control. The DatasourceID = SqlDataSource1. The listbox shows all the all the rows of a certain field, but when I click on a single selection in the Listbox, nothing happens. Then I tried changing the select command in the SqlDataSource1 DataControl and chose Control (ListBox1) from the parameter source drop down list. After this, the list box does not even get populated. I am used to "wizards" in Foxpro and I found difficult.
WCF timeout error handling on client side   (319 Views)
,I am serching solution for one problem since few days but no success. My problem is, I have handled timeout error in client of WCF error in such a way that if data is large to fetch, after 10 minutes(as all timeout in web config of client are set to 10 minutes) it should show me customize message 'Too many records to fetch, please modify criteria'. It works on my local system as per expected but if I put it in test server(Service is in one test server and Client application in one test server) it gives me following runtime error. The message could not be processed. This is most likely because the action '' is incorrect or because the message contains an invalid or expired security context token or because there is a mismatch between bindings. The security context token would be invalid if the service aborted the channel due to inactivity. To prevent the service from aborting idle sessions prematurely increase the Receive timeout on the service endpoint's binding. The thing is if I set SendTimeout in test server client config less than 20 seconds then it works fine but we should not be limited upto 20 seconds as it is awfully short.Please help me on this because it is urgent now.
Server Application Unavailable   (140 Views)
I built a site and place it under IIS (windows 2003) and whenever I tried accessing the site on the server itself it gives out the message "Server Application Unavailable". I tried looking on the Application log of the server but can't find any error there that could help me narrow down the cause of the error. Would appreciate some help.
Receiving SMTP messages   (162 Views)
I've read a lot all over the internet about how it is possible to send emails using SMTP. However, I would like to know if anybody knows how to RECEIVE emails using SMTP. Basically, I have an email adrress on an SMTP server and I want to know if I can check it using VB .NET 2003 Dan GriffithsSoftware AnalystNational Grid plc
how to pass values from page to page   (285 Views)
greetings good experts.In classic asp, I would pass values via hidden form or query string.Can someone please show me how this is done in asp.netI am using version 2.0 and I am working with vs.2003So far, anything I tried has failed.I am trying to pass only 6 values from page1.aspx to page2.aspx. 2 of those values is checkboxList.Here is an example of what I am trying to do.CODEOption Explicit On Imports SystemImports System.DataImports System.Data.SqlClientImports System.XmlImports System.WebImports System.DrawingImports System.Web.UIImports System.Web.UI.WebControlsImports System.Web.UI.HtmlControlsImports System.Web.UI.PageImports Microsoft.VisualBasicImports System.Web.HttpApplicationImports System.Web.HttpResponsePublic Class _default Inherits System.Web.UI.Page Protected WithEvents txtAuthName As System.Web.UI.WebControls.TextBox Protected WithEvents txtservice As System.Web.UI.WebControls.checkBoxList Protected WithEvents txtcheck As System.Web.UI.WebControls.checkBoxList Protected WithEvents txtAuthJob As System.Web.UI.WebControls.TextBox Protected WithEvents txtAuthPhone As System.Web.UI.WebControls.TextBox Protected WithEvents txtservice As System.Web.UI.WebControls.CheckBoxList Protected WithEvents txtccCheck As System.Web.UI.WebControls.CheckBoxList Protected WithEvents btnSave As System.Web.UI.WebControls.Button Protected WithEvents txtAuthEmail As System.Web.UI.WebControls.TextBox#Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. Private Sub InitializeComponent() End Sub Protected WithEvents service As System.Web.UI.WebControls.CheckBoxList Protected WithEvents ccCheck As System.Web.UI.WebControls.CheckBoxList Protected WithEvents AuthName As System.Web.UI.WebControls.TextBox Protected WithEvents AuthJob As System.Web.UI.WebControls.TextBox Protected WithEvents AuthPhone As System.Web.UI.WebControls.TextBox Protected WithEvents AuthEmail As System.Web.UI.WebControls.TextBox Protected WithEvents submit As System.Web.UI.WebControls.Button Protected WithEvents Form1 As System.Web.UI.HtmlControls.HtmlForm 'NOTE: The following placeholder declaration is required by the Web Form Designer. 'Do not delete or move it. Private designerPlaceholderDeclaration As System.Object Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Me.txtAuthName.Text = Request.QueryString("AuthName") Me.txtService.Text = Request.QueryString("cService") Me.txtcCheck.Text = Request.QueryString("cCheck") Me.txtAuthJob.Text = Request.QueryString("AuthJob") Me.txtAuthPhone.Text = Request.QueryString("AuthPhone") Me.txtAuthEmail.Text = Request.QueryString("AuthEmail") End Sub Private Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Response.Redirect("requesters.aspx" + "&AuthName=" + Server.UrlEncode(Me.txtAuthName.Text) + "&cService=" + Server.UrlEncode(Me.txtCheck.Text) + "&cCheck=" + Server.UrlEncode(Me.txtAuthName.Text) + "&AuthJob=" + Server.UrlEncode(Me.txtAuthJob.Text) + "&AuthPhone=" + Server.UrlEncode(Me.txtAuthPhone.Text) + "&AuthEmail=" + Server.UrlEncode(Me.txtAuthEmail.Text)) End SubThis is not working.I am getting an error that the way I am doing checkboxlist is incorrect. Please. please help
hi, I have a linkbutton that when   (106 Views)
hi,I have a linkbutton that when clicked, the ajax modal pops up.however, I do not want to click on the link to launch the model popup.Instead, I would like javascript to execute the link button when my webpage loads this,but that doesnt work.thisis where i need your help.
DataGrid Delete Method   (244 Views)
I have a datagrid that is populated using a TableAdapter via a simple piece of Business Logic Layer code.The poulation works perfectly and I then added a delete command column to the grid. In my BLL there is a delete method that works when called from code and I assigned this to my ObjectDataSource from which the table is populated.However when a user clicks on the delete link I get the following error...ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'DeleteEntry' that has paramaters 'GuestbookID, original_GUESTBOOK_ID'Does anyone have any idea why I'm getting this error For a start I can't work out why there are two paramaters as the method I've created only required 1, the GuestbookID. help would be much appreciated.Cheers, Steve G (MCP)
Passing variable   (155 Views)
I have some code that uploads a file (excel) to our server ( CODE Sub Upload_Click(Sender as Object, e as EventArgs) ' Display properties of the uploaded file FileName.InnerHtml = MyFile.PostedFile.FileName FileContent.InnerHtml = MyFile.PostedFile.ContentType FileSize.InnerHtml = MyFile.PostedFile.ContentLength UploadDetails.visible = True' Let us recover only the file name from its fully qualified path at client Dim strFileName as string strFileName = MyFile.PostedFile.FileName Dim c as string = System.IO.Path.GetFileName(strFileName) ' only the attched file name not its path ' Let us Save uploaded file to server at C:\ServerFolder\ Try MyFile.PostedFile.SaveAs("C:\ServerFolder\" + c) Span1.InnerHtml = "Your File Uploaded Sucessfully as: ..C:\ServerFolder\" & c Span3.InnerHtml = "Thank you! Click TRANSFER to import to access. " BtnTransfer.visible=true catch Exp as exception span1.InnerHtml = "An Error occured. Please check the attached file" UploadDetails.visible = false span2.visible=false span3.visible=false BtnTransfer.visible=false End Try End SubI have another page that takes that file and imports it into access (asp)CODE Dim cnnExcel, rstExcel Dim cnnAccess, rstAccess Dim strExcelFile Dim strAccessFile strExcelFile = Server.MapPath(".") & "\Server\" & "ExcelExportData.xls" strAccessFile = Server.MapPath(".") & "\ImportData.mdb" The question I have is.. is there a way I can pass that C variable into my asp file
Dropdownlist in a detailsview updating   (149 Views)
I have the following code that has a dropdownlist in the detailsview. When I click update I get thisCould not find control 'drpTime' in ControlParameter 'startTimeDisplay'. Keywords Start Time Current Start Time:    
how to move a .net app to new hardware (iis 5 to 6)   (170 Views)
I have an old machine running a .net app (C# - SQL Server) on W2K-iis5 and need to move it to W2K3-iis6. What is the best way to do thisShould I try the migration tool or is there a better way The app is not compiled into a .dll
Please help with HTML Dropdown control problem.   (159 Views)
,I have been looking for a solution and trying to understand this all day today but still can not get it. Since I am new with and have to maintain this application so I am learning as I go. Can someone please give me a hand on this.I have a form that has a number of questions requesting time so the prev. developer had put in 2 html dropdown controls as hour, minutes. For this thread, let called them Time1h, Time1m, Time2h, and Time2m. They are set for not allowing multiple via the property windows. On initializing the page or loading up the page and fill it with whatever in the database, there were not any problem with time1h and time1m (I checked it out already). The problem raised when it hit Time2h and time2h.The error from the web as:"An HtmlSelect cannot have multiple items selected when Multiple is false."How could this be Here is what I did so far to t-shoot it.1. I compared the settings between Time1h, Time1m, Time2h, and Time2m to see if I overlook anything but found none.2. Look at the code between them but found none (except for the variable name). Here is the snip of the code of these 2 controls:For Time1h and m:CODEIf myDataRow.Item("TELETIME").ToString "-1" thenTELETIMEH.Items.FindByValue(myDataRow.Item("TELETIME").ToString.Split(":".ToCharArray)(0)).Selected= TrueTELETIMEM.Items.FindByValue(myDataRow.Item("TELETIME").ToString.Split(":".ToCharArray)(1)).Selected= True End IfFor Time2h and m:CODEIf myDataRow.Item("INTERTIME").ToString "-1" ThenINTERTIMEH.Items.FindByValue(myDataRow.Item("INTERTIME").ToString.Split(":".ToCharArray)(0)).Selected= TrueINTERTIMEM.Items.FindByValue(myDataRow.Item("INTERTIME").ToString.Split(":".ToCharArray)(1)).Selected= TrueEnd If3. I then looked at the html code to see if there is any different between these 2 code sections and again could not see (unless I really missed it).here is the html code for these 2:Time1CODE Scheduled Telephone Interview Time:  1 2 3 4 : 00 15 30 45 And Time2:CODE Scheduled Interview Time:  1 2 3 4: 00 15 30 45Sorry for the long post but I have to describle it so you can fully see my problem. As I have said, I am at the end of the rope and can not see why 1 section of the code is working ok and the other is not since they are virtually identical.Can someone please take a look at these code snippets and point out that I DID missed something or have other suggestions that I can try to get this thing on the road...As always
Template column & Javascript   (166 Views)
I have a datagrid with a template column in that I'm using to open a link so that users can drill down to the next level of some data. I'd really like to utilise javascript so that I can set the properties of the new window that's opened but can't get it to work despite looking through the other posts in the forum that relate to this.My column code is attached - can anyone give me a pointe
How to call a procedure button1_click ?   (286 Views)
If there are some codes in the button click event, how can we call this procedure from within some other codes without clicking that button.Armas
execute an Excel macro when the cell value is changed by an ASP.NET we   (102 Views)
,I am facing problem in writing to an Excel file from ASP.NET. I want to change the value of a cell (B7) on the button click from ASP.NET web enabled browser. Following is the code of my ASP.NET web application: ' write_to_plc.aspx ' Private m_sConn1 As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\test.xls;" & _ "Extended Properties=""Excel 8.0;HDR=YES""" Sub Button1_Click(sender As Object, e As EventArgs) Update_Individual_Cells() End Sub Public Sub Update_Individual_Cells() '========================================================================== ' Update individual cells on the PlcData worksheet; ' specifically, cell B7 is modified. '========================================================================== ' NOTE: The connection string indicates that the table does *NOT* ' have a header row. Dim conn As New System.Data.OleDb.OleDbConnection(m_sConn1.Replace("HDR=YES", "HDR=NO")) conn.Open() Dim cmd As New System.Data.OleDb.OleDbCommand() cmd.Connection = conn 'Updates a cell B7 of the spreadsheet, PlcData to "1". cmd.CommandText = "UPDATE [PlcData$B7:B7] SET F1 = '1'" cmd.ExecuteNonQuery() conn.Close() End Sub Click this button to start an experiment:Click I want to get an Excel macro executed, when a cell value is changed. So, I wrote the following macro in ThisWorkbook of test.xls file:Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Msgbox hello End SubSo, whenever the cell value is changed from 0 to 1, this macro should get executed.The problem is that the ASP.NET web application updates the value from 0 to 1, but the macro doesnt get executed until I open the file manually.Can someone please fix thisI tried another thing I kept the excel file open prior to executing ASP.NET code. It gives me error message: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.I do not know about how to fix this either.It will be great, if someone could help me with this. I appreciate your help
Explain object use; using object before it's constructed   (181 Views)
I think I have a fair grip on OOP, but this part of VB.NET has me a bit confused:CODEsub Page_Load(sender As Object, e As EventArgs)dim maxDaysNewMonth as integer = datetime.DaysInMonth(1996, 2)response.write(maxDaysNewMonth)end subWhat confuses me is the datetime method call. My can I use a method of this class, when I havn't created the object yet Is this an object that is made available to me my the .NET framework somehow The page somehow makes this object availabe to me, just like the response object I looked in MSDN, and they don't even call this a class, but rather a structure, but it still has methods.Does anyone have any insight into this Any pointers LinksI mean, I wouldn't do this:CODEdim intStringLength = String("Steve").Length
Validation Controls not working in Mozilla web browser on client side   (97 Views)
Hi frnds My Validation Controls are not working in Mozilla web browser on client side.I have even tried the attribute "EnableClientScript" = True.Any suggestion Will be
Formatting Problem   (177 Views)
I want to display my numbers formatted in text boxes like this: $20,000.00 -- I can use the formatcurrency() function to do this but...The problem is that when I go to do an insert the comma in the amount figure gets interpreted as a new value, so it thinks there are more values than fields in the statement.Is there any way to "unformat" a number before inserting it into the database, like this: 20000.00 instead of this: $20,000.00
problems using page.databind when outputting values from an object   (195 Views)
I'm using a page with several panels - I instantiate an object and using Page.DataBind(); in the subroutine in the codebehind and in the apsx page - so far so good.I then change the value in the object and use the same approach as above Page.DataBind(); in the subroutine in the codebehind and in a different panel the apsx page and I get System.NullReferenceException: and the error points to the line where I call Page.DataBind(); the second time.I've worked around this now but I'm curious why I should get the error in the first place
Simple way to sort in editing datagrid for share   (221 Views)
In order to sort in two way, ASC and DESC, in editing datagrid, I found a simple way. I posted here for share:1) make a label lblToggle invisible and text = "ASC"2) Sub dgReportDetail_Sort(ByVal Sender As Object, ByVal E As DataGridSortCommandEventArgs) Dim strMyOrder As String If Me.lbltoggle.Text = "ASC" Then strMyOrder &= E.SortExpression & " ASC" MyBindData(strMyOrder) Me.lbltoggle.Text = "DESC" Else strMyOrder &= E.SortExpression & " DESC" MyBindData(strMyOrder) Me.lbltoggle.Text = "ASC" End If End Sub
Email formats   (259 Views)
I have a problem with emails that I am generating. An example of a few of lines are shown below:strMsg = strMsg & "Best regards. "strMsg = strMsg & "IWTP Ltd "mailMessage.From = ""mailMessage.To = strEmailmailMessage.Subject = "itwp-Confirmation"mailMessage.BodyFormat = System.Web.Mail.MailFormat.TextmailMessage.Body = strMsgIn AOL the emails display correctly with line breaks and paragraphs, but if I view them in MS Outlook I get one long line of text that includes s and s. I have tried both MailFormat.Text and MailFormat.Html but it makes no difference.Am I sending the emails incorrectly or is this simply a configuration issue with Outloo
Login failed for user in the SQL server 2000   (209 Views)
Hi all,I have an error when I tried to access to the microsoft sql server 2000 with asp .net. Here is the error:* Error while accessing database.Login failed for user 'IS-3PKK5HMGJMS1\ASPNET'.Microsoft OLE DB Provider for SQL Server***The code of web.config is bellow. It seems the server does not allow me to access through the UserList database because the user 'IS-3PKK5HMGJMS1\ASPNET' is not granted, tell me if I wrong
ASP Newbie question regarding Database.   (177 Views)
Ok, i have things setup on my PC (IIS 5/WIn2000) so I can do some ASP and ASP.NET development and learn a few things. My question is at some stage my asp pages will start displaying/retrieving from a database. Does IIS or the .NET framework have some default database. Even if it has is it advisable to a copy of MS SQL SERVEr 200
Graphing with   (149 Views)
Can someone help me with turning a string of numbers like y=mx+b(Remember algebra!) into a graph. im really looking to turn much more complex numbers into graphs. If im correct the graphs should come out in in a jpg/gif image format
Alternative Development Environments   (148 Views)
,Are any of you aware of an alternative development environment to MS Visual Studio .NET Ideally I'd like it to be color encoded and have some form of intelli-sense(that great feature in VS.NET that lists members, functions, etc after you place a "." behind an object)
best method   (174 Views)
Hi-hopefully this is an easy one. I have a information page, that has different activities. each activity has multiple categories. in these categories is just a long list of things. i want the list to be in mulitple columns in a table. My query returns the list, now i need a good way to create the table. datagrid would be sweet if i could make one column of data show as multiple. any other control other than trying to make a dynamic table work that you can think o
How do I set it so Datalists won't overlap   (166 Views)
hi, I've got multiple datalists on one page, and they are populated dynamically according to queries that are run to get the required data. Now, there is a dynamic number of records that either of the lists will have. I am displaying them one below the other. How do I set it so that they won't over lap eachother.Also so that the labels asscoiated with each will move down accorningly.Anyone done this ye
Passing a value from a datalist to a Function   (147 Views)
tried using this code below, but the problem is it is sending all the items in the datalist versus the one that is relevant to the item clicked. Can someone helpPublic Function SetLink(ByVal thelink As String)As String Session("link")=theLink 'nextgrid.databind Return "" End Function Folders
Migrating a ASP Web App   (236 Views)
I am trying to work out how to migrate a typical ASP web app. to ASP.NET. The web app was built around the DNA architecture, so has the ASP's, Business components (VB), and Data components. I am unsure how to approach this in .NET. Should I keep the business/data layers and write them as .NET components (classes). Also, many of the data comps return recordsets, should they return DataSets in .NE
Login page appears in all frames instead of on its own page   (172 Views)
Anyone heard of this My login.aspx page sometimes loads into all frames of my default.aspx page when I try to load the default.aspx page while not yet logged on. As far as I can tell, what is supposed to happen is that if a user is not yet logged on (Forms based Authentication) and tries to access any page on that web, then he/she should be immidiately redirected to the login.aspx page. But what is happening is that the default.aspx page is being loaded, and then all the frames on it contain seperate instances of the login.aspx page...Any ideasTIA Chris
Force prior .net framework   (176 Views)
I work in an environment that does not allow any software not on an approved list to be installed on any computers. Visual Studio .net is not on the approved list. Also, the .net framework on the computers is 1.1.We had the idea of developing applications on our personal laptops and then installing it on the existing computers (software that is developed in house is ok). However, most of us have later versions of the .net framework and inevitably, the apps we develop on our own laptops look for something that is not in the 1.1 framework. Is there any way to force Visual Studio to confine itself to using the 1.1 framework
http modules in machine.config?   (135 Views)
Morning all,I'm just getting my head round http modules and have successfully got one working a-okay with an application using the web.config as follows:Now - i'm trying to get it so that my standard header is on all my apps without having to reference them all individually via the web.config. Everything i've read says that i just need to put an
Sporadic error message   (208 Views)
Hi all,I have about 5 aspx pages in my root directory. For most part these application run without any problem but sometimes I get this sporadic error message and none of the 5 aspx pages apps. are working after I click to the apps so many times the application will start working again.So every time I have this error I have to click one of the apps numerous times inorder to make the apps get to work. Do you have any clue why all of them at the same time show an error message.will this error caused because the web.config file is corrupted or something else. I do not have the access to see the error message from the log event page...please point me to the right direction.Thank you