Search results

  1. S

    Insert query

    I must agree with cjard. NEVER use concatenation in SQL, use parameters. In addition to that, you may want to look at using the Enterprise Library from Microsoft to take advantage of the Data Access Application Block. They have already done most of the leg work for your data access code.....
  2. S

    Sql Command Problem

    You have broken the first 2 rules of database normalization in designing the database table......
  3. S

    Problems with Insert Command

    Vis781 and cjard, Thank you for making my points for me on why it is almost ALWAYS REQUIRED to use parameters.
  4. S

    Sql syntax error due to parameter

    Need to change two lines: oledbDaCT.SelectCommand = New SqlCommand("Select clnt_pk, clnt_CompanyName From tb_Clients Where clnt_CompanyName like '@clnt_CompanyName' ", mycon) Dim para = oledbDaCT.SelectCommand.Parameters.AddWithValue("@clnt_CompanyName", cmbClients.Text & "%")
  5. S

    Mysql and VB.net

    Why are you using the IDataReader, and not the MySqlDataReader?
  6. S

    Please explain SQL Server Data Types

    Char and varchar: Character Strings char Fixed-length non-Unicode character data with a maximum length of 8,000 characters. varchar Variable-length non-Unicode data with a maximum of 8,000 characters. text Variable-length non-Unicode data with a maximum length of 2^31 - 1...
  7. S

    pdf reader

    I don't think you can embed this, aka it will cause a PDF file to open in an external application, but foxit reader is a lightweight, and free PDF file reader that I use. http://www.foxitsoftware.com/pdf/rd_intro.php
  8. S

    mysql connection

    It sounds like you are just missing one step. You need to add a reference to mysql.data.dll (usually located at C:\Program Files\MySQL\MySQL Connector Net 1.0.7\bin\.NET 1.1). Just right click on the references forlder, and browse to where the mysql.data.dll file is located on your computer...
  9. S

    Programming Ideas

    Project now getting started I wanted to post an update regarding the project on my blog. I have done some project specification documents to get this started. I ask that anyone who is interested visit my blog, and download the docs. Please give feedback on what you see.
  10. S

    Calling a function

    Try looking in the help for AddHandler. This allows you to, in code, specify what code should be called when a certain event happens.
  11. S

    How to convert DATASET to ARRAY output

    I guess that you would have to initalize the upper bounds of the array based on the number of records in the dataset. Next loop through the dataset and add each row as an element in the array.....
  12. S

    could some one complete my assignment please

    Well, at least your honest, but I hope you don't plan on going into the programming profession.....
  13. S

    Vs.net 2005

    If you think pro is good, get the Team Suite. Talk about ROCKS!!!!
  14. S

    Select statement-True or false?

    NEVER WRITE SQL LIKE THAT! Always use parameters: cmd.CommandText = "SELECT * FROM Register WHERE Username = @Username and Password = @Password" cmd.Paramters.Add("@Username", sqldbtype.varchar, 50).Value = user cmd.Paramters.Add("@Password", sqldbtype.varchar, 50).Value = pass
  15. S

    help me to update database

    NEVER EVER WRITE SQL LIKE THAT!!!! That is very bad code because it opens you up to SQL Injection attacks. Always use paramaters.
  16. S

    Auto Number

    You do not need to buy SQL Server to get all the benefits of a MULTI-user database. Go to: http://msdn.microsoft.com/sql/express/default.aspx and download the FREE version of SQL Express. Yes it is a watered down version of SQL Server, but it is MULTI-user, has Stored Procedures, Triggers, and...
  17. S

    Inserting date to access problem

    So, It is working now?
  18. S

    Inserting date to access problem

    Maybe it is a good time to see your updated code (hint: use around your code as it can make it alot easier to read.)
  19. S

    Inserting date to access problem

    If you have not imported System.Data.OleDb then you will need to reference the complete path to the oleDbType (System.Data.OleDb.oleDbType). Also once you have done that the date one may need to be adjusted as well...
  20. S

    Inserting date to access problem

    try changing the paramter section of the code to: sqlCommand.Parameters.Add("@Hardware_Id", OleDbType.VarChar).Value = HardwareId sqlCommand.Parameters.Add("@Date_Time", OleDbType.SmallDateTime).Value = d sqlCommand.Parameters.Add("@Staff_Reported", OleDbType.VarChar).Value = Staff...
Top Bottom