473,387 Members | 1,455 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Code disappearing from InitializeComponent in VS 2003

I have read many threads which indicate that this was a problem with
version 2002. Why should i be suffering this?

I am using VB.NET 2003 Standard Edition...

is it still a problem with 2003?

I have used the wizards to generate the connection and adapter, which
generates the code in 'InitializeComponent', and i have stored the
connection string within web.config and it seems to get rid of this
every so often.

Is there a quick work around or patch?
Nov 18 '05 #1
6 1603
Hi Winshent,

Are you manually adding any code to InitializeComponent? What code exactly
is being removed?

There is a bug that can cause this code to be removed when you change the
EnableViewState property. If that's what is happening to you, you need to
call in to us so that we can deliver that hotfix to you. Please, I don't
want to see a barrage of people e-mailing me directly asking for the fix!
:) You need to call us so that we can track who gets it.

Jim Cheshire [MSFT]
MCP+I, MCSE, MCSD, MCDBA
Microsoft Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: wi*************@yahoo.co.uk (Winshent)
Newsgroups: microsoft.public.dotnet.framework.aspnet
Subject: Code disappearing from InitializeComponent in VS 2003
Date: 27 Jul 2004 07:59:19 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <f5**************************@posting.google.com >
NNTP-Posting-Host: 62.6.139.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1090940360 23409 127.0.0.1 (27 Jul 2004 14:59:20 GMT)X-Complaints-To: gr**********@google.com
NNTP-Posting-Date: Tue, 27 Jul 2004 14:59:20 +0000 (UTC)
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!fr.ip.ndsoftware.net!proxad.net!postnews 2.google.
com!not-for-mailXref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.aspnet:250998
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

I have read many threads which indicate that this was a problem with
version 2002. Why should i be suffering this?

I am using VB.NET 2003 Standard Edition...

is it still a problem with 2003?

I have used the wizards to generate the connection and adapter, which
generates the code in 'InitializeComponent', and i have stored the
connection string within web.config and it seems to get rid of this
every so often.

Is there a quick work around or patch?


Nov 18 '05 #2
Is there a UK support number? or do i need to call you directly?

If so then email me your number.

Thanks

Vincent..

PS.. i have removed the code from InitializeComponent which has now got
round the problem.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #3
Winshent,

First of all, you didn't answer my question! :) Did you manually add code
to the InitializeComponent method? It seems to me that you are saying that
you did. If so, therein lies your problem. You should not directly modify
that code. If you do, your code will be modified. That's why we place the
large comment block warning you not to modify it.

If you didn't add code manually, you can call your local office to get the
hotfix. You can find a number at http://support.microsoft.com.

Jim Cheshire [MSFT]
MCP+I, MCSE, MCSD, MCDBA
Microsoft Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: Winshent P <wi*************@yahoo.co.uk>
References: <Pm**************@cpmsftngxa10.phx.gbl>
X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
Subject: RE: Code disappearing from InitializeComponent in VS 2003
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <eJ**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
Date: Wed, 28 Jul 2004 09:24:20 -0700
NNTP-Posting-Host: 67.41.129.85
Lines: 1
Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP09
.phx.gblXref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.aspnet:251417
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Is there a UK support number? or do i need to call you directly?

If so then email me your number.

Thanks

Vincent..

PS.. i have removed the code from InitializeComponent which has now got
round the problem.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 18 '05 #4
Jim

The only code i added was (which disappeared every so often):
(System.Configuration.ConfigurationSettings.AppSet tings.Get("ConnectionS
tring"))

on the end of:
Me.WizConnection = New System.Data.SqlClient.SqlConnection

occasionally the complete line would disappear..

Here is the code which was generated after using the Adapter and
Connection wizards:

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()
Me.WizDataAdapter = New System.Data.SqlClient.SqlDataAdapter
Me.SqlInsertCommand1 = New System.Data.SqlClient.SqlCommand
Me.WizConnection = New
System.Data.SqlClient.SqlConnection(System.Configu ration.ConfigurationSe
ttings.AppSettings.Get("ConnectionString"))
Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand
'
'WizDataAdapter
'
Me.WizDataAdapter.InsertCommand = Me.SqlInsertCommand1
Me.WizDataAdapter.SelectCommand = Me.SqlSelectCommand1
Me.WizDataAdapter.TableMappings.AddRange(New
System.Data.Common.DataTableMapping() {New
System.Data.Common.DataTableMapping("Table", "tblResults", New
System.Data.Common.DataColumnMapping() {New
System.Data.Common.DataColumnMapping("ID", "ID"), New
System.Data.Common.DataColumnMapping("Line", "Line"), New
System.Data.Common.DataColumnMapping("LogDate", "LogDate"), New
System.Data.Common.DataColumnMapping("IneffExclEng aged",
"IneffExclEngaged"), New System.Data.Common.DataColumnMapping("Engaged",
"Engaged"), New System.Data.Common.DataColumnMapping("Offered",
"Offered"), New System.Data.Common.DataColumnMapping("Answered",
"Answered"), New System.Data.Common.DataColumnMapping("Answered30s" ,
"Answered30s"), New System.Data.Common.DataColumnMapping("Abandoned",
"Abandoned"), New System.Data.Common.DataColumnMapping("Abandoned30s ",
"Abandoned30s"), New
System.Data.Common.DataColumnMapping("ServiceLevel Ratio",
"ServiceLevelRatio"), New
System.Data.Common.DataColumnMapping("IneffectiveR atio",
"IneffectiveRatio"), New
System.Data.Common.DataColumnMapping("EngagedRatio ", "EngagedRatio"),
New System.Data.Common.DataColumnMapping("AbandonedRat io",
"AbandonedRatio")})})
'
'SqlInsertCommand1
'
Me.SqlInsertCommand1.CommandText = "INSERT INTO tblResults(ID, Line,
LogDate, IneffExclEngaged, Engaged, Offered, Ans" & _
"wered, Answered30s, Abandoned, Abandoned30s, ServiceLevelRatio,
IneffectiveRatio" & _
", EngagedRatio, AbandonedRatio) VALUES (@ID, @Line, @LogDate,
@IneffExclEngaged," & _
" @Engaged, @Offered, @Answered, @Answered30s, @Abandoned,
@Abandoned30s, @Servic" & _
"eLevelRatio, @IneffectiveRatio, @EngagedRatio, @AbandonedRatio);
SELECT ID, Line" & _
", LogDate, IneffExclEngaged, Engaged, Offered, Answered,
Answered30s, Abandoned," & _
" Abandoned30s, ServiceLevelRatio, IneffectiveRatio, EngagedRatio,
AbandonedRatio" & _
" FROM tblResults"
Me.SqlInsertCommand1.Connection = Me.WizConnection
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4,
"ID"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Line",
System.Data.SqlDbType.VarChar, 100, "Line"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@LogDate",
System.Data.SqlDbType.DateTime, 8, "LogDate"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@IneffExclEnga ged",
System.Data.SqlDbType.Int, 4, "IneffExclEngaged"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Engaged",
System.Data.SqlDbType.Int, 4, "Engaged"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Offered",
System.Data.SqlDbType.Int, 4, "Offered"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Answered",
System.Data.SqlDbType.Int, 4, "Answered"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Answered30s",
System.Data.SqlDbType.Int, 4, "Answered30s"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Abandoned",
System.Data.SqlDbType.Int, 4, "Abandoned"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Abandoned30s" ,
System.Data.SqlDbType.Int, 4, "Abandoned30s"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ServiceLevelR atio",
System.Data.SqlDbType.Int, 4, "ServiceLevelRatio"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@IneffectiveRa tio",
System.Data.SqlDbType.Int, 4, "IneffectiveRatio"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@EngagedRatio" ,
System.Data.SqlDbType.Int, 4, "EngagedRatio"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@AbandonedRati o",
System.Data.SqlDbType.Int, 4, "AbandonedRatio"))
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "SELECT ID, Line, LogDate,
IneffExclEngaged, Engaged, Offered, Answered, Answered3" & _
"0s, Abandoned, Abandoned30s, ServiceLevelRatio, IneffectiveRatio,
EngagedRatio, " & _
"AbandonedRatio FROM tblResults"
Me.SqlSelectCommand1.Connection = Me.WizConnection

End Sub
Protected WithEvents lbl7 As System.Web.UI.WebControls.Label
Protected WithEvents cmdUpdate As System.Web.UI.WebControls.Button
Protected WithEvents cmdEdit As System.Web.UI.WebControls.Button
Protected WithEvents cmdPrevious As System.Web.UI.WebControls.Button
Protected WithEvents Label3 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents txtC7 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB7 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA7 As System.Web.UI.WebControls.TextBox
Protected WithEvents lbl5 As System.Web.UI.WebControls.Label
Protected WithEvents lbl4 As System.Web.UI.WebControls.Label
Protected WithEvents lbl6 As System.Web.UI.WebControls.Label
Protected WithEvents lbl1 As System.Web.UI.WebControls.Label
Protected WithEvents lbl3 As System.Web.UI.WebControls.Label
Protected WithEvents lbl2 As System.Web.UI.WebControls.Label
Protected WithEvents txtA1 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC6 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA6 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB6 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC5 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB5 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA5 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB4 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC2 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB2 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA3 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA2 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC4 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC3 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC1 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB3 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA4 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB1 As System.Web.UI.WebControls.TextBox
Protected WithEvents cmdNext As System.Web.UI.WebControls.Button
Protected WithEvents WizDataAdapter As
System.Data.SqlClient.SqlDataAdapter
Protected WithEvents SqlSelectCommand1 As
System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand1 As
System.Data.SqlClient.SqlCommand
Protected WithEvents WizConnection As
System.Data.SqlClient.SqlConnection
Protected WithEvents txtDate1 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtDate2 As System.Web.UI.WebControls.TextBox
Protected WithEvents cmdAdd As System.Web.UI.WebControls.Button

'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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #5
Is this an issue that falls over in to other projects than just web? I seem
to be having some property values disappearing in my InitializeComponent
method as well. This is for a windows project. First a bunch of data
bindings were being lost, and then the same property on all of one type of
control were lost and I had to go back and manually reset them.

Any ideas?

"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> wrote in message
news:Lj**************@cpmsftngxa10.phx.gbl...
Winshent,

First of all, you didn't answer my question! :) Did you manually add code to the InitializeComponent method? It seems to me that you are saying that you did. If so, therein lies your problem. You should not directly modify that code. If you do, your code will be modified. That's why we place the large comment block warning you not to modify it.

If you didn't add code manually, you can call your local office to get the
hotfix. You can find a number at http://support.microsoft.com.

Jim Cheshire [MSFT]
MCP+I, MCSE, MCSD, MCDBA
Microsoft Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: Winshent P <wi*************@yahoo.co.uk>
References: <Pm**************@cpmsftngxa10.phx.gbl>
X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
Subject: RE: Code disappearing from InitializeComponent in VS 2003
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <eJ**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
Date: Wed, 28 Jul 2004 09:24:20 -0700
NNTP-Posting-Host: 67.41.129.85
Lines: 1
Path:

cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP09 phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.aspnet:251417X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Is there a UK support number? or do i need to call you directly?

If so then email me your number.

Thanks

Vincent..

PS.. i have removed the code from InitializeComponent which has now got
round the problem.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #6
Winshent,

Don't modify / add / delete code in InitializeComponent. Instead, use
OnInit.

Jim Cheshire [MSFT]
MCP+I, MCSE, MCSD, MCDBA
Microsoft Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: Winshent P <wi*************@yahoo.co.uk>
References: <Lj**************@cpmsftngxa10.phx.gbl>
X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
Subject: RE: Code disappearing from InitializeComponent in VS 2003
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <u4**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
Date: Thu, 29 Jul 2004 01:46:30 -0700
NNTP-Posting-Host: 67.41.129.85
Lines: 1
Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP09
..phx.gblXref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.aspnet:251589
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Jim

The only code i added was (which disappeared every so often):
(System.Configuration.ConfigurationSettings.AppSe ttings.Get("ConnectionS
tring"))

on the end of:
Me.WizConnection = New System.Data.SqlClient.SqlConnection

occasionally the complete line would disappear..

Here is the code which was generated after using the Adapter and
Connection wizards:

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()
Me.WizDataAdapter = New System.Data.SqlClient.SqlDataAdapter
Me.SqlInsertCommand1 = New System.Data.SqlClient.SqlCommand
Me.WizConnection = New
System.Data.SqlClient.SqlConnection(System.Config uration.ConfigurationSe
ttings.AppSettings.Get("ConnectionString"))
Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand
'
'WizDataAdapter
'
Me.WizDataAdapter.InsertCommand = Me.SqlInsertCommand1
Me.WizDataAdapter.SelectCommand = Me.SqlSelectCommand1
Me.WizDataAdapter.TableMappings.AddRange(New
System.Data.Common.DataTableMapping() {New
System.Data.Common.DataTableMapping("Table", "tblResults", New
System.Data.Common.DataColumnMapping() {New
System.Data.Common.DataColumnMapping("ID", "ID"), New
System.Data.Common.DataColumnMapping("Line", "Line"), New
System.Data.Common.DataColumnMapping("LogDate", "LogDate"), New
System.Data.Common.DataColumnMapping("IneffExclEn gaged",
"IneffExclEngaged"), New System.Data.Common.DataColumnMapping("Engaged",
"Engaged"), New System.Data.Common.DataColumnMapping("Offered",
"Offered"), New System.Data.Common.DataColumnMapping("Answered",
"Answered"), New System.Data.Common.DataColumnMapping("Answered30s" ,
"Answered30s"), New System.Data.Common.DataColumnMapping("Abandoned",
"Abandoned"), New System.Data.Common.DataColumnMapping("Abandoned30s ",
"Abandoned30s"), New
System.Data.Common.DataColumnMapping("ServiceLeve lRatio",
"ServiceLevelRatio"), New
System.Data.Common.DataColumnMapping("Ineffective Ratio",
"IneffectiveRatio"), New
System.Data.Common.DataColumnMapping("EngagedRati o", "EngagedRatio"),
New System.Data.Common.DataColumnMapping("AbandonedRat io",
"AbandonedRatio")})})
'
'SqlInsertCommand1
'
Me.SqlInsertCommand1.CommandText = "INSERT INTO tblResults(ID, Line,
LogDate, IneffExclEngaged, Engaged, Offered, Ans" & _
"wered, Answered30s, Abandoned, Abandoned30s, ServiceLevelRatio,
IneffectiveRatio" & _
", EngagedRatio, AbandonedRatio) VALUES (@ID, @Line, @LogDate,
@IneffExclEngaged," & _
" @Engaged, @Offered, @Answered, @Answered30s, @Abandoned,
@Abandoned30s, @Servic" & _
"eLevelRatio, @IneffectiveRatio, @EngagedRatio, @AbandonedRatio);
SELECT ID, Line" & _
", LogDate, IneffExclEngaged, Engaged, Offered, Answered,
Answered30s, Abandoned," & _
" Abandoned30s, ServiceLevelRatio, IneffectiveRatio, EngagedRatio,
AbandonedRatio" & _
" FROM tblResults"
Me.SqlInsertCommand1.Connection = Me.WizConnection
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4,
"ID"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Line",
System.Data.SqlDbType.VarChar, 100, "Line"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@LogDate",
System.Data.SqlDbType.DateTime, 8, "LogDate"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@IneffExclEng aged",
System.Data.SqlDbType.Int, 4, "IneffExclEngaged"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Engaged",
System.Data.SqlDbType.Int, 4, "Engaged"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Offered",
System.Data.SqlDbType.Int, 4, "Offered"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Answered",
System.Data.SqlDbType.Int, 4, "Answered"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Answered30s" ,
System.Data.SqlDbType.Int, 4, "Answered30s"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Abandoned" ,
System.Data.SqlDbType.Int, 4, "Abandoned"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Abandoned30s ",
System.Data.SqlDbType.Int, 4, "Abandoned30s"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ServiceLevel Ratio",
System.Data.SqlDbType.Int, 4, "ServiceLevelRatio"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@IneffectiveR atio",
System.Data.SqlDbType.Int, 4, "IneffectiveRatio"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@EngagedRatio ",
System.Data.SqlDbType.Int, 4, "EngagedRatio"))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@AbandonedRat io",
System.Data.SqlDbType.Int, 4, "AbandonedRatio"))
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "SELECT ID, Line, LogDate,
IneffExclEngaged, Engaged, Offered, Answered, Answered3" & _
"0s, Abandoned, Abandoned30s, ServiceLevelRatio, IneffectiveRatio,
EngagedRatio, " & _
"AbandonedRatio FROM tblResults"
Me.SqlSelectCommand1.Connection = Me.WizConnection

End Sub
Protected WithEvents lbl7 As System.Web.UI.WebControls.Label
Protected WithEvents cmdUpdate As System.Web.UI.WebControls.Button
Protected WithEvents cmdEdit As System.Web.UI.WebControls.Button
Protected WithEvents cmdPrevious As System.Web.UI.WebControls.Button
Protected WithEvents Label3 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents txtC7 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB7 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA7 As System.Web.UI.WebControls.TextBox
Protected WithEvents lbl5 As System.Web.UI.WebControls.Label
Protected WithEvents lbl4 As System.Web.UI.WebControls.Label
Protected WithEvents lbl6 As System.Web.UI.WebControls.Label
Protected WithEvents lbl1 As System.Web.UI.WebControls.Label
Protected WithEvents lbl3 As System.Web.UI.WebControls.Label
Protected WithEvents lbl2 As System.Web.UI.WebControls.Label
Protected WithEvents txtA1 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC6 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA6 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB6 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC5 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB5 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA5 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB4 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC2 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB2 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA3 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA2 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC4 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC3 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtC1 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB3 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtA4 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtB1 As System.Web.UI.WebControls.TextBox
Protected WithEvents cmdNext As System.Web.UI.WebControls.Button
Protected WithEvents WizDataAdapter As
System.Data.SqlClient.SqlDataAdapter
Protected WithEvents SqlSelectCommand1 As
System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand1 As
System.Data.SqlClient.SqlCommand
Protected WithEvents WizConnection As
System.Data.SqlClient.SqlConnection
Protected WithEvents txtDate1 As System.Web.UI.WebControls.TextBox
Protected WithEvents txtDate2 As System.Web.UI.WebControls.TextBox
Protected WithEvents cmdAdd As System.Web.UI.WebControls.Button

'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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 18 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Larry Woods | last post by:
I have a site that works fine for days, then suddenly, I start getting ASP 0115 errors with an indication that session variables IN SEPARATE SESSIONS have disappeared! First, for background...
2
by: AJ | last post by:
Hi all, I'm brand new at using Visual Studio, but I have basic programming knowledge from C++. I created a Windows form with some buttons, a tab area and tabs, and some combo boxes with a list...
1
by: Jonas L | last post by:
I have created a derived version of a normal form, e.g. called MyForm (public class MyForm : System.Windows.Forms.Form). The form is simply specifing a standard icon that we use within the company....
0
by: Ryan Liu | last post by:
I think there are two way to define user control. For example, I want to define a ComoBox with contains only AM, PM items. a.. One way I define a class extends...
0
by: Colin | last post by:
Hi there, I really need your help on this. I'm trying to learn to using the VS.2003 to create a User Control. In my aspx code has no problem to use the property "grossWaye" that has "register" in...
3
by: Tabo | last post by:
when i build the project using C#, the code in InitializeComponent lost sometimes. Is it a bug?? if yes, can some method fix it? thanks for help. Tabo
8
by: edster | last post by:
A *lot* of our teams code is being deleted from the InitializeComponent() section of a winform, such as Grid settings, event handler hooks, layout settings etc. This mainly seems to happen to 3rd...
1
by: AlBruAn | last post by:
For the header on nearly all of our web pages, we're using a composite control containing, among other items, a button to perform searches based on criteria entered in other contained controls. ...
13
by: cj | last post by:
In a project done in 2003 about a year ago I was told to add the SocketWrench code below into the Windows Form Designer generated code area as shown below. #Region " Windows Form Designer...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.