Posts by Netcode

welcome!

Dim dc As SqlCommand = New SqlCommand

     With dc

                .Connection = con 'assuming con is connection string
                .CommandText = "INSERT INTO tblLoginDetails" & _
               "(UserName, password)" & _
               "VALUES ( @user, @pass)"
                .Parameters.AddWithValue("@user", txtuserName.Text)
                .Parameters.AddWithValue("@pass", txtpassword.Text)

            End With

            con.Open()

            Try
                dc.ExecuteNonQuery()
            Catch sqlexceptionerr As SqlException
                MessageBox.Show(sqlexceptionerr.Message)
            End Try

Sure i do, i just want you to see my own point of view just as i took out time to consider yours. You've not analysed mine and made any conclusions whether positive or negative, you're just pushing yours.

That will not attract professionals that are more-likely to browse github, gerrit or similar...

Is there a way you know if a professional browses daniweb maybe by checking up their IP?...lol;) github started from the bearest minimum so we're on that lane too.

so please suggest which is now day best development in web ? and also the large application in web ?

PHP was used for facebook, asp.net was used for myspace. Now, they're both big projects so i guess this is where your personal preference comes in because they all have pros and cons as lyan stated

cwarn23, i think the moderators need more time to decide. Am sure its quite a task considering the number of editorials and stories they have to debate on before publishing.

Having the tutorials here would be better in terms of traffic to daniweb and also easier to manage.

It does look more professional

Daniweb could also be made professional

happygeek, that's exactly what i use. I've never even had the time to notice the button ;)

Simply use the built-in screen saver lock after some minutes of inactivity. Adam_K has just explained the stress in achieving what you want.

This is the general syntax so all you need do is to fit in your table name, column and search condition:

UPDATE <table_or_view_name> 
SET column_name = {expression | DEFAULT | NULL} [ ,...n ]
WHERE <search_condition>

We are always willing to help. The instruction given to you has already clearly stated that you should store all data in a text file so you wont be needing a DBMS

it seems the world is losing inventors at this time.

R.I.P

How to love- Lil wayne

hey, i've made a textbox and want the asp.net to search max id from database(basically from sql2005) and generate the max id +1 into the textbox .

'Jx Man' already gave showed you that in his code as written below

Try
Dim sql As String = "SELECT MAX(NO) 'IDNumber' FROM Student "
Dim comm As SqlCommand = New SqlCommand(sql, conn)
myReader = comm.ExecuteReader
If myReader.HasRows Then
While myReader.Read()
temp = myReader.Item("IDNumber") + 1
End While
End If
myReader.Close()
Catch ex As Exception
 
End Try
conn.Close()
txtId.Text = String.Concat(temp) ' result will appear in textbox txtId

Everyone is saying they don't get the joke which is the same response so i believe pseudorandom21 has succeeded in cloning post response.

SELECT alert_value , year_id
from company_alert
WHERE year_id <= '2010'
GROUP BY year_id

Maybe because he is the only one who understands what it means for a star to trek (star trek)

IF am right, are you trying to get all records where year_id in the range of 2010 and below?

I know I am not senior but I am also confident I am not junior.

The confidence is what matters. As far as you can proof to the employer than you can deliver whatever is asked of you, then you're on the right track. Maybe the one's you interviewed with lack the funds to pay for your level of expertise and they may also be right in saying you still have some things to add to what you have. I've not been in such case before but i believe life is a gradual process. Just do what you know best and never lose that confidence.

Best of Luck!

VMWare is a virtual machine that gives you the ability to run more than one operating system on your machine. All you need is to make sure you have enough disk space to accommodate the number of Operating Systems you want to run and also have the memory for speed.

With that definition I will never prosper. I'm never happy with my life.

Maybe you're just some dude that believes in so much success and you've made it a philosophy never to accept or be comfortable with anything because you believe there's still more to achieve. Please be easy on yourself, be happy with whatever you achieve but still strife to do more.

I think being drunk makes you happy and believe in almost anything.

Being drunk does not make you happy, it only takes you away from your normal sense temporarily and weighs down your dignity and prestige on the streets. What makes you think that what you could not achieve when you are normal could be achieved when you're half mad........only more madness and destruction can you achieve in that state and believe me, when you regain your senses and see the havoc done by you, you would be more depressed. Please be easy on yourself

Best of Luck!

No such thing for me

is it the insert code similar with update code?

Insert and update are not the same, they're two different things. When inserting, you're placing data into a new row but updating means making changes to an already existing record.

So do you want to insert or update?

is it the insert code similar with update code?

Insert and update are not the same, they're two different things. When inserting, you're placing data into a new row but updating means making changes to an already existing record.

So do you want to insert or update?

You could either achieve this through use of modem or a web service. A lot of such services exist on the web so you can go ahead and Google solutions out.

Follow this link and see some codes

Did not see such when i zoomed the image

Now you got my point

Stick to the rules as the moderator advised and you would find it more fun ;)

Any tip at all....get it all here
Welcome!

Hi!

Warm welcome!

Welcome!

try updating your antivirus. Better still, you cold try activating it again.

funny

Am guessing that your combo-box contains all the fields you can also search for?

Yeah, opera is light.

In a login form, what else is there to retrieve apart from the username.You can only do a validation against the entered username and password and if it exists, you retrieve the username and display which is exactly what we just did. Except you mean something else which i don't get

I assumed you were using SQL Server but since you're not, you can make the changes to that of Access

The main difference is efficiency.

which could still be an extension of the original language like i earlier stated

this is not work properly ...please send clear code with database connection include

Simply call the subprocedure from the Button used for generating the sequence numbers like this:

Private Sub SerialButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SerialButton.Click

'Note: It is assumed that the button is named SerialButton
AutoNumberNo   'this calls this AutoNumberNo subprocedure

End Sub

see here

This is working but problem is that it retrives from frant end not from back end and I want from bcoz any user enter username like vASIM then it has to show as Vasim but right it is showing as vASIM

Then you also need to validate the case of the username in your database.

Don't waste your time on jealousy, sometimes you're ahead, sometimes you're behind. The race is long and in the end, don't hurt yourself

Baz-Luhrmann(in the song: Everybody's free to wear sunscreen)

So my question is, what is most popular in the market, now and what will be popular for the next 2-3 years? PHP or ASP.NET?

You may find so many sites designed with PHP because its an opensource language and many start-up companies may not be able to afford costs of servers and licenses that are not open source. Also, there are many softwares written in opensource languages like PHP these days for building sites, blogs, forums and others with little knowledge of programming so PHP may seem more popular but i've never said more professional.

Which one sounds better in a CV? Or looks good when you apply for a masters degree.

This so depends on where you're applying for a job and remember that PHP is opensource so there's no body that provides a sort of qualification test that marks you as one who can confidently handle the language but ASP.NET which is by Microsoft sure has such exams which when passed can guaranty you some better chances with an employer. Am not saying someone who has passed an exam must be practically better than someone who had no exam to take but it may give you a better chance when they see such qualifications on your CV.

I would have left my car and walked.

If you did that in my country, trust the government to be very active in towing your car but they would never be proactive to make sure the traffic/street lights work.

Baz-luhrmann: Everybody's free to wear sunscreen

Holy crap!
You can't really replace a language with another language unless you either do a one-to-one mapping of their feature sets, in which case the replacement language would be completely redundant and hence still-born, or extend the original language (like C++ and C), in which case your replacement language would have to offer significant advantages to be seriously considered.

The Java/.NET philosophy is a wonderful idea, but all it does is restrict the scope for which you would reasonably choose C++ over it.

language bashing is moronic. There are truly ancient languages, older than C/C++, that are still alive and kicking because they fill a particular niche better than anything else. Whether they fill your niche or not doesn't have any bearing on whether they're actually good or not.

The child that is the hardest to love is the one you should love the hardest

Public Sub RetrieveUserPass()
Try
Dim dbConn As OleDbConnection
Dim dbCommand As New OleDbCommand
Dim conn As New OleDbConnection

dbConn = New OleDbConnection(cnSettings())
dbCommand.CommandText = "SELECT * FROM [table1] Where User_id = '" & user_id.Text & "' And [password] = '" & password.Text & "'"

dbCommand.Connection = dbConn
dbConn.Open()

Dim dbDR As OleDb.OleDbDataReader = dbCommand.ExecuteReader

If dbDR.Read then 
	With Home
		.label2.text  = userid.text
		.show
	End With 
Me.Dispose
Else 
MessageBox.show("Error: user does not exist")
End If 

dbConn.Close()

Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Error")
End Try
End Sub

Look here