Posts by Netcode

except there's some incentives to go with it. Like staying young (the vampire myth), being comfortable, never falling sick....and more

could you post your codes on the 'save button' here so we could take a look at it

what error message message do you get?

I got the same message from the same guy but i checked his status and it says 'banned' so i know its under control.

Debasidas is right as always. You may want to consider implementing security levels for your database. Also, i would encourage use of stored procedures and then you can specify security contexts on your procedures.

Dim objdatatable As DataTable = objDataSet.Tables("TableName")

                      With DataGridView1
      		              .AutoGenerateColumns = True
                	      .DataSource = objDataSet
	                      .DataMember = "TableName"

                    ' Declare and set the alternating rows style...
                    Dim objAlternatingCellStyle As New DataGridViewCellStyle()
                    objAlternatingCellStyle.BackColor = Color.WhiteSmoke
                    searchDataGridView.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle

                    End With

It sure works, just make all necessary substitutions correctly (e.g. your connection-string, table-name, column-name)

Please give feedback

This would help you convert the image in your picture box to binary and save it in sql server.

'//declarations to handle face capture and its conversion to binary

   Dim myfilelocation As String = lblfilePath.Text
   Dim param As New SqlParameter("@ImageData", SqlDbType.VarBinary)
   Dim ImageData As Byte() = IO.File.ReadAllBytes(myfilelocation)
   param.Value = ImageData

  '//end declaration 


  Dim dc As SqlCommand = New SqlCommand

      With dc
      .Connection = con  'assuming 'con' is your connectionstring 
      .CommandText = "INSERT INTO TableName" & _
           "(ImageColumn)" + _
              "VALUES (@imagedata)"

                .Parameters.Add(param)
      End With

	con.Open()
        dc.ExecuteNonQuery()
        con.Close()

WaltP is very right. Please all IDs should remain unique

There is no certification without a value. Apart from the certificate itself, there is always something new to learn.

First, you can run a network diagnosis to get a clue. Also, your router may require some security key to grant you access through it to the internet.

this is the general syntax for creating tables

CREATE TABLE
[ database_name . [ schema_name ] . | schema_name . ] table_name
( column_name <data_type> [ NULL | NOT NULL ] [ ,...n ] )

so using your code to create a sample table(even though i don't know what you want to call the table from your code so am using 'personel')

CREATE TABLE Personel
 (ID INT NOT NULL,
  Name VARCHAR(40) NOT NULL)

it really depends on your phone. I have a land-line and i can check all received, dialled and missed calls on it so i dont need to worry.

I don't see a graphics card ?

Your graphics card is not visible on the outer part of the computer. You would need to open up the laptop and make a replacement to see if it solves the problem.

The term x86 refers to a family of instruction set architectures based on the Intel 8086 CPU.

bhagawatshinde, pgmer is right. The login form should be the first. if the user is validated, thnen show the Main form. If not, then show the registration form so the user can get registered then after registration, you can display the Main form.

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.

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

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

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

No such thing for me

Did not see such when i zoomed the image

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

see here

Bill Gates got DOS from IBM so cheaply because IBM didn't know what to do with it and didn't really want it. So yea, you buy something at a huge price that hasn't been developed yet. That's not stealing -- its just good business.

Not just business but Good Business. Bill gates is just one smart person the Tech industry needed and he brought a lot of competition into the industry thus leading to advancement in tech by different companies so as to attract more users and earn higher profits year after year.

R.I.P to a great tech contributor

You can still load your questions from a database and make changes to them anytime. Am not saying XML is not good but using VB and a database still works well and this way, your files are safe. Think about what happens if you use a text document and that document is mistakenly deleted.;)

Yes its doable.

picture boxes don't have scrolls if that's what you want

MyCommand.TableMappings.Add("Table", "Ur table name.")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)

The part of the code above shows where to enter your table name.

you may want to see this

"select B from Menu_templateจ้า"

i cant even pick the name of your excel sheet let alone your computer. You can simply use the wizard in SSMS. It may save you the stress except you want to do with codes for some reasons best known to you

Aviplo, you're welcome.

do i have to replace it with my column name in sql server

yes you do. That was a sample code given to you by pgmer as he cant say exactly what the columns in your excel sheet are so you have to fix them in.

whats the error?

cwarn23, you must be good at playing tricks. That dude must be lucky you're not the one he's playing games with.

so how would typing del(dell computers by you) increase computer speed.

What you could do is send him an email and tell your friend to type the following into start->run or on windows 7 the search box on the start menu.

for someone who could write such a script, i guess he would be knowledgeable enough to know the implications

My problem is how do I relate these 2 tables? I have primary key Item Code in both tables. I want to make Inventory table as main maybe, and transaction will reference any data from it.

First, you need to know what primary and foreign keys are:

A primary key is a special type of constraint that identifies a single column or set of columns, which in turn uniquely identifies all rows in the table.A primary
key enforces entity integrity,meaning that rows are guaranteed to be unambiguous and
unique.

In the context of relational databases, a foreign key is a referential constraint between two tables.

Having said this, both tables must have a primary key. Then, since your Inventory table is the main, there would also be need for a column with the same name and datatype as the primary key in the transaction table that would reference it and this would be known as the foreign key on the Inventory table but the primary key on the transaction table and then you can use 'JOINS' to retrieve data from both tables

read here for more on primary and foreign keys

Are there any suggestions for screwing his computer?

Its not his computer, its company property. If you had his personal computer in a non-official environment, then you can go around with such jokes

Whats the error you received?

We're also going to be coming up with the concept of "Dani Dollars" which can be earned through activity points and solving threads and other such means, and be redeemed in the store

Talking about redeeming the "Dani Dollars" in the store, what about those that live outside the US?

we sure will Nick. You it happens here on Geeks lounge once in a while. Its fun, guess thats why its the lounge.

It was not designed for people who may or may not be more advanced in programming and development to try and make people feel bad about themselves

No one knows it all, we all on daniweb learn from each other

whilst simultaneously boosting a pathetic forum posters shattered ego from a complete lack of social credibility.

If you had social credibility, you would be more polite

I would suggest you take a while to reflect on the sort of person you are and whether you are actually an asset to this forum.

Did you reflect on what people would see you as before posting this?

Plus the concept of solved threads when used correctly can help folks searching for solution to their problem narrow down things.

This is where i agree.

What problem with the database?

You set the form to be MDI parent in your code and you still expect it to open in itself.

I knew it was widely used but wasn't sure if times were moving on

Did you expect the world to stand still?

C still remains honored no matter what programming or technology as a whole evolves into

Its quite easy but you would agree with me that you would learn faster and better if you try it out yourself. Try something out and if you encounter any problems, just post your codes and whatever error message