Showing newest 52 of 526 posts from March 2009. Show older posts
Showing newest 52 of 526 posts from March 2009. Show older posts

Tuesday, March 31, 2009

[DotNetDevelopment] Re: Invalid Data Type Check in Stored Procedure

Use SqlParameters with the DbType set either via constructor or by
setting the property.

On Mar 31, 10:53 pm, Aman Sharma <kajubadam25...@gmail.com> wrote:
> Hi,
>
> *MS SqlServer2005 - Stored Procedure*
>
> Is it possible to check for Invalid Data Type in SP? For eg:- String is
> passed into SP rather Integer.

[DotNetDevelopment] Re: querying XML for user login

I completely agree! Good one, Joe.

On Mar 31, 11:03 pm, Joe Enos <j...@jtenos.com> wrote:
> == is not the equals operator in VB.NET.
>
> @Brock:
> I believe your code is not compiling because you're trying to compare
> a string to a textbox, not the contents of the textbox:
> (email = txtEmailAddress And password = txtPassword)
> should be
> (email = txtEmailAddress.Text And password = txtPassword.Text)
>
> FYI: There are better ways of accomplishing this rather than a dataset
> - XPath, serialization, etc.
> Also, I don't think it matters in this case, but it's good practice to
> keep case correct - when retrieving values from your dataset, the
> column names are capitalized differently from the XML element names.
>

[DotNetDevelopment] Re: webservice issue

I doubt if this is a "Webservice issue" per se. You haven't shown us
the code or told us what the "attendi" function does with the
reference to the WebBrowser, so I can only make a guess as to the
possibilities -

It seems possible that the "attendi" function raises an unhandled
exception which causes the value of b to be never set to 0. This means
that in the HelloWorld function, the code will be stuck in the While-
End While loop indefinitely. This would explain the Timeout. You might
also consider using a Thread.Sleep(0) along with DoEvents() to
relinquish the CPU just long enough to allow the other thread to be
executed.

To be sure, why don't you debug the webservice app and find out where
the code gets stuck and why?


On Mar 31, 11:16 pm, Alcibiade <panda...@libero.it> wrote:
> Hi, I've written following code but I dont' receive answer with
> helloworld call, I obtain timeout after 1 minute. any suggestion?
> Thanks
>
> Public Class Service1
>     Inherits System.Web.Services.WebService
>
>     <WebMethod()> _
>      Public Function HelloWorld() As String
>         Try
> 'a and b are declared in a module as public
>             Dim tred As New Threading.Thread(AddressOf invita)
>             b = 1
>             tred.SetApartmentState(Threading.ApartmentState.STA)
>             tred.Start()
>             While b = 1
>                 Windows.Forms.Application.DoEvents()
>             End While
>             Return a
>         Catch ex As Exception
>             Return ex.Message
>         End Try
>     End Function
>
>     Public Sub invita()
>         Try
>             Dim WebBrowser1 As WebBrowser = New WebBrowser
>             WebBrowser1.Navigate("http://www.google.it")
>             attendi(WebBrowser1)
>             a = WebBrowser1.DocumentText
>             b = 0
>         Catch ex As Exception
>           a=ex.message
>           b=0
>         End Try
>     End Sub
>
>     <WebMethod()> _
>      Public Function name(ByVal d As String) As String
>         Return "hi " & d
>     End Function

[DotNetDevelopment] Re: querying XML for user login

THANKS!! (almost got it working - only works on the first "record" in
the XML file - not iterating (email = txtEmailAddress.Text And
password = txtPassword.Text) that got it to compile

ALSO I had a basic logic error in that I needed the login results
IfThen blocks to be inside the main IfThen of the Sub like this:

Private Sub btnLogin_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnLogin.Click
Dim ds As DataSet = New DataSet
ds.ReadXml(MapPath("members.xml"))
Dim email As String = ""
Dim password As String = ""

If ds.Tables(0).Rows.Count > 0 Then
email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
password = ds.Tables(0).Rows(0)("Password").ToString()

If (email = txtEmailAddress.Text And password =
txtPassword.Text) Then
lblLoginFailure.Visible = True
lblLoginFailure.Text = "Welcome to Our Site."
Else
lblLoginFailure.Visible = True
lblLoginFailure.Text = "Email Address and/or Password
are incorrect. Please try again."
End If

End If

End Sub

On Mar 31, 2:03 pm, Joe Enos <j...@jtenos.com> wrote:
> == is not the equals operator in VB.NET.
>
> @Brock:
> I believe your code is not compiling because you're trying to compare
> a string to a textbox, not the contents of the textbox:
> (email = txtEmailAddress And password = txtPassword)
> should be
> (email = txtEmailAddress.Text And password = txtPassword.Text)
>
> FYI: There are better ways of accomplishing this rather than a dataset
> - XPath, serialization, etc.
> Also, I don't think it matters in this case, but it's good practice to
> keep case correct - when retrieving values from your dataset, the
> column names are capitalized differently from the XML element names.
>
> On Mar 31, 9:49 am, "Stephen Russell" <sruss...@lotmate.com> wrote:
>
>
>
> > == instead of =  
>
> > .........................
> > Stephen Russell -
> > Senior Visual Studio Developer, DBA
>
> > Memphis, TN
> > 901.246-0159
>
> > > -----Original Message-----
> > > From: DotNetDevelopment@googlegroups.com
> > > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> > > Sent: Tuesday, March 31, 2009 10:55 AM
> > > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > > Services,.NET Remoting
> > > Subject: [DotNetDevelopment] querying XML for user login
>
> > > I'm trying to use an XML file like below for users to login to my
> > > website. I have some code started below, but I'm sure there's a better
> > > way. "(email = txtEmailAddress And password = txtPassword)" does not
> > > compile.
>
> > > <?xml version="1.0" standalone="yes"?>
> > > <members>
> > >   <member>
> > >     <firstName>Ralph</firstName>
> > >     <lastName>Ward</lastName>
> > >     <emailAddress>ralphcolvetw...@hotmail.com</emailAddress>
> > >     <password>1920</password>
> > >   </member>
> > > </members>
>
> > >  Private Sub btnLogin_Click(ByVal sender As System.Object, _
> > >     ByVal e As System.EventArgs) Handles btnLogin.Click
>
> > >         Dim ds As DataSet = New DataSet
> > >         ds.ReadXml(MapPath("members.xml"))
> > >         Dim email As String = ""
> > >         Dim password As String = ""
>
> > >         If ds.Tables(0).Rows.Count > 0 Then
> > >             email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
> > >             password = ds.Tables(0).Rows(0)("Password").ToString()
> > >         End If
>
> > >         If (email = txtEmailAddress And password = txtPassword) Then
> > >             lblLoginFailure.Visible = True
> > >             lblLoginFailure.Text = "Welcome to Our Site."
> > >         Else
> > >             lblLoginFailure.Visible = True
> > >             lblLoginFailure.Text = "Email Address and/or Password are
> > > incorrect. Please try again."
> > >         End If
> > > End Sub
>
> > > No virus found in this incoming message.
> > > Checked by AVG -www.avg.com
> > > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > > 03/31/09 06:02:00- Hide quoted text -
>
> - Show quoted text -

[DotNetDevelopment] Re: querying XML for user login

THANKS!! (email = txtEmailAddress.Text And password =
txtPassword.Text) that got it to compile

ALSO I had a basic logic error in that I needed the login results
IfThen blocks to be inside the main IfThen of the Sub like this (which
is working perfectly now):

Private Sub btnLogin_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnLogin.Click
Dim ds As DataSet = New DataSet
ds.ReadXml(MapPath("members.xml"))
Dim email As String = ""
Dim password As String = ""

If ds.Tables(0).Rows.Count > 0 Then
email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
password = ds.Tables(0).Rows(0)("Password").ToString()

If (email = txtEmailAddress.Text And password =
txtPassword.Text) Then
lblLoginFailure.Visible = True
lblLoginFailure.Text = "Welcome to Our Site."
Else
lblLoginFailure.Visible = True
lblLoginFailure.Text = "Email Address and/or Password
are incorrect. Please try again."
End If

End If

End Sub

On Mar 31, 2:03 pm, Joe Enos <j...@jtenos.com> wrote:
> == is not the equals operator in VB.NET.
>
> @Brock:
> I believe your code is not compiling because you're trying to compare
> a string to a textbox, not the contents of the textbox:
> (email = txtEmailAddress And password = txtPassword)
> should be
> (email = txtEmailAddress.Text And password = txtPassword.Text)
>
> FYI: There are better ways of accomplishing this rather than a dataset
> - XPath, serialization, etc.
> Also, I don't think it matters in this case, but it's good practice to
> keep case correct - when retrieving values from your dataset, the
> column names are capitalized differently from the XML element names.
>
> On Mar 31, 9:49 am, "Stephen Russell" <sruss...@lotmate.com> wrote:
>
>
>
> > == instead of =  
>
> > .........................
> > Stephen Russell -
> > Senior Visual Studio Developer, DBA
>
> > Memphis, TN
> > 901.246-0159
>
> > > -----Original Message-----
> > > From: DotNetDevelopment@googlegroups.com
> > > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> > > Sent: Tuesday, March 31, 2009 10:55 AM
> > > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > > Services,.NET Remoting
> > > Subject: [DotNetDevelopment] querying XML for user login
>
> > > I'm trying to use an XML file like below for users to login to my
> > > website. I have some code started below, but I'm sure there's a better
> > > way. "(email = txtEmailAddress And password = txtPassword)" does not
> > > compile.
>
> > > <?xml version="1.0" standalone="yes"?>
> > > <members>
> > >   <member>
> > >     <firstName>Ralph</firstName>
> > >     <lastName>Ward</lastName>
> > >     <emailAddress>ralphcolvetw...@hotmail.com</emailAddress>
> > >     <password>1920</password>
> > >   </member>
> > > </members>
>
> > >  Private Sub btnLogin_Click(ByVal sender As System.Object, _
> > >     ByVal e As System.EventArgs) Handles btnLogin.Click
>
> > >         Dim ds As DataSet = New DataSet
> > >         ds.ReadXml(MapPath("members.xml"))
> > >         Dim email As String = ""
> > >         Dim password As String = ""
>
> > >         If ds.Tables(0).Rows.Count > 0 Then
> > >             email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
> > >             password = ds.Tables(0).Rows(0)("Password").ToString()
> > >         End If
>
> > >         If (email = txtEmailAddress And password = txtPassword) Then
> > >             lblLoginFailure.Visible = True
> > >             lblLoginFailure.Text = "Welcome to Our Site."
> > >         Else
> > >             lblLoginFailure.Visible = True
> > >             lblLoginFailure.Text = "Email Address and/or Password are
> > > incorrect. Please try again."
> > >         End If
> > > End Sub
>
> > > No virus found in this incoming message.
> > > Checked by AVG -www.avg.com
> > > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > > 03/31/09 06:02:00- Hide quoted text -
>
> - Show quoted text -

[DotNetDevelopment] webservice issue

Hi, I've written following code but I dont' receive answer with
helloworld call, I obtain timeout after 1 minute. any suggestion?
Thanks

Public Class Service1
Inherits System.Web.Services.WebService

<WebMethod()> _
Public Function HelloWorld() As String
Try
'a and b are declared in a module as public
Dim tred As New Threading.Thread(AddressOf invita)
b = 1
tred.SetApartmentState(Threading.ApartmentState.STA)
tred.Start()
While b = 1
Windows.Forms.Application.DoEvents()
End While
Return a
Catch ex As Exception
Return ex.Message
End Try
End Function


Public Sub invita()
Try
Dim WebBrowser1 As WebBrowser = New WebBrowser
WebBrowser1.Navigate("http://www.google.it")
attendi(WebBrowser1)
a = WebBrowser1.DocumentText
b = 0
Catch ex As Exception
a=ex.message
b=0
End Try
End Sub

<WebMethod()> _
Public Function name(ByVal d As String) As String
Return "hi " & d
End Function

[DotNetDevelopment] Re: querying XML for user login

== is not the equals operator in VB.NET.

@Brock:
I believe your code is not compiling because you're trying to compare
a string to a textbox, not the contents of the textbox:
(email = txtEmailAddress And password = txtPassword)
should be
(email = txtEmailAddress.Text And password = txtPassword.Text)

FYI: There are better ways of accomplishing this rather than a dataset
- XPath, serialization, etc.
Also, I don't think it matters in this case, but it's good practice to
keep case correct - when retrieving values from your dataset, the
column names are capitalized differently from the XML element names.

On Mar 31, 9:49 am, "Stephen Russell" <sruss...@lotmate.com> wrote:
> == instead of =  
>
> .........................
> Stephen Russell -
> Senior Visual Studio Developer, DBA
>
> Memphis, TN
> 901.246-0159
>
> > -----Original Message-----
> > From: DotNetDevelopment@googlegroups.com
> > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> > Sent: Tuesday, March 31, 2009 10:55 AM
> > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > Services,.NET Remoting
> > Subject: [DotNetDevelopment] querying XML for user login
>
> > I'm trying to use an XML file like below for users to login to my
> > website. I have some code started below, but I'm sure there's a better
> > way. "(email = txtEmailAddress And password = txtPassword)" does not
> > compile.
>
> > <?xml version="1.0" standalone="yes"?>
> > <members>
> >   <member>
> >     <firstName>Ralph</firstName>
> >     <lastName>Ward</lastName>
> >     <emailAddress>ralphcolvetw...@hotmail.com</emailAddress>
> >     <password>1920</password>
> >   </member>
> > </members>
>
> >  Private Sub btnLogin_Click(ByVal sender As System.Object, _
> >     ByVal e As System.EventArgs) Handles btnLogin.Click
>
> >         Dim ds As DataSet = New DataSet
> >         ds.ReadXml(MapPath("members.xml"))
> >         Dim email As String = ""
> >         Dim password As String = ""
>
> >         If ds.Tables(0).Rows.Count > 0 Then
> >             email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
> >             password = ds.Tables(0).Rows(0)("Password").ToString()
> >         End If
>
> >         If (email = txtEmailAddress And password = txtPassword) Then
> >             lblLoginFailure.Visible = True
> >             lblLoginFailure.Text = "Welcome to Our Site."
> >         Else
> >             lblLoginFailure.Visible = True
> >             lblLoginFailure.Text = "Email Address and/or Password are
> > incorrect. Please try again."
> >         End If
> > End Sub
>
> > No virus found in this incoming message.
> > Checked by AVG -www.avg.com
> > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > 03/31/09 06:02:00

[DotNetDevelopment] Invalid Data Type Check in Stored Procedure

Hi,
 
MS SqlServer2005 - Stored Procedure
 
Is it possible to check for Invalid Data Type in SP? For eg:- String is passed into SP rather Integer.
 
 
 

[DotNetDevelopment] Number format

Hi,

In a GridView how can I format a number as follows?
Show a dash (-) if the value is 0
Show negative numbers in brackets
Show a trailing space if the value is positive
?

Thanks in advance!

[DotNetDevelopment] Re: Delete records from Grid

Just call
 
Grid1.DataSource=Nothing
Grid1.DataBind()

2009/3/31 Jeena Ajiesh <jeenajos@gmail.com>
Hi all,
I had currently some rows in datagrid,,wen i click deleteall button all the records displayed in grid should be deleted..
How can i do this?
I tried to take the count of rows and delete it using delete function
Eg: Grid1.DeleteRow(i) --- this is in While loop.
 
But it failed. i think i had wrongly coded.
Can anyone help me out this situation?

--
****************
Regards,
♪♥♫♥Ĵєєήǎ ♫♥♪♥
Email: jeena.jos@hotmail.com
         jeenajos@gmail.com
         jeena007_jk@yahoo.co.in




--
Regards
*******************
*C.Arun Kumar *
*******************



[DotNetDevelopment] Page Template

Hi,

does anybody know a Page Templating framework for ASP.NET like Tiles for Java?

Thanks!

--
Ramon Pereira Lopes

[DotNetDevelopment] Re: querying XML for user login

The compiler likes the second "==" but not the first "==" 'says
Expression expected

If (email == txtEmailAddress And password == txtPassword) Then

On Mar 31, 12:49 pm, "Stephen Russell" <sruss...@lotmate.com> wrote:
> == instead of =  
>
> .........................
> Stephen Russell -
> Senior Visual Studio Developer, DBA
>
> Memphis, TN
> 901.246-0159
>
>
>
> > -----Original Message-----
> > From: DotNetDevelopment@googlegroups.com
> > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> > Sent: Tuesday, March 31, 2009 10:55 AM
> > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > Services,.NET Remoting
> > Subject: [DotNetDevelopment] querying XML for user login
>
> > I'm trying to use an XML file like below for users to login to my
> > website. I have some code started below, but I'm sure there's a better
> > way. "(email = txtEmailAddress And password = txtPassword)" does not
> > compile.
>
> > <?xml version="1.0" standalone="yes"?>
> > <members>
> >   <member>
> >     <firstName>Ralph</firstName>
> >     <lastName>Ward</lastName>
> >     <emailAddress>ralphcolvetw...@hotmail.com</emailAddress>
> >     <password>1920</password>
> >   </member>
> > </members>
>
> >  Private Sub btnLogin_Click(ByVal sender As System.Object, _
> >     ByVal e As System.EventArgs) Handles btnLogin.Click
>
> >         Dim ds As DataSet = New DataSet
> >         ds.ReadXml(MapPath("members.xml"))
> >         Dim email As String = ""
> >         Dim password As String = ""
>
> >         If ds.Tables(0).Rows.Count > 0 Then
> >             email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
> >             password = ds.Tables(0).Rows(0)("Password").ToString()
> >         End If
>
> >         If (email = txtEmailAddress And password = txtPassword) Then
> >             lblLoginFailure.Visible = True
> >             lblLoginFailure.Text = "Welcome to Our Site."
> >         Else
> >             lblLoginFailure.Visible = True
> >             lblLoginFailure.Text = "Email Address and/or Password are
> > incorrect. Please try again."
> >         End If
> > End Sub
>
> > No virus found in this incoming message.
> > Checked by AVG -www.avg.com
> > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > 03/31/09 06:02:00- Hide quoted text -
>
> - Show quoted text -

[DotNetDevelopment] Re: querying XML for user login

== instead of =

.........................
Stephen Russell -
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159

> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> Sent: Tuesday, March 31, 2009 10:55 AM
> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting
> Subject: [DotNetDevelopment] querying XML for user login
>
>
> I'm trying to use an XML file like below for users to login to my
> website. I have some code started below, but I'm sure there's a better
> way. "(email = txtEmailAddress And password = txtPassword)" does not
> compile.
>
> <?xml version="1.0" standalone="yes"?>
> <members>
> <member>
> <firstName>Ralph</firstName>
> <lastName>Ward</lastName>
> <emailAddress>ralphcolvetward@hotmail.com</emailAddress>
> <password>1920</password>
> </member>
> </members>
>
>
> Private Sub btnLogin_Click(ByVal sender As System.Object, _
> ByVal e As System.EventArgs) Handles btnLogin.Click
>
> Dim ds As DataSet = New DataSet
> ds.ReadXml(MapPath("members.xml"))
> Dim email As String = ""
> Dim password As String = ""
>
> If ds.Tables(0).Rows.Count > 0 Then
> email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
> password = ds.Tables(0).Rows(0)("Password").ToString()
> End If
>
> If (email = txtEmailAddress And password = txtPassword) Then
> lblLoginFailure.Visible = True
> lblLoginFailure.Text = "Welcome to Our Site."
> Else
> lblLoginFailure.Visible = True
> lblLoginFailure.Text = "Email Address and/or Password are
> incorrect. Please try again."
> End If
> End Sub
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/31/09 06:02:00

[DotNetDevelopment] Re: Generating Excel report using ASP.NET and C#

I have to kick out a few loader files for another outside app from my site.
I'll give you the steps I used to NOT USE EXCEL on the server!!!!

…………………………………………………………………
Stephen Russell –
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159

> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of stapes
> Sent: Tuesday, March 31, 2009 3:37 AM
> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting
> Subject: [DotNetDevelopment] Re: Generating Excel report using ASP.NET
> and C#
>
>
> Server has installed programs:
>
> Microsoft Office 2003 Web Components
> Microsoft Office 2007 Primary Interop Assemblies
> Microsoft Office Enterprise 2007
>
> On Mar 30, 6:30 pm, "Stephen Russell" <sruss...@lotmate.com> wrote:
> > Office is not loaded on the server?
> >
> > .........................
> > Stephen Russell -
> > Senior Visual Studio Developer, DBA
> >
> > Memphis, TN
> > 901.246-0159
> >
> >
> >
> > > -----Original Message-----
> > > From: DotNetDevelopment@googlegroups.com
> > > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of stapes
> > > Sent: Monday, March 30, 2009 5:12 AM
> > > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
> Web
> > > Services,.NET Remoting
> > > Subject: [DotNetDevelopment] Generating Excel report using ASP.NET
> and
> > > C#
> >
> > > This works OK on my development machine, but when I try to run it
> on
> > > the live server, I get this error:
> >
> > > System.Runtime.InteropServices.COMException (0x80080005):
> Retrieving
> > > the COM class factory for component with CLSID {00024500-0000-0000-
> > > C000-000000000046} failed due to the following error: 80080005 at
> > > Web_Reports_KPI.excelKPIS() in c:\inetpub\wwwroot\AGwww\Web_Reports
> > > \KPI.aspx.cs:line 67
> >
> > > Line 67: MyExcel.Application excelApp = new
> MyExcel.ApplicationClass
> > > ();
> >
> > > MyExcel is defined at the top: using MyExcel =
> > > Microsoft.Office.Interop.Excel;
> >
> > > I also have references: Microsoft Excel 12.0 Object Library,
> Microsoft
> > > Office 10.0 Object Library, Microsoft Office 11.0 Object Libray,
> > > Microsoft Office 12 Object Library,
> Microsoft.Office.Interop.Word.dll
> >
> > > I have used Component Services / DCOM Config to set permssions for
> > > Microsoft Excel Application. In the Launch and Activation
> permissions
> > > I have added NETWORK SERVICE and Evereyone. Same for Access
> Permssions
> > > and Configuration Permissions. Did not make any difference.
> >
> > > Does anyone have any clues?
> >
> > > No virus found in this incoming message.
> > > Checked by AVG -www.avg.com
> > > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > > 03/29/09 16:56:00- Hide quoted text -
> >
> > - Show quoted text -
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/30/09 08:40:00

[DotNetDevelopment] Re: Jump cursor to beginning/end of code block

The FindBrace() macro posted above does what I need. I replaced the
hard-coded IF/ENDIF with two string arrays, and now it works for IF,
WITH, SELECT CASE, FOR, DO and TRY.

Thanks!

On Mar 20, 4:11 am, Cerebrus <zorg...@sify.com> wrote:
> I wish there was... one like the Ctrl+] shortcut in C# which allows
> you to move between matching braces.
>
> However, I found a macro some time back that I use personally. Feel
> free to use it for your own convenience.
>
> ---
> Public Module Kbd
>
>   Private Function CleanLine(ByVal sLine As String) As String
>     sLine = sLine.ToUpper
>     sLine = sLine.Replace(vbTab, "")
>     sLine = sLine.Trim()
>     Return sLine
>   End Function
>
>   Sub FindBrace()
>     Dim bFoward As Boolean
>     Dim bIfCount As Integer = 1
>     Dim o As TextSelection = DTE.ActiveDocument.Selection
>     Dim sLine As String
>     o.DTE.SuppressUI = True
>     o.StartOfLine(vsStartOfLineOptions.vsStartOfLineOptionsFirstText)
>     o.SelectLine()
>     sLine = CleanLine(o.Text)
>
>     Select Case True
>       Case sLine.StartsWith("IF ")
>         bFoward = True
>       Case sLine.StartsWith("END IF")
>       Case Else
>         Exit Sub
>     End Select
>
>     Do
>       If bFoward Then
>         o.LineDown(False, 0)
>       Else
>         o.LineUp(False, 1)
>       End If
>       o.SelectLine()
>       sLine = CleanLine(o.Text)
>
>       Select Case True
>         Case sLine.StartsWith("IF ")
>           If bFoward Then
>             bIfCount += 1
>           Else
>             bIfCount -= 1
>           End If
>         Case sLine.StartsWith("END IF")
>           If bFoward Then
>             bIfCount -= 1
>           Else
>             bIfCount += 1
>           End If
>       End Select
>     Loop Until bIfCount = 0
>
>     o.StartOfLine(vsStartOfLineOptions.vsStartOfLineOptionsFirstText)
>     o.LineUp(False, 1)
>     o.StartOfLine(vsStartOfLineOptions.vsStartOfLineOptionsFirstText)
>   End Sub
>
> End Module
>
> ---
>
> On Mar 20, 12:33 am, jtaylor <jtay...@lorencook.com> wrote:
>
> > In VB.NET (VS 2005), is there any way to jump from the beginning to
> > the end (or vice versa) of a code block?  For example, put your cursor
> > on an If and jump to the Endif.

[DotNetDevelopment] querying XML for user login

I'm trying to use an XML file like below for users to login to my
website. I have some code started below, but I'm sure there's a better
way. "(email = txtEmailAddress And password = txtPassword)" does not
compile.

<?xml version="1.0" standalone="yes"?>
<members>
<member>
<firstName>Ralph</firstName>
<lastName>Ward</lastName>
<emailAddress>ralphcolvetward@hotmail.com</emailAddress>
<password>1920</password>
</member>
</members>


Private Sub btnLogin_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnLogin.Click

Dim ds As DataSet = New DataSet
ds.ReadXml(MapPath("members.xml"))
Dim email As String = ""
Dim password As String = ""

If ds.Tables(0).Rows.Count > 0 Then
email = ds.Tables(0).Rows(0)("EmailAddress").ToString()
password = ds.Tables(0).Rows(0)("Password").ToString()
End If

If (email = txtEmailAddress And password = txtPassword) Then
lblLoginFailure.Visible = True
lblLoginFailure.Text = "Welcome to Our Site."
Else
lblLoginFailure.Visible = True
lblLoginFailure.Text = "Email Address and/or Password are
incorrect. Please try again."
End If
End Sub

[DotNetDevelopment] Re: Click once in C#.Net

Is that a web server and not a file server? You may have rights issues??

.........................
Stephen Russell -
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159

> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Dhanan
> Sent: Tuesday, March 31, 2009 4:52 AM
> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting
> Subject: [DotNetDevelopment] Click once in C#.Net
>
>
> I hve publish my application at server using the click once but it is
> not accebile at client hw i can do this..?
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/31/09 06:02:00

[DotNetDevelopment] Re: client-side password validation (matching)

Most welcome! I'm glad you found it useful. :-)

On Mar 31, 8:42 pm, Brock <wade.br...@yahoo.com> wrote:
> The asp:CompareValidator works perfectly... thanks!
>
> (for those referencing this make sure that ControlToCompare is your
> Password and ControlToValidate is the "Retype Password")
>
>                                                  <asp:CompareValidator
> ID="validPassword"
>                                                    runat="server"
>
> ControlToValidate="txtRetype"
>
> ControlToCompare="txtPassword"
>                                                    ForeColor="red"
>                                                    Font-Bold="True"
>                                                    BackColor="yellow"
>                                                    Type="String"
>
> EnableClientScript="True"
>
> ErrorMessage="Passwords do not match! Please retype." Font-
> Size="Small" Height="34px"
>                                                       style="text-
> align: center" Width="220px"/>
>
> On Mar 30, 11:07 am, Cerebrus <zorg...@sify.com> wrote:
>
>
>
> > Well, if you're using ASP.NET, M$ has been good enough to provide a
> > CompareValidator control for this very purpose. It encapsulates the
> > Javascript required to compare the value of one control to another.
> > The most common use of this control is for the Password-Confirm
> > Password textboxes.
>
> > Here is a basic tutorial on using the CompareValidator <http://www.w3schools.com/aspnet/control_comparevalidator.asp>. And another:
> > <http://asp.net-tutorials.com/validation/compare-validator/>
>
> > On Mar 30, 7:08 pm, Brock <wade.br...@yahoo.com> wrote:
>
> > > What is my best way (client-side of course) on an .aspx page to
> > > compare the value in the "Password" textbox with that of the "Retype
> > > Password" textbox? Javascript? Any source code examples anyone knows
> > > would be helpful - javascript is still rather foreign to me.  Thanks!- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

[DotNetDevelopment] Re: client-side password validation (matching)

The asp:CompareValidator works perfectly... thanks!

(for those referencing this make sure that ControlToCompare is your
Password and ControlToValidate is the "Retype Password")

<asp:CompareValidator
ID="validPassword"
runat="server"

ControlToValidate="txtRetype"

ControlToCompare="txtPassword"
ForeColor="red"
Font-Bold="True"
BackColor="yellow"
Type="String"

EnableClientScript="True"

ErrorMessage="Passwords do not match! Please retype." Font-
Size="Small" Height="34px"
style="text-
align: center" Width="220px"/>

On Mar 30, 11:07 am, Cerebrus <zorg...@sify.com> wrote:
> Well, if you're using ASP.NET, M$ has been good enough to provide a
> CompareValidator control for this very purpose. It encapsulates the
> Javascript required to compare the value of one control to another.
> The most common use of this control is for the Password-Confirm
> Password textboxes.
>
> Here is a basic tutorial on using the CompareValidator <http://www.w3schools.com/aspnet/control_comparevalidator.asp>. And another:
> <http://asp.net-tutorials.com/validation/compare-validator/>
>
> On Mar 30, 7:08 pm, Brock <wade.br...@yahoo.com> wrote:
>
>
>
> > What is my best way (client-side of course) on an .aspx page to
> > compare the value in the "Password" textbox with that of the "Retype
> > Password" textbox? Javascript? Any source code examples anyone knows
> > would be helpful - javascript is still rather foreign to me.  Thanks!- Hide quoted text -
>
> - Show quoted text -

[DotNetDevelopment] Re: COM issue with Unit Tests

Nevermind. Found the problem. The COM component is a plugin for
other software that was running in a background process in the
application. That process hadn't been started in the unit tests.

On Mar 30, 6:18 pm, dsheiner <daniel...@gmail.com> wrote:
> Hi,
>
> I have a C# .NET 2.0 project with a class that makes use of a COM
> component.  If I attempt to run a unit test in visual studio 2008, as
> soon as an object of this class reaches code to call the constructor
> of the COM object, I get an exception:
>
> System.Runtime.InteropServices.COMException: Retrieving the COM class
> factory for component with CLSID {47B7DFA4-6687-4AEA-AA68-
> A140107B4858} failed due to the following error: 80040154.
>
> However, if I set a break point in an application using the same
> class, the exact line of code that throws the exception in unit
> testing works without any problems.
>
> Any idea why this exception's only getting thrown in the unit test?
>
> Thanks,
> Daniel Sheiner

[DotNetDevelopment] [WCF] The underlying connection was closed: The connection was closed unexpectedly.

Hi,

When I call a method of my WCF service which returns a simple entity
with a few properties, it works fine.

However when I call a method which returns a more complex entity,
which holds a collection of other entities, then I get the exception I
mentioned in the title.

I've used the following in the client app.config :

<system.serviceModel>
<bindings>
<basicHttpBinding>
<binding name="BasicHttpBinding_IMetricaService"
closeTimeout="00:01:00"
openTimeout="00:01:00" receiveTimeout="00:10:00"
sendTimeout="00:01:00"
allowCookies="false" bypassProxyOnLocal="false"
hostNameComparisonMode="StrongWildcard"
maxBufferSize="65536" maxBufferPoolSize="524288"
maxReceivedMessageSize="65536"
messageEncoding="Text" textEncoding="utf-8"
transferMode="Buffered"
useDefaultWebProxy="true">
<readerQuotas maxDepth="32"
maxStringContentLength="8192" maxArrayLength="16384"
maxBytesPerRead="4096"
maxNameTableCharCount="16384" />
<security mode="None">
<transport clientCredentialType="None"
proxyCredentialType="None"
realm="" />
<message clientCredentialType="UserName"
algorithmSuite="Default" />
</security>
</binding>

<binding
name="BasicHttpBinding_IncreasedMessageSize_Buffered"
closeTimeout="00:01:00" openTimeout="00:01:00"
receiveTimeout="00:05:00" sendTimeout="00:05:00"
transferMode="Streamed" maxBufferSize="524288"
maxReceivedMessageSize="2147483647">
<readerQuotas maxDepth="2147483647"
maxStringContentLength="2147483647" maxArrayLength="2147483647"
maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />

</binding>
</basicHttpBinding>
</bindings>
<client>
<endpoint address="http://localhost:4820/Service.svc"
binding="basicHttpBinding"

bindingConfiguration="BasicHttpBinding_IMetricaService"
contract="ServiceReference1.IMetricaService"
name="BasicHttpBinding_IMetricaService"
behaviorConfiguration="debuggingBehaviour" />
</client>

<behaviors>
<endpointBehaviors>
<behavior name="debuggingBehaviour">
<dataContractSerializer maxItemsInObjectGraph="2147483647"/
>
</behavior>
</endpointBehaviors>
</behaviors>
</system.serviceModel>


When I instantiate my service using the
BasicHttpBinding_IMetricaService binding, I get the exception.

However if I instantiate my service using the
BasicHttpBinding_IncreasedMessageSize_Buffered (recommended on a few
blogs out there), I get the following exception :

The remote server returned an unexpected response: (400) Bad Request.


On the service side, the web.config looks like :

<system.serviceModel>
<services>
<service name="metricaService"
behaviorConfiguration="DefaultBehavior">
<endpoint address="" binding="basicHttpBinding"
contract="Metrica.Service.ServiceContract.IMetricaService"
bindingConfiguration="BasicHttpBinding_IncreasedMessageSize_Buffered" /
>
<endpoint address="mex" binding="mexHttpBinding"
contract="IMetadataExchange" />
</service>
</services>
<behaviors>
<serviceBehaviors>
<behavior name="DefaultBehavior">
<dataContractSerializer maxItemsInObjectGraph="2147483647"/>
<serviceMetadata httpGetEnabled="True"/>
<serviceDebug includeExceptionDetailInFaults="True"/>
</behavior>
</serviceBehaviors>
</behaviors>
<bindings>
<basicHttpBinding>
<binding name="BasicHttpBinding_IncreasedMessageSize_Buffered"
maxBufferSize="524288"
maxReceivedMessageSize="2147483647"
closeTimeout="00:01:00" openTimeout="00:01:00"
receiveTimeout="00:05:00"
sendTimeout="00:05:00" transferMode="Streamed">
<readerQuotas maxDepth="2147483647"
maxStringContentLength="2147483647"
maxArrayLength="2147483647" maxBytesPerRead="2147483647"
maxNameTableCharCount="2147483647" />
</binding>
</basicHttpBinding>
</bindings>
</system.serviceModel>

and I've also specified :

<httpRuntime maxRequestLength="2097151"/>


Anyone has an idea what could be wrong with the above ?

Thanks

[DotNetDevelopment] CRUD Creator

Hey Guys,

I would like to know if there is some framework/component that generates CRUD(Create/Retrieve/Update/Delete) operation automatically on asp.net.
I used to program on Netbeans that has a feature that based on database tables creates either desktop application or jsf application.

I am not sure, but I've heard something about "asp.net dynamic data", but it seems to work on SQL Server. The project will work on PostgreSQL.

Thanks!!!

--
Ramon Pereira Lopes

[DotNetDevelopment] Re: LINQ - create object from 2 tables

You will have to define the classes yourself.

[DataContract(Name = "PeopleClass", Namespace =
"http://schemas.lotmate.com/Tools/MSS/v1.0")]
public class PeopleClass
{
[DataMember(Name = "ID", Order = 1, IsRequired = true)]
public Guid ID
{
get;
set;
}
[DataMember(Name = "Name", Order = 2, IsRequired = true)]
public String Name
{
get;
set;
}

[DataMember(Name = "ClubID", Order = 3, IsRequired = true)]
public Guid ClubID
{
get;
set;
}

[DataMember(Name = "Email", Order = 2, IsRequired = true)]
public String Email
{
get;
set;
}

[DataMember(Name = "Addr1", Order = 2, IsRequired = true)]
public String Addr1
{
get;
set;
}
------------Snip

var myP = (from p in db.People
join e in db.Support
on p.ID equals e.PersonID
where p.ID == peepID
select new PeopleClass
{
ID = (Guid)p.ID,
Addr1 = p.addr1,
Addr2 = p.addr2,
City = p.city,
ClubID = (Guid)p.clubID,
Email = p.email,
Entry = (bool)p.entry,
Judge = e.judgeStatus,
Name = p.name,
St = p.st,
Steward = e.steward,
Zip = p.zip
}).First();
return myP;
}
See how I put the PeopleClass as the container?
I then fill it.
…………………………………………………………………
Stephen Russell –
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159

> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of imad
> Sent: Tuesday, March 31, 2009 1:04 AM
> To: DotNetDevelopment@googlegroups.com
> Subject: [DotNetDevelopment] Re: LINQ - create object from 2 tables
>
>
> Have you created a relationship between your tables in SQL Server???
>
>
>
>
> On Tue, Mar 31, 2009 at 4:55 PM, eddiec <edwardchalk@gmail.com> wrote:
> >
> > Hi,
> >
> > I have added a SQL Server - LINQ item to my C# asp project and have
> > created classes that correspond to the tables in my database.
> >
> > This has automatically created classes that map to the tables in the
> > database. I can instantiate instances of the classes that map
> directly
> > to a table:
> >            var Orders =
> >                from c in context.Orders
> >                where (c.OrderID.Equals(intCurrentOrder))
> >                select c;
> >
> > Can someone please advise me how I can create an object / class where
> > the class has attributes that are a join of two tables. (The Order
> > object should contain Line Items. In the database the Orders table
> and
> > LineItems table has a 1:M join.)
> >
> > For example, I have classes Order and LineItem that have been created
> > automatically through LINQ. Do I need to create a new Order class
> that
> > inherits from the Order class created automatically by LINQ and that
> > contains an array LineItems?
> >
> > cheers,
> >
> > eddiec :-)
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/30/09 08:40:00

[DotNetDevelopment] Re: Please help me to get this job! -- suggestions on research aspect in ASP.NET

 
 
Hi Cerebrus,
 
That was gud one..
 
Regards
Vignesh.R.Joshi

 
On 3/30/09, Cerebrus <zorg007@sify.com> wrote:

You're most welcome, Alex! It has been my pleasure contributing to
this discussion and it seems to have hit a chord with the group
members as well. We don't normally see so much activity within a
single thread.

As for building Custom server controls, I would consider it an
advanced topic and unlikely to be asked about in an interview. To be
honest, I myself have only basic knowledge about Control authoring
since I haven't needed to build them yet. I would suggest that you
just understand how a custom server control renders its output (for
instance, using the overridden RenderContents method to write output
to an HtmlTextWriter) and that knowledge should be sufficient. This
walkthrough should get you through the basics (http://
msdn.microsoft.com/en-us/library/yhzc935f(VS.80).aspx)

In my opinion, what is more important at this stage is to understand
how Pages work, their lifecycle, State management techniques, Master
pages and UserControls, Caching for performance, familiarity with the
various types of built-in controls, data retrieval and update
scenarios and Site configuration to name a few. At this stage, your
stress should be on understanding the .NET framework and build
familiarity with either C# or VB.

Remember that you'll always have time to delve deeper into topics that
interest you, later.

On Mar 30, 6:47 pm, Alex Y Wang <redflying...@gmail.com> wrote:
> Milo, I just don't get your point. I don't see any reason why I have
> to know ASP.NET to get my degree, and thanks again, Cerebrus.
>
> After some initial reading through the recommended books, I have a
> rough idea of learning something about building Custom Server
> Controls, because it seems fun. I know I may just have time to touch a
> small part of the subject though. Does that sound realistic? If so,
> any suggestions on how to get on track quickly on that? Thanks.
>
> Alex
>

[DotNetDevelopment] Capture GF Debug Info when Kill Process

Hello!
im working on an add-in program in VB, i want to caputure debugging information while application is running ; and the process is killed through task manager.
 
how to capture the same application information while its process is killing ..?
 
Thanks !!
 
Regards;
Aisha!!

[DotNetDevelopment] Image click and manipulation

Hi There

I have an image that the user browse and select. Once this image has been selected I want to display the image and the user clicks on the location on the image and where it was clicked I must place an x there. How can I do this is C#

Thx
Clyde

--
----------------------------------------
Kamnandi Web Hosting      
http://www.kamnandi.co.za
-------------------------------------------

[DotNetDevelopment] Click once in C#.Net

I hve publish my application at server using the click once but it is
not accebile at client hw i can do this..?

[DotNetDevelopment] hw to handle multiple clients using IIS with C#

Actually i m doing one server client application
In that I hve used the IIS and C#.net Also I hve used the Click once
method to run client Inerface on client side .
But nw i wnt to handle all clents at the same time on server so hw i
can do this?
plz tell wht I hve to do?

[DotNetDevelopment] Delete records from Grid

Hi all,
I had currently some rows in datagrid,,wen i click deleteall button all the records displayed in grid should be deleted..
How can i do this?
I tried to take the count of rows and delete it using delete function
Eg: Grid1.DeleteRow(i) --- this is in While loop.
 
But it failed. i think i had wrongly coded.
Can anyone help me out this situation?

--
****************
Regards,
♪♥♫♥Ĵєєήǎ ♫♥♪♥
Email: jeena.jos@hotmail.com
         jeenajos@gmail.com
         jeena007_jk@yahoo.co.in

[DotNetDevelopment] Re: Generating Excel report using ASP.NET and C#

Server has installed programs:

Microsoft Office 2003 Web Components
Microsoft Office 2007 Primary Interop Assemblies
Microsoft Office Enterprise 2007

On Mar 30, 6:30 pm, "Stephen Russell" <sruss...@lotmate.com> wrote:
> Office is not loaded on the server?
>
> .........................
> Stephen Russell -
> Senior Visual Studio Developer, DBA
>
> Memphis, TN
> 901.246-0159
>
>
>
> > -----Original Message-----
> > From: DotNetDevelopment@googlegroups.com
> > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of stapes
> > Sent: Monday, March 30, 2009 5:12 AM
> > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > Services,.NET Remoting
> > Subject: [DotNetDevelopment] Generating Excel report using ASP.NET and
> > C#
>
> > This works OK on my development machine, but when I try to run it on
> > the live server, I get this error:
>
> > System.Runtime.InteropServices.COMException (0x80080005): Retrieving
> > the COM class factory for component with CLSID {00024500-0000-0000-
> > C000-000000000046} failed due to the following error: 80080005 at
> > Web_Reports_KPI.excelKPIS() in c:\inetpub\wwwroot\AGwww\Web_Reports
> > \KPI.aspx.cs:line 67
>
> > Line 67: MyExcel.Application excelApp = new MyExcel.ApplicationClass
> > ();
>
> > MyExcel is defined at the top: using MyExcel =
> > Microsoft.Office.Interop.Excel;
>
> > I also have references: Microsoft Excel 12.0 Object Library, Microsoft
> > Office 10.0 Object Library, Microsoft Office 11.0 Object Libray,
> > Microsoft Office 12 Object Library, Microsoft.Office.Interop.Word.dll
>
> > I have used Component Services / DCOM Config to set permssions for
> > Microsoft Excel Application. In the Launch and Activation permissions
> > I have added NETWORK SERVICE and Evereyone. Same for Access Permssions
> > and Configuration Permissions. Did not make any difference.
>
> > Does anyone have any clues?
>
> > No virus found in this incoming message.
> > Checked by AVG -www.avg.com
> > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > 03/29/09 16:56:00- Hide quoted text -
>
> - Show quoted text -

[DotNetDevelopment] Re: Please help me to get this job! -- suggestions on research aspect in ASP.NET

I can see exactly what you mean, Cerebrus. And yes, I have to admit I
have only scratched the surface of subjects you listed. The problem
here is that they don't seem to care how 'broad' I know about ASP.NET,
or if I can build a comprehensive website on my own. They want me to
pick a 'direction' and focus on it, and the interview will most likely
to surround this direction. I chose Custom Server Control because it's
relatively low level and reveals lots of insights of ASP.NET
implementations, and challenging, of course. It's like a gamble,
really. I'll certainly check out the the site you offered to see what
I can find out :P

Alex

On Mar 30, 10:51 pm, Cerebrus <zorg...@sify.com> wrote:
> You're most welcome, Alex! It has been my pleasure contributing to
> this discussion and it seems to have hit a chord with the group
> members as well. We don't normally see so much activity within a
> single thread.
>
> As for building Custom server controls, I would consider it an
> advanced topic and unlikely to be asked about in an interview. To be
> honest, I myself have only basic knowledge about Control authoring
> since I haven't needed to build them yet. I would suggest that you
> just understand how a custom server control renders its output (for
> instance, using the overridden RenderContents method to write output
> to an HtmlTextWriter) and that knowledge should be sufficient. This
> walkthrough should get you through the basics (http://
> msdn.microsoft.com/en-us/library/yhzc935f(VS.80).aspx)
>
> In my opinion, what is more important at this stage is to understand
> how Pages work, their lifecycle, State management techniques, Master
> pages and UserControls, Caching for performance, familiarity with the
> various types of built-in controls, data retrieval and update
> scenarios and Site configuration to name a few. At this stage, your
> stress should be on understanding the .NET framework and build
> familiarity with either C# or VB.
>
> Remember that you'll always have time to delve deeper into topics that
> interest you, later.
>
> On Mar 30, 6:47 pm, Alex Y Wang <redflying...@gmail.com> wrote:
>
> > Milo, I just don't get your point. I don't see any reason why I have
> > to know ASP.NET to get my degree, and thanks again, Cerebrus.
>
> > After some initial reading through the recommended books, I have a
> > rough idea of learning something about building Custom Server
> > Controls, because it seems fun. I know I may just have time to touch a
> > small part of the subject though. Does that sound realistic? If so,
> > any suggestions on how to get on track quickly on that? Thanks.
>
> > Alex

[DotNetDevelopment] Secure File Backup and Storage

Secure File Backup and Storage

[DotNetDevelopment] Re: LINQ - create object from 2 tables

Have you created a relationship between your tables in SQL Server???


On Tue, Mar 31, 2009 at 4:55 PM, eddiec <edwardchalk@gmail.com> wrote:
>
> Hi,
>
> I have added a SQL Server - LINQ item to my C# asp project and have
> created classes that correspond to the tables in my database.
>
> This has automatically created classes that map to the tables in the
> database. I can instantiate instances of the classes that map directly
> to a table:
>            var Orders =
>                from c in context.Orders
>                where (c.OrderID.Equals(intCurrentOrder))
>                select c;
>
> Can someone please advise me how I can create an object / class where
> the class has attributes that are a join of two tables. (The Order
> object should contain Line Items. In the database the Orders table and
> LineItems table has a 1:M join.)
>
> For example, I have classes Order and LineItem that have been created
> automatically through LINQ. Do I need to create a new Order class that
> inherits from the Order class created automatically by LINQ and that
> contains an array LineItems?
>
> cheers,
>
> eddiec :-)

[DotNetDevelopment] LINQ - create object from 2 tables

Hi,

I have added a SQL Server - LINQ item to my C# asp project and have
created classes that correspond to the tables in my database.

This has automatically created classes that map to the tables in the
database. I can instantiate instances of the classes that map directly
to a table:
var Orders =
from c in context.Orders
where (c.OrderID.Equals(intCurrentOrder))
select c;

Can someone please advise me how I can create an object / class where
the class has attributes that are a join of two tables. (The Order
object should contain Line Items. In the database the Orders table and
LineItems table has a 1:M join.)

For example, I have classes Order and LineItem that have been created
automatically through LINQ. Do I need to create a new Order class that
inherits from the Order class created automatically by LINQ and that
contains an array LineItems?

cheers,

eddiec :-)

[DotNetDevelopment] Re: Please help me to get this job! -- suggestions on research aspect in ASP.NET

@Milo degree in CS  means degree in Computer Science and not degree in C Sharp :P

On Mon, Mar 30, 2009 at 7:51 AM, Cerebrus <zorg007@sify.com> wrote:

You're most welcome, Alex! It has been my pleasure contributing to
this discussion and it seems to have hit a chord with the group
members as well. We don't normally see so much activity within a
single thread.

As for building Custom server controls, I would consider it an
advanced topic and unlikely to be asked about in an interview. To be
honest, I myself have only basic knowledge about Control authoring
since I haven't needed to build them yet. I would suggest that you
just understand how a custom server control renders its output (for
instance, using the overridden RenderContents method to write output
to an HtmlTextWriter) and that knowledge should be sufficient. This
walkthrough should get you through the basics (http://
msdn.microsoft.com/en-us/library/yhzc935f(VS.80).aspx)

In my opinion, what is more important at this stage is to understand
how Pages work, their lifecycle, State management techniques, Master
pages and UserControls, Caching for performance, familiarity with the
various types of built-in controls, data retrieval and update
scenarios and Site configuration to name a few. At this stage, your
stress should be on understanding the .NET framework and build
familiarity with either C# or VB.

Remember that you'll always have time to delve deeper into topics that
interest you, later.

On Mar 30, 6:47 pm, Alex Y Wang <redflying...@gmail.com> wrote:
> Milo, I just don't get your point. I don't see any reason why I have
> to know ASP.NET to get my degree, and thanks again, Cerebrus.
>
> After some initial reading through the recommended books, I have a
> rough idea of learning something about building Custom Server
> Controls, because it seems fun. I know I may just have time to touch a
> small part of the subject though. Does that sound realistic? If so,
> any suggestions on how to get on track quickly on that? Thanks.
>
> Alex
>



--
My Web Site
http://everlovingyouth.googlepages.com
My Technical Blog
http://acutedeveloper.blogspot.com
Skype :santhoshnta
Orkut :everlovingyouth

[DotNetDevelopment] Re: client-side password validation (matching)

i think wht joe said is correct

On Tue, Mar 31, 2009 at 12:46 AM, Joe Enos <joe@jtenos.com> wrote:

I don't think I understand what "textbox.PW" means...

Correct me if I'm wrong, but I believe you mean the following,
assuming txtPassword and txtPassword2 are the server IDs of the two
password textboxes:

var a = document.getElementById("<%= txtPassword.ClientID %>");
var b = document.getElementById("<%= txtPassword2.ClientID %>");

On Mar 30, 10:19 am, "Stephen Russell" <sruss...@lotmate.com> wrote:
> <script language="javascript">
>
> function check() {
>  var a = document.getElementById('<%=textbox.PW%>');
>  var b = document.getElementById('<%=textbox.PW2%>');
>
>  if (a.value == b.value) {
>   return true;
>  } else {
>   return false;
>  }
>
> }
>
> </script>
>
> .........................
> Stephen Russell -
> Senior Visual Studio Developer, DBA
>
> Memphis, TN
> 901.246-0159
>
> > -----Original Message-----
> > From: DotNetDevelopment@googlegroups.com
> > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> > Sent: Monday, March 30, 2009 9:08 AM
> > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > Services,.NET Remoting
> > Subject: [DotNetDevelopment] client-side password validation (matching)
>
> > What is my best way (client-side of course) on an .aspx page to
> > compare the value in the "Password" textbox with that of the "Retype
> > Password" textbox? Javascript? Any source code examples anyone knows
> > would be helpful - javascript is still rather foreign to me.  Thanks!
>
> > No virus found in this incoming message.
> > Checked by AVG -www.avg.com
> > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > 03/29/09 16:56:00

[DotNetDevelopment] Re: Menustrip items Disappeared !

Normally designer have issues with such undos especiially using 3rd party ctrls.
But i dont think it will happen with .net controls.
Anyway check the designer code, and ensure all items are added to strip.
Many times i faced such things with the third party controls which are solved by directly editing the designer code. I faced it many times with the table layout panel.

On Mon, Mar 30, 2009 at 12:48 PM, Karthikeyan R <karthizen@gmail.com> wrote:
Hi,
 
I am experiencing a strange issue.   Accidentally I have deleted the Menustrip from my Parent form, then I pressed ctrl+Z to bring it back.  However, the menuitems got disappeared from the Menustrip. 
 
I was not able open the code window by double-clicking the menuitem, I right clicked on the Menustrip and then viewed code.   
 
Can any one help me out on this?

--
Thanks & Regards,
Karthikeyan



--
My Web Site
http://everlovingyouth.googlepages.com
My Technical Blog
http://acutedeveloper.blogspot.com
Skype :santhoshnta
Orkut :everlovingyouth

[DotNetDevelopment] COM issue with Unit Tests

Hi,

I have a C# .NET 2.0 project with a class that makes use of a COM
component. If I attempt to run a unit test in visual studio 2008, as
soon as an object of this class reaches code to call the constructor
of the COM object, I get an exception:

System.Runtime.InteropServices.COMException: Retrieving the COM class
factory for component with CLSID {47B7DFA4-6687-4AEA-AA68-
A140107B4858} failed due to the following error: 80040154.

However, if I set a break point in an application using the same
class, the exact line of code that throws the exception in unit
testing works without any problems.

Any idea why this exception's only getting thrown in the unit test?

Thanks,
Daniel Sheiner

[DotNetDevelopment] Menustrip items Disappeared !

Hi,
 
I am experiencing a strange issue.   Accidentally I have deleted the Menustrip from my Parent form, then I pressed ctrl+Z to bring it back.  However, the menuitems got disappeared from the Menustrip. 
 
I was not able open the code window by double-clicking the menuitem, I right clicked on the Menustrip and then viewed code.   
 
Can any one help me out on this?

--
Thanks & Regards,
Karthikeyan

[DotNetDevelopment] Re: client-side password validation (matching)

I don't think I understand what "textbox.PW" means...

Correct me if I'm wrong, but I believe you mean the following,
assuming txtPassword and txtPassword2 are the server IDs of the two
password textboxes:

var a = document.getElementById("<%= txtPassword.ClientID %>");
var b = document.getElementById("<%= txtPassword2.ClientID %>");

On Mar 30, 10:19 am, "Stephen Russell" <sruss...@lotmate.com> wrote:
> <script language="javascript">
>
> function check() {
>  var a = document.getElementById('<%=textbox.PW%>');
>  var b = document.getElementById('<%=textbox.PW2%>');
>
>  if (a.value == b.value) {
>   return true;
>  } else {
>   return false;
>  }
>
> }
>
> </script>
>
> .........................
> Stephen Russell -
> Senior Visual Studio Developer, DBA
>
> Memphis, TN
> 901.246-0159
>
> > -----Original Message-----
> > From: DotNetDevelopment@googlegroups.com
> > [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> > Sent: Monday, March 30, 2009 9:08 AM
> > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> > Services,.NET Remoting
> > Subject: [DotNetDevelopment] client-side password validation (matching)
>
> > What is my best way (client-side of course) on an .aspx page to
> > compare the value in the "Password" textbox with that of the "Retype
> > Password" textbox? Javascript? Any source code examples anyone knows
> > would be helpful - javascript is still rather foreign to me.  Thanks!
>
> > No virus found in this incoming message.
> > Checked by AVG -www.avg.com
> > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> > 03/29/09 16:56:00

Monday, March 30, 2009

[DotNetDevelopment] Re: webbrowser

I need a slave machine to login on an extern website( https and cookie
reuired)...
I'llsend a short string 100 byte maximum to slave machine and it 'll
do login and other operations.....
Operations on slave machine are very simple to do,,,,,,it's very hard
doing them with httpwebrequest, I'm not able to do it...every help is
liked

On 30 Mar, 17:55, Cerebrus <zorg...@sify.com> wrote:
> Many issues to address in your question:
>
> 1. Yes, you can, but I can see no use for it. The WebBrowser is a
> control (visual representation), not just a component. I find it
> difficult to understand what you are trying to accomplish with a
> WebBrowser.
>
> 2. Why are you unable to use HttpWebRequest? What is the relevance of
> a Cookie in a Webservice, given that the former is a Client side
> object and the latter is an exclusively server side service ?
>
> 3. System.Windows.Forms.dll is installed as part of the .NET
> framework. It should be there on your server if you have .NET
> installed.
>
> On Mar 30, 8:34 pm, Alcibiade <panda...@libero.it> wrote:
>
> > Hi, can I use a webrowser in my webservice code ?
> > I need to use cookie and https and I'm not able to use httpwebrequest
> > so I wanna use webbrowser control.....
> > Can I do it? If on my server there is not system.windows.forms.dll can
> > I add it ?
> > Thanks

[DotNetDevelopment] Re: Where does Class="scrollContainer" come from?

Did you look inside of .css files? That is the type of class that is being
referenced in this case.

.........................
Stephen Russell -
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159

> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of stapes
> Sent: Monday, March 30, 2009 7:46 AM
> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting
> Subject: [DotNetDevelopment] Where does Class="scrollContainer" come
> from?
>
>
> I have the following code in my project (ASP.NET C# Web app):
>
> <div id="scroll"
> class="scrollContainer"
> runat="server"
> style="overflow:auto; width:1000px; padding-left:5px
> ">
>
> I cannot find the class "scrollContainer" defined anywhere in my
> project, so where does this class come from. It is working correctly
> in most cases, but not on a few. I need to be able to see the
> definition and possibly amend it.
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/29/09 16:56:00

[DotNetDevelopment] Re: Generating Excel report using ASP.NET and C#

Office is not loaded on the server?

.........................
Stephen Russell -
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159

> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of stapes
> Sent: Monday, March 30, 2009 5:12 AM
> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting
> Subject: [DotNetDevelopment] Generating Excel report using ASP.NET and
> C#
>
>
> This works OK on my development machine, but when I try to run it on
> the live server, I get this error:
>
> System.Runtime.InteropServices.COMException (0x80080005): Retrieving
> the COM class factory for component with CLSID {00024500-0000-0000-
> C000-000000000046} failed due to the following error: 80080005 at
> Web_Reports_KPI.excelKPIS() in c:\inetpub\wwwroot\AGwww\Web_Reports
> \KPI.aspx.cs:line 67
>
> Line 67: MyExcel.Application excelApp = new MyExcel.ApplicationClass
> ();
>
> MyExcel is defined at the top: using MyExcel =
> Microsoft.Office.Interop.Excel;
>
> I also have references: Microsoft Excel 12.0 Object Library, Microsoft
> Office 10.0 Object Library, Microsoft Office 11.0 Object Libray,
> Microsoft Office 12 Object Library, Microsoft.Office.Interop.Word.dll
>
> I have used Component Services / DCOM Config to set permssions for
> Microsoft Excel Application. In the Launch and Activation permissions
> I have added NETWORK SERVICE and Evereyone. Same for Access Permssions
> and Configuration Permissions. Did not make any difference.
>
> Does anyone have any clues?
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/29/09 16:56:00

[DotNetDevelopment] Re: client-side password validation (matching)

<script language="javascript">

function check() {
var a = document.getElementById('<%=textbox.PW%>');
var b = document.getElementById('<%=textbox.PW2%>');

if (a.value == b.value) {
return true;
} else {
return false;
}
}

</script>

.........................
Stephen Russell -
Senior Visual Studio Developer, DBA

Memphis, TN
901.246-0159


> -----Original Message-----
> From: DotNetDevelopment@googlegroups.com
> [mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brock
> Sent: Monday, March 30, 2009 9:08 AM
> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting
> Subject: [DotNetDevelopment] client-side password validation (matching)
>
>
> What is my best way (client-side of course) on an .aspx page to
> compare the value in the "Password" textbox with that of the "Retype
> Password" textbox? Javascript? Any source code examples anyone knows
> would be helpful - javascript is still rather foreign to me. Thanks!
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date:
> 03/29/09 16:56:00

[DotNetDevelopment] Re: gridview , display columns in a row vertically not horizontally

Use a Datalist perhaps - RepeatDirection.Vertical ?

On Mar 30, 3:44 pm, Muhammad Arif <brainsa...@gmail.com> wrote:
> hello all:
>  I want to made a picture gallary in gridview asp.net ..i have done this..
> but now i want to display
> display columns in a row vertically not horizontally..
> Regards
>
> --
> Muhammad Arif
> Software Engineer
> +923009347315

[DotNetDevelopment] Re: webbrowser

Many issues to address in your question:

1. Yes, you can, but I can see no use for it. The WebBrowser is a
control (visual representation), not just a component. I find it
difficult to understand what you are trying to accomplish with a
WebBrowser.

2. Why are you unable to use HttpWebRequest? What is the relevance of
a Cookie in a Webservice, given that the former is a Client side
object and the latter is an exclusively server side service ?

3. System.Windows.Forms.dll is installed as part of the .NET
framework. It should be there on your server if you have .NET
installed.

On Mar 30, 8:34 pm, Alcibiade <panda...@libero.it> wrote:
> Hi, can I use a webrowser in my webservice code ?
> I need to use cookie and https and I'm not able to use httpwebrequest
> so I wanna use webbrowser control.....
> Can I do it? If on my server there is not system.windows.forms.dll can
> I add it ?
> Thanks

[DotNetDevelopment] webbrowser

Hi, can I use a webrowser in my webservice code ?
I need to use cookie and https and I'm not able to use httpwebrequest
so I wanna use webbrowser control.....
Can I do it? If on my server there is not system.windows.forms.dll can
I add it ?
Thanks

[DotNetDevelopment] Re: client-side password validation (matching)

Well, if you're using ASP.NET, M$ has been good enough to provide a
CompareValidator control for this very purpose. It encapsulates the
Javascript required to compare the value of one control to another.
The most common use of this control is for the Password-Confirm
Password textboxes.

Here is a basic tutorial on using the CompareValidator <http://
www.w3schools.com/aspnet/control_comparevalidator.asp>. And another:
<http://asp.net-tutorials.com/validation/compare-validator/>

On Mar 30, 7:08 pm, Brock <wade.br...@yahoo.com> wrote:
> What is my best way (client-side of course) on an .aspx page to
> compare the value in the "Password" textbox with that of the "Retype
> Password" textbox? Javascript? Any source code examples anyone knows
> would be helpful - javascript is still rather foreign to me.  Thanks!

[DotNetDevelopment] Re: Where does Class="scrollContainer" come from?

Try searching for the word scrollContainer in files of type "*.css".

On Mar 30, 5:46 pm, stapes <steve.sta...@gmail.com> wrote:
> I have the following code in my project (ASP.NET C# Web app):
>
>  <div    id="scroll"
>                 class="scrollContainer"
>                 runat="server"
>                 style="overflow:auto; width:1000px; padding-left:5px
> ">
>
> I cannot find the class "scrollContainer" defined anywhere in my
> project, so where does this class come from. It is working correctly
> in most cases, but not on a few. I need to be able to see the
> definition and possibly amend it.

[DotNetDevelopment] Re: Where does Class="scrollContainer" come from?

Done! I have modified your subscription type to "No email", and you
still remain a Group member. Next time, try to set your account
settings yourself and do not hijack other discussion threads. My email
address is in the Group's welcome message and people do email me
requests for account modification.

--
Cerebrus.
Group Moderator.

On Mar 30, 6:18 pm, shailendra gusain <gusain9689shailen...@gmail.com>
wrote:
> Unsubscribe me from newsletters of this group for few time

[DotNetDevelopment] Re: Please help me to get this job! -- suggestions on research aspect in ASP.NET

You're most welcome, Alex! It has been my pleasure contributing to
this discussion and it seems to have hit a chord with the group
members as well. We don't normally see so much activity within a
single thread.

As for building Custom server controls, I would consider it an
advanced topic and unlikely to be asked about in an interview. To be
honest, I myself have only basic knowledge about Control authoring
since I haven't needed to build them yet. I would suggest that you
just understand how a custom server control renders its output (for
instance, using the overridden RenderContents method to write output
to an HtmlTextWriter) and that knowledge should be sufficient. This
walkthrough should get you through the basics (http://
msdn.microsoft.com/en-us/library/yhzc935f(VS.80).aspx)

In my opinion, what is more important at this stage is to understand
how Pages work, their lifecycle, State management techniques, Master
pages and UserControls, Caching for performance, familiarity with the
various types of built-in controls, data retrieval and update
scenarios and Site configuration to name a few. At this stage, your
stress should be on understanding the .NET framework and build
familiarity with either C# or VB.

Remember that you'll always have time to delve deeper into topics that
interest you, later.

On Mar 30, 6:47 pm, Alex Y Wang <redflying...@gmail.com> wrote:
> Milo, I just don't get your point. I don't see any reason why I have
> to know ASP.NET to get my degree, and thanks again, Cerebrus.
>
> After some initial reading through the recommended books, I have a
> rough idea of learning something about building Custom Server
> Controls, because it seems fun. I know I may just have time to touch a
> small part of the subject though. Does that sound realistic? If so,
> any suggestions on how to get on track quickly on that? Thanks.
>
> Alex
>

[DotNetDevelopment] Re: Display number of Dates in a Single ComboBox in C#

Look at the below examples. I'm betting that you will find something
wrong in your DataReader logic or in your code that is populating the
combobox.

http://msdn.microsoft.com/en-us/library/haa3afyz(VS.71).aspx

http://msdn.microsoft.com/en-us/library/aa983551(VS.71).aspx


On Mar 27, 11:13 pm, Hamad H <houma...@gmail.com> wrote:
> you really well understood what I wanted to do and  I put the break and it's
> the quite same it's behaving as it's suppose to..... but anyway I don't know
> any more...... is there any other way to do it.................
>
> ppllllzzzzzzz
>
> by you or any other person ..........
>
> thank you
>
> 2009/3/28 The_Fruitman <evilfruitsmas...@gmail.com>
>
>
>
>
>
> > So from what I understand of your requirements when a user selects a
> > patient you're retrieving the patient's information from a database.
> > Then you're trying to put every time that select patient visited the
> > hospital into the ComboBox_LastDayVisit combo box.  What's happening
> > instead is that you're only getting one day into the combo box.  I
> > would recommend putting a break point on the line
> > ComboBox_LastDayVisit.Items.Add(dr["Date_of_Visit"] + "");  and seeing
> > what the values of dr and ComboBox_LastDayVisit are at each step.  It
> > may surprise you to see what the values end up being at each step
> > because I don't think your program is behaving as you think it is.
>
> > On Mar 27, 12:53 am, Hamad H <houma...@gmail.com> wrote:
> > > the thing is In the Patient Appointment Form at the beginning I need
> > > to retrieve the Major Info about the Patient before you register
> > > his/her Appointment and when I do it .... I put a ComboBox to retrieve
> > > the number of date(s) that this Patient has visited the
> > > Clinic/Hospital and hence I can select the Last Day he/she visited the
> > > clinic/hospital.......
>
> > > The_Fruitman thankx for the link but with this I'm displaying the
> > > whole VISITDATES of all the patients and I did it before but I want to
> > > display the Number of visited date(s) by the particular Patient ID
> > > that I will submit into PatientID ComboBox because in this ComboBox I
> > > bounded into the PatientID Column and I'm retrieving every registered
> > > patient.......
>
> > > by the way here is the codes check it up........ if there is another
> > > possible way and I know there is always a way to work things out in
> > > .NET so plz dn't hesitate and I 'll be thank full
>
> > > LOGIC :
>
> > > private void Btn_Go_Click(object sender, EventArgs e)
> > >         {
> > >             try
> > >             {
> > >                 cn.Open();
>
> > >                 ComboBox_LastDayVisit.Items.Clear();
> > >                 ComboBox_LastDayVisit.Text = "";
> > >                 cmd = new SqlCommand("Select * from P_VisitReg where
> > > P_ID =" + ComboBox_PID.Text, cn);
> > >                 dr = cmd.ExecuteReader();
> > >                 if (dr.Read() == true)
> > >                 {
> > >                     lblInfo.Visible = false;
> > >                     TxtP_Name.Text = dr.GetString(1);
> > >                     TxtP_Gender.Text = dr.GetString(2);
> > >                     TxtP_Age.Text = dr.GetInt16(3) + "";
> > >                     TxtP_HomeNum.Text = dr.GetInt64(4) + "";
> > >                     TxtP_CellNum.Text = dr.GetInt64(5) + "";
> > >                     TxtDr_Name.Text = dr.GetString(8);
> > >                     ComboBox_LastDayVisit.Items.Add(dr["Date_of_Visit"] +
> > "");
>
> > >                 }
> > >                 else
> > >                 {
> > >                     lblInfo.Visible = true;
> > >                     lblInfo.Text = "Patient ID " + CB_PID.Text + " has
> > > not registred for a visit";
> > >                     Clear();
> > >                     ComboBox_PID.Focus();
> > >                 }
> > >             }
> > >             catch (SqlException se)
> > >             {
> > >                 MessageBox.Show(se.Message);
> > >             }
> > >             finally
> > >             {
> > >                 dr.Close();
> > >                 cn.Close();
> > >             }
> > >         }
>
> > > Thank a lot
>
> > > 2009/3/26, Cerebrus <zorg...@sify.com>:
>
> > > > I concur with The_Fruitman... we need to see a little more of the
> > > > relevant code and we need to understand your table structure in more
> > > > detail. For instance, what do you store in the "Patient Visit" table?
> > > > How do you fill the Combobox? and so on...
>
> > > > On Mar 26, 11:35 am, Haitch <Houma...@gmail.com> wrote:
> > > >> I'm developing a project which is PSI (Patient Information System) and
> > > >> in the appointment form There is two Panels
> > > >> 1- Patient Major Information. PID, NAME, GENDER..... etc...
> > > >> 2- Appointments Details. Date of App, Reason for App, Best Time to
> > > >> Remind the Patient.... etc...
>
> > > >> hence in the major patient info I put a COMBOBOX to Retrieve the Dates
> > > >> from ( Patient Visit TABLE ) using ADO.NET.... that the Patient has
> > > >> already visited the Clinic... b'coz a Patient can visit the clinic as
> > > >> much as his treatment needed for....
>
> > > >> but when I tried it's just displaying only one DATE ....... here is
> > > >> the way I did so for the ComboBox...
>
> > > >> ComboBox_VisitDate.Items.Add(dr[Visit_Dates] + " ");
>
> > > >> and according to the selected date it should display the ( Patient
> > > >> Last Treatments ) and also ( Info about his disease )... and I did it
> > > >> with the SELECTEDINDEX of the ComboBox but it's only displaying one
> > > >> date...........
>
> > > >> Please can you guys help me to display all the visited dates of the
> > > >> Selected Patients ID....... I 'ld be very great full.... thank you
> > > >> even if yu tried so....
>
> > > >> H- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -