|
hai,
I have tried to use 3 layers
Presentation Layer,business Logic Layer, Data Access Layer
Just i Have tried,tell whether this is correct or not?
In My Presentation Layer[tUserPL.aspx]
i have two textbox one for UserName and other for password
<code>
Dim i As String
Dim UserBLL As New UserBLL
Private Sub btnSubmit_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.ServerClick
Try
UserBLL.User_Name = Me.txtuser.Value
UserBLL.User_Pass = Me.txtPass.Value
i = UserBLL.Verify()
If i > 1 Then
Response.Redirect("\IPB\tBillCorrectionA.aspx")
Else
Response.Write("Not an Authorized User")
End If
Catch ex As Exception
Response.Write(ex.Message.ToString())
End Try
End Sub
</code>
In My business Logic Layer[UserBLL.aspx] i Have the Following,
<code>
Public Class UserBLL
Public err, cmd_value, qry_value As String
Dim UserData As New UserDAL
Dim sqlconn As New SqlClient.SqlConnection
Public Property User_Name() As String
Get
Return cmd_value
End Get
Set(ByVal Value As String)
cmd_value = Value
End Set
End Property
Public Property User_Pass() As String
Get
Return qry_value
End Get
Set(ByVal Value As String)
qry_value = Value
End Set
End Property
Public Function Verify()
Dim sqlcmd As SqlClient.SqlCommand
Dim i As Integer
Me.sqlconn.ConnectionString = ConfigurationSettings.AppSettings("BB_CONSTR")
Me.sqlconn.Open()
Return UserData.ExecuteMsgQuery("select count(*) from mast_users where cLogin like '" & User_Name & "' and cPassword like '" & User_Pass & "'", sqlconn)
End Function
End Class
</code>
In My Data Access Layer[UserDAL.aspx] i Have following
<code>
Public Class UserDAL
Public Shared Function ExecuteMsgQuery(ByVal selQuery As String, ByVal myCon As SqlClient.SqlConnection) As Int16
Try
Dim SqlAdpt As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(selQuery, myCon)
If SqlAdpt.SelectCommand.ExecuteScalar > 0 Then
Return 2
Else
Return 1
End If
Catch ex As Exception
Return 3
Finally
End Try
End Function
</code>
In above i have tried to get a concept but i think i am not in correct way and
i need a result like verfying the user name and password and return back to BLL
i am not getting any error and i am redirecting to another page after verifying user name and password. after i am getting correct as result i need to proceed the same concept in my project. help me out...
sathimailin
|
|
|
|
|
hi , i have a Written a nice for Beginners.
http://www.codeproject.com/useritems/N-Tier_Application.asp[^]
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
for ex,
there are 2 datetimepicker,1 textbox,1 button named as firstdatetimepicker,seconddatetimepicker,noofdaystextbox and okbutton.
calculation is
seconddatetimepicker = firstdatetimepicker + noofdaystextbox.
example-1
if i give date to firstdatetimepicker is "22-10-2007" and i give no of days to noofdaystextbox is 4,then i click ok button means,must add 4 days from "22-10-2007",in seconddatetimepicker must automatically displayed as "26-10-2007"
example-2
if i give date to firstdatetimepicker is "15-10-2007" and i give no of days to noofdaystextbox is 9,then i click ok button means,in seconddatetimepicker must automatically displayed as "24-10-2007"
i do my project in .net 2005 windows application.i want in .net windows application.
|
|
|
|
|
It's very simple. Convert the string in the textbox to a number (for example using Int32.TryParse), then use the AddDays method on the date to create a new date with the days added.
---
single minded; short sighted; long gone;
|
|
|
|
|
datetimepicker.value is a property which returns or accepts date object
you can add days in a date using Date.Add method which will return another date with added number of days. 
Salman Sheikh
|
|
|
|
|
how to save a windows application project in vb.net will be save as an .exe file as in vb6
|
|
|
|
|
in .NET you Deploy your Program in , and convert it into something we call" Msil", that will be your Exe. that Msil run on a .NET Platform, this means you have to install .NET framework where ever you run a Msil. So in your case now, Add a new Project and Add it to the Existing Project, choose Setup and Deployment Object and follow the Folling Guideline in on this site.
http://www.c-sharpcorner.com/UploadFile/vishnuprasad2005/SetupProjects12022005022406AM/SetupProjects.aspx[^]
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
It's done automatically every time you run your app from inside the IDE. Look in your project folder. You'll find a bin folder with two folders inside it, Debug and Release. You're .EXE will be found in either of those folders.
The Debug version has all kinds of debug code compiled into it. You normally don't deploy this version to the customer. You normally deploy the Release version.
|
|
|
|
|
How can I track the keypress of Tab Key in a DataGridView. The column in which I want to track is of a textbox type column.
Your suggestions will help me a lot.
CSS.
Sekhar
|
|
|
|
|
What do you mean by "tracking a TextBox column"?? What do you want to do when the user hits the Tab key??
|
|
|
|
|
use keydown or keyup event and check
e.keydata = keys.tab
Salman Sheikh
|
|
|
|
|
I have a TabControl and several pages to it. Each of the pages contains one datagridview and few buttons. I want when i press the tab key on the last cell of the last row of a datagridview, it should take me to the next page of the Tabcontrol and place the focus on the first cell of the datagridview of that page. So for this I need to track the keypress for the cell from which i want to shift the focus to the next page's datagridview. And the last column of the datagridview is a textBox type column.
Sekhar
|
|
|
|
|
In that case, you handle the KeyDown event of the DGV and check the event args KeyCode property for the Keys.Tab key. If pressed, you have to check to see what the cuurnet cell is. If the current cell is the last one, you set the Handled propery of the event args to True and make your changes to the TabControl. Otherise, you do nothing.
|
|
|
|
|
I'm having a problem getting a textbox to display some data. The application is recording sound and I wanted to see a few pieces of data as it comes in. I set the text property from within a thread and it doesn't do anything, not even display a zero.
I've checked as the obvious stuff; the textbox1.text code is being executed, and there isn't any other code relating to textboxes anywhere else that would overwrite it. Any help would be appreciated
|
|
|
|
|
I'm surprised it doesn't blow up. In VB2005, accessing a form control from a thread that didn't create it, should blow it up.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
So what should I do to get around this problem? Does it apply to other controls to?
|
|
|
|
|
It applies to every control. You cannot modify a control from a thread other than the one that created the control.
Christian is correct, this should have exploded when the code got to updating the control. This tells me that either you've set that nasty little property called "CheckForIllegalCrossThreadCalls" to False, or you're wrapped the code that updates the checkbox in a Try/Catch block that's eating the exception that gets thrown.
You have to provide a method on your form to update the TextBox, create a delegate for it, then you Invoke that method to update the TextBox. From memory, it goes something like this:
Public Class Form1
Private Delegate Sub UpdateTextBoxDelegate(ByVal message As String)
Public Sub UpdateTextBox(ByVal message As String)
If TextBox1.InvokeRequired Then
TextBox1.Invoke(New UpdateTextBoxDelegate(AddressOf UpdateTextBox), New Object() {message})
Else
TextBox1.Text = message
End If
End Sub
This sub can be called from from code on the form running from any thread and the call will get marshaled back to the UI thread to update the textbox. All you have to do is call the sub:
UpdateTextBox("Some string...")
|
|
|
|
|
Hi all,
I want to know is there some way to execute a report from SQL Server 2005 Report Service? Honestly., i'm not really familiar with VB..in VS.Net I can execute the report using reportviewer control, but I can't find any similar control in VB6 form.
So please., if any of you can show me how to do it(if it is possible)..I'll realy appreciate it guys
|
|
|
|
|
Why go back to VB6, Microsoft have giveup on it.
Stick to .NET or you will have Problems, just look at vb6 and look at SQL 2005, do you think they can be friends?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Actualy I'm personally prefer to use .Net to use SSRS for new application but in this case I have several application that already running on VB6 and I wondering if those applications can use SSRS as Reporting media.
So if there any information about it..please inform to us. Thanks ..
|
|
|
|
|
Am Sorry my friend this time you cant
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
I just started an entry level programming job. I am familiar with basic vb.net programming. Our company uses vb.net 2005. They are programming at a level far beyond my knowledge. I have looked at books but they are all very basic and are no help to me...
my question is what is a good programming book for intermediate programmers in vb2005?? I need something also that goes into detail about debugging applications because I never got into that very in depth in school.
Erica
|
|
|
|
|
This is an awesome question BTW. I wish more people here would read books.
This[^] looks like a good overview on debugging, basically you set a breakpoint, the code will stop there and you can examine variable values and step through your code to see what it's doing.
The main thing you need to do, is to make sure you don't try to hide what you don't know. If you show an attitude of willingness to learn, and are open about where you need help, any company should see that as an assett. It's the ones who try to hide their problems that are a burden.
When you say 'intermediate', what sort of stuff do you know, and what sort of stuff is confusing you ? I'd buy a non beginner book, here[^] are some books that mostly seem like good candidates. If the book is at too high a level on some things, you can always use the keywords you get from the section ( such a generics ) and google for articles, or ask specific questions here if you're stuck.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I'm trying to pass data from one open form to another open form in vb.net 2005
simple example: Form1 and Form2 are on your screen
Form1 has a textbox let us say textbox1
and Form2 has a button
when I press the button on Form2, textbox1 on form1 must show a simple text
Form1 and textbox1 are public
so on Form2 when I press the button, I can say Form1.textbox1.Text ="test"
but nothing happens on Form1
I thought it would be easy to do but I'm a system administrator not an experienced programmer
|
|
|
|
|
You mean like this?
Form 1:
<br />
Public Class Form1<br />
<br />
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
Dim form2 As New Form2<br />
form2.ShowDialog()<br />
End Sub<br />
<br />
End Class<br />
Form 2:
<br />
Public Class Form2<br />
<br />
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
Form1.TextBox1.Text = "test"<br />
Me.Close()<br />
End Sub<br />
<br />
End Class<br />
Or am I over simplifying it?
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
