Why this code is not working? I think the problem is in the business class
code.when I select a state from the dropdownlist, the school dropdownlist
suppose
to fill with school names, but somehow the state value is not getting back
to the business class. I think it's the way I'm using property get and set
accessor function.
****My Business Class------------
' Private variables
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet
myStateID = StateID
Dim tool As New StuLotto.Accoun ts.Data.Account sTool
Return tool.GetSchoolB yStateList(mySt ateID)
End Function
' Properties
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
Public Property StateID() As String
Get
Return myStateID
End Get
Set(ByVal value As String)
myStateID = value
End Set
End Property
****My CodeBehind Class----------------
' Bind the school by selected state drop-down combobox
Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As
System.Object, ByVal e As System.EventArg s) Handles
SStateDDL.Selec tedIndexChanged
Dim Schools As New DataSet
Dim Value As String = SStateDDL.Selec tedItem.Value
Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value)
SNameDDL.DataSo urce = Schools
SNameDDL.DataTe xtField = "SchoolName "
SNameDDL.DataVa lueField = "SchoolID"
SNameDDL.DataBi nd()
End Sub 13 1135
I don't see the property StateID called anywhere in your sniplet...
/mortb
"Leon" <vn*****@msn.co m> wrote in message
news:ee******** ******@TK2MSFTN GP12.phx.gbl... Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
How do I fix that problem?
"mortb" <mortb1<noospam <@hotmail.com > wrote in message
news:eD******** ******@TK2MSFTN GP15.phx.gbl... I don't see the property StateID called anywhere in your sniplet...
/mortb
"Leon" <vn*****@msn.co m> wrote in message news:ee******** ******@TK2MSFTN GP12.phx.gbl... Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
Leon wrote: Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
When you debug this code, what is returned by the various "GetSchool"
methods? Are you sure the correct "state" value is supplied?
The property you mention is never used (in your published code).
The "StateID" in the first method is a local variable.
Hans Kesting
nothing is returned. I also change my code to the following and it does not
work, but compile errors.
' Bind the school by selected state drop-down combobox
Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object,
ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged
Dim Schools As New DataSet
Dim Value As String = Accounts.Busine ss.AccountsTool .StateID =
SStateDDL.Selec tedItem.Value.T oString
Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value)
SNameDDL.DataSo urce = Schools
SNameDDL.DataTe xtField = "SchoolName "
SNameDDL.DataVa lueField = "SchoolID"
SNameDDL.DataBi nd()
End Sub
"Hans Kesting" <ne***********@ spamgourmet.com > wrote in message
news:O6******** *****@TK2MSFTNG P14.phx.gbl... Leon wrote: Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
When you debug this code, what is returned by the various "GetSchool" methods? Are you sure the correct "state" value is supplied?
The property you mention is never used (in your published code). The "StateID" in the first method is a local variable.
Hans Kesting
Problem? It may not be a problem. It depends on what you want to do.
The funciton GetSchoolByStat e(ByVal StateID As String)
takes a StateID and sets the private variable myStateID. The get/set
accessor is never called in your example but may be somewhere else in your
program.
You should debug and see what is passed into GetSchoolByStat e.
If the right value is passed the problem lies in the function
GetSchoolByStat e calls.
cheers,
mortb
"Leon" <vn*****@msn.co m> wrote in message
news:ul******** ******@TK2MSFTN GP14.phx.gbl... How do I fix that problem?
"mortb" <mortb1<noospam <@hotmail.com > wrote in message news:eD******** ******@TK2MSFTN GP15.phx.gbl...I don't see the property StateID called anywhere in your sniplet...
/mortb
"Leon" <vn*****@msn.co m> wrote in message news:ee******** ******@TK2MSFTN GP12.phx.gbl... Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
How do you know the get/set accessor is never called?
"mortb" <mortb1<noospam <@hotmail.com > wrote in message
news:uR******** ******@TK2MSFTN GP15.phx.gbl... Problem? It may not be a problem. It depends on what you want to do. The funciton GetSchoolByStat e(ByVal StateID As String) takes a StateID and sets the private variable myStateID. The get/set accessor is never called in your example but may be somewhere else in your program. You should debug and see what is passed into GetSchoolByStat e. If the right value is passed the problem lies in the function GetSchoolByStat e calls.
cheers, mortb
"Leon" <vn*****@msn.co m> wrote in message news:ul******** ******@TK2MSFTN GP14.phx.gbl... How do I fix that problem?
"mortb" <mortb1<noospam <@hotmail.com > wrote in message news:eD******** ******@TK2MSFTN GP15.phx.gbl...I don't see the property StateID called anywhere in your sniplet...
/mortb
"Leon" <vn*****@msn.co m> wrote in message news:ee******** ******@TK2MSFTN GP12.phx.gbl... Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
then we would see
string X = Accounts.Busine ss.AccountsTool .StateID
or
Accounts.Busine ss.AccountsTool .StateID = "foo"
in your codebehind code
"Leon" <vn*****@msn.co m> wrote in message
news:OY******** ******@TK2MSFTN GP09.phx.gbl... How do you know the get/set accessor is never called? "mortb" <mortb1<noospam <@hotmail.com > wrote in message news:uR******** ******@TK2MSFTN GP15.phx.gbl... Problem? It may not be a problem. It depends on what you want to do. The funciton GetSchoolByStat e(ByVal StateID As String) takes a StateID and sets the private variable myStateID. The get/set accessor is never called in your example but may be somewhere else in your program. You should debug and see what is passed into GetSchoolByStat e. If the right value is passed the problem lies in the function GetSchoolByStat e calls.
cheers, mortb
"Leon" <vn*****@msn.co m> wrote in message news:ul******** ******@TK2MSFTN GP14.phx.gbl... How do I fix that problem?
"mortb" <mortb1<noospam <@hotmail.com > wrote in message news:eD******** ******@TK2MSFTN GP15.phx.gbl... I don't see the property StateID called anywhere in your sniplet...
/mortb
"Leon" <vn*****@msn.co m> wrote in message news:ee******** ******@TK2MSFTN GP12.phx.gbl... > Why this code is not working? I think the problem is in the business > class > code.when I select a state from the dropdownlist, the school > dropdownlist suppose > to fill with school names, but somehow the state value is not getting > back > to the business class. I think it's the way I'm using property get and > set > accessor function. > > > ****My Business Class------------ > ' Private variables > > > > > '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > - > - - > Private Shared myStateID As String > > Public Shared Function GetSchoolByStat e(ByVal StateID As String) As > DataSet > myStateID = StateID > Dim tool As New StuLotto.Accoun ts.Data.Account sTool > Return tool.GetSchoolB yStateList(mySt ateID) > End Function > > ' Properties > > > > > '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > - > - - > Public Property StateID() As String > Get > Return myStateID > End Get > Set(ByVal value As String) > myStateID = value > End Set > End Property > > > ****My CodeBehind Class---------------- > ' Bind the school by selected state drop-down combobox > Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As > System.Object, ByVal e As System.EventArg s) Handles > SStateDDL.Selec tedIndexChanged > Dim Schools As New DataSet > Dim Value As String = SStateDDL.Selec tedItem.Value > Schools = > Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) > SNameDDL.DataSo urce = Schools > SNameDDL.DataTe xtField = "SchoolName " > SNameDDL.DataVa lueField = "SchoolID" > SNameDDL.DataBi nd() > End Sub > >
it's still not working even when I try..What should I do? Thanks!
then we would see
string X = Accounts.Busine ss.AccountsTool .StateID
or
Accounts.Busine ss.AccountsTool .StateID = "foo"
in your codebehind code
"mortb" <mortb1<noospam <@hotmail.com > wrote in message
news:uU******** ********@TK2MSF TNGP15.phx.gbl. .. then we would see string X = Accounts.Busine ss.AccountsTool .StateID or Accounts.Busine ss.AccountsTool .StateID = "foo" in your codebehind code
"Leon" <vn*****@msn.co m> wrote in message news:OY******** ******@TK2MSFTN GP09.phx.gbl... How do you know the get/set accessor is never called? "mortb" <mortb1<noospam <@hotmail.com > wrote in message news:uR******** ******@TK2MSFTN GP15.phx.gbl... Problem? It may not be a problem. It depends on what you want to do. The funciton GetSchoolByStat e(ByVal StateID As String) takes a StateID and sets the private variable myStateID. The get/set accessor is never called in your example but may be somewhere else in your program. You should debug and see what is passed into GetSchoolByStat e. If the right value is passed the problem lies in the function GetSchoolByStat e calls.
cheers, mortb
"Leon" <vn*****@msn.co m> wrote in message news:ul******** ******@TK2MSFTN GP14.phx.gbl... How do I fix that problem?
"mortb" <mortb1<noospam <@hotmail.com > wrote in message news:eD******** ******@TK2MSFTN GP15.phx.gbl... >I don't see the property StateID called anywhere in your sniplet... > > /mortb > > > "Leon" <vn*****@msn.co m> wrote in message > news:ee******** ******@TK2MSFTN GP12.phx.gbl... >> Why this code is not working? I think the problem is in the business >> class >> code.when I select a state from the dropdownlist, the school >> dropdownlist suppose >> to fill with school names, but somehow the state value is not getting >> back >> to the business class. I think it's the way I'm using property get >> and set >> accessor function. >> >> >> ****My Business Class------------ >> ' Private variables >> >> >> >> >> >> '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >> - >> - - >> Private Shared myStateID As String >> >> Public Shared Function GetSchoolByStat e(ByVal StateID As String) As >> DataSet >> myStateID = StateID >> Dim tool As New StuLotto.Accoun ts.Data.Account sTool >> Return tool.GetSchoolB yStateList(mySt ateID) >> End Function >> >> ' Properties >> >> >> >> >> >> '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >> - >> - - >> Public Property StateID() As String >> Get >> Return myStateID >> End Get >> Set(ByVal value As String) >> myStateID = value >> End Set >> End Property >> >> >> ****My CodeBehind Class---------------- >> ' Bind the school by selected state drop-down combobox >> Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As >> System.Object, ByVal e As System.EventArg s) Handles >> SStateDDL.Selec tedIndexChanged >> Dim Schools As New DataSet >> Dim Value As String = SStateDDL.Selec tedItem.Value >> Schools = >> Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) >> SNameDDL.DataSo urce = Schools >> SNameDDL.DataTe xtField = "SchoolName " >> SNameDDL.DataVa lueField = "SchoolID" >> SNameDDL.DataBi nd() >> End Sub >> >> > >
In the debugger!!
"Leon" <vn*****@msn.co m> wrote in message
news:um******** ******@TK2MSFTN GP10.phx.gbl... nothing is returned. I also change my code to the following and it does
not work, but compile errors.
' Bind the school by selected state drop-down combobox
Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged
Dim Schools As New DataSet
Dim Value As String = Accounts.Busine ss.AccountsTool .StateID = SStateDDL.Selec tedItem.Value.T oString
Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value)
SNameDDL.DataSo urce = Schools
SNameDDL.DataTe xtField = "SchoolName "
SNameDDL.DataVa lueField = "SchoolID"
SNameDDL.DataBi nd()
End Sub
"Hans Kesting" <ne***********@ spamgourmet.com > wrote in message news:O6******** *****@TK2MSFTNG P14.phx.gbl... Leon wrote: Why this code is not working? I think the problem is in the business class code.when I select a state from the dropdownlist, the school dropdownlist suppose to fill with school names, but somehow the state value is not getting back to the business class. I think it's the way I'm using property get and set accessor function.
****My Business Class------------ ' Private variables '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Private Shared myStateID As String
Public Shared Function GetSchoolByStat e(ByVal StateID As String) As DataSet myStateID = StateID Dim tool As New StuLotto.Accoun ts.Data.Account sTool Return tool.GetSchoolB yStateList(mySt ateID) End Function
' Properties '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Public Property StateID() As String Get Return myStateID End Get Set(ByVal value As String) myStateID = value End Set End Property
****My CodeBehind Class---------------- ' Bind the school by selected state drop-down combobox Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles SStateDDL.Selec tedIndexChanged Dim Schools As New DataSet Dim Value As String = SStateDDL.Selec tedItem.Value Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te(Value) SNameDDL.DataSo urce = Schools SNameDDL.DataTe xtField = "SchoolName " SNameDDL.DataVa lueField = "SchoolID" SNameDDL.DataBi nd() End Sub
When you debug this code, what is returned by the various "GetSchool" methods? Are you sure the correct "state" value is supplied?
The property you mention is never used (in your published code). The "StateID" in the first method is a local variable.
Hans Kesting
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: James Cameron |
last post by:
Hi I'm developing a program and the client is worried about future
reuse of the code. Say 5, 10, 15 years down the road. This will be a
major factor in selecting the development language. Any comments on
past experience, research articles, comments on the matter would be
much appreciated. I suspect something like C would be the best based
on comments I received from the VB news group.
Thanks for the help in advance
James Cameron
|
by: S. van Beek |
last post by:
Dear reader,
I still have a problem with my reference libraries.
In my frond end application a check procedure for missing references is
available.
The problem I confronted with is that in case there is a missing reference
|
by: Dave |
last post by:
I'm building a research application that needs to be a super speed demon. I
decided that one way to do this is to use goto loops instead of while()
loops when I need them. that way, instead of checking the variable inside
the while() all it has to do is continue looping until another goto
statement is used to change the direction of the program. the problem I ran
into is that I can't call a goto statement from one function when the place...
|
by: Bryan |
last post by:
I have a multi-threaded C# console application that uses WMI
(System.Management namespace) to make RPC calls to several servers (600+ )
and returns ScheduledJobs. The section of my code that performs the query
is contained in a delegate function that I execute via a second thread. On 1
or 2 of the 600+ servers the query hangs. I've tried to use Thread.Join()
coupled with a Thread.Abort() but this does not kill the thread.
Based on...
|
by: TPJ |
last post by:
Help me please, because I really don't get it. I think it's some stupid
mistake I make, but I just can't find it. I have been thinking about it
for three days so far and I still haven't found any solution.
My code can be downloaded from here:
http://www.tprimke.net/konto/PyObject-problem.tar.bz2. There are some
scripts for GNU/Linux system (bash to be precise).
All you need to know is that there are four classes. (Of course, you
may...
| |
by: garry.oxnard |
last post by:
Can anyone help me to solve a problem which involves switching from
Access to Excel (then back to Access) programatically please?
I have an Excel template which, on open, also opens an Access database
- containing a list of addresses.
Sequence of events is =
(1) Excel template opens in its default XXX.xls filename.
(2) Code runs to save the spreadsheet as XXX.xls.
(3) User clicks a button to open an Access database containing an
|
by: rdemyan via AccessMonster.com |
last post by:
I have a need to add another field to all of my tables (over 150). Not data,
but an actual field.
Can I code this somehow. So the code presumabley would loop through all the
tables, open each table in design mode and then add the new field and set its
properties.
Thanks.
--
|
by: Jon Skeet [C# MVP] |
last post by:
I'm sure the net will be buzzing with this news fairly soon, but just
in case anyone hasn't seen it yet:
Microsoft are going to make the source code for the .NET framework
(parts of it, including the BCL, ASP.NET and LINQ) available both for
viewing and debugging into.
I won't go into all the details here, as they're covered on Scott
Guthrie's blog:
|
by: Brett |
last post by:
I wrote an ASP.NET application that queries a SQL Server database (on a
different box from the web server) and displays the result in a GridView.
The datasource for the GridView is a SQLDataSource. Just to get it to work,
I hard-coded the username and password of a SQL Server account in the
connectionstring in web.config. Once I confirmed that this worked on the
web server, I wanted to remove the hard-coded password from web.config, so I...
|
by: Gord |
last post by:
When I open a certain report, it runs some code that generates the records
that will be displayed in that report. This works fine. When I go to print
preview the report it appears that the code is run again? This is causing
certain error problems.
1 Why does the code run for a print preview when the report already
exists?
2 What command do I use in code to find out if a report (or any other
object for that matter) is already...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |