Skip to content
  • 0 Votes
    1 Posts
    0 Views
    No one has replied
  • Evian1

    .NET (Core and Framework) csharp mysql com testing beta-testing
    1
    0 Votes
    1 Posts
    0 Views
    No one has replied
  • how to add picture into mysql using datagridview

    C# mysql tutorial
    3
    0 Votes
    3 Posts
    0 Views
    L
    A datagridview is a component that displays things; it doesn't add things to a database. There's quite a lot of examples of saving and retrieving pictures from databases. What have you tried? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
  • 0 Votes
    2 Posts
    0 Views
    B
    It could be virtually anything. Any luck connecting to the same server with the same credentials but with a different Mysql IDE?
  • 0 Votes
    2 Posts
    0 Views
    Greg UtasG
    . Robust Services Core | Software Techniques for Lemmings | Articles
  • 0 Votes
    6 Posts
    0 Views
    L
    Check the length of the blob that you are saving, vs. the length of the one you are reading. If you suspect the sha256-hash, then replace it with another hashing algo. As for "not storing files in a db" in support of exposing the filesystem; I would advise against it. Modern databases are fast enough to work as a file-system, and are used as such. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
  • 0 Votes
    1 Posts
    0 Views
    No one has replied
  • 0 Votes
    1 Posts
    0 Views
    No one has replied
  • 0 Votes
    3 Posts
    0 Views
    Richard DeemingR
    Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query. PHP: SQL Injection - Manual[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
  • 0 Votes
    7 Posts
    0 Views
    L
    Whatever you think you entered perhaps did not happen. Or your query is somehow incorrect. You can easily get all the information from SQLite database files using the sqlite3 command line interface.
  • bestbloger

    Linux, Apache, MySQL, PHP csharp mysql com testing beta-testing
    1
    0 Votes
    1 Posts
    1 Views
    No one has replied
  • OPC Client Using C# Titanium Library

    C# csharp database mysql sysadmin
    5
    0 Votes
    5 Posts
    0 Views
    P
    That's partly going to depend on what version of OPC DA the Mitsubishi MX uses (assuming you are confining yourself to the DA here and aren't interested in AE at all). All your other questions really flow from this. Advanced TypeScript Programming Projects
  • Site driver in QA

    Spam and Abuse Watch question php mysql com beta-testing
    1
    0 Votes
    1 Posts
    0 Views
    No one has replied
  • 0 Votes
    3 Posts
    0 Views
    U
    oh believe me I know. But network (lan) traffic can still be intercepted, packet sniffed, and if unencrypted, exploited. I'm now looking into possibly mysql over SSH. Disadvantage of course is the app must have the SSH username/password as program variables, which can be extracted. Vs direct MySQL, which you can just have a person login with their own mysql username and password. Is there any way to disassociate SSH with the filesystem/console and just mysql is there any better way than using XML/SSH for over the internet (yes, not lan). As i'm still not sure if I should do this lan or internet. This is a computer repair management software, i'm going to initially write it for myself, and maybe later release it, i'm not sure free or pay. If I use an internet web connector, I can enable a payment system for peoples accounts, but if thier internet is out, they can't use it. Lan, they can. i'm also considering using studio 2012, as the mysql connector does not work in 2008 (says "system cannot find the reference specified") and as much as i've learned vb.net a few years back, c#.net seems to be closer to PHP, my long learned language. Might consider learning c#
  • 0 Votes
    8 Posts
    0 Views
    Richard DeemingR
    vlafratta wrote: $query = $sql = "SELECT * FROM spesa_articoli_disponibili WHERE Codice_Articolo_CAPP LIKE '%" . $search . "%' OR ARTICOLO_Descrizione LIKE '%" . $search . "%'"; Don't do it like that! Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query. PHP: SQL Injection - Manual[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
  • spam in Q & A

    Spam and Abuse Watch help csharp mysql com tools
    1
    0 Votes
    1 Posts
    0 Views
    No one has replied
  • WordPress on IIS - Tip of the Day

    The Lounge php css mysql graphics sysadmin
    13
    0 Votes
    13 Posts
    0 Views
    K
    Eddy Vluggen wrote: an insult Not in the least. I should probably clarify why I didn't use web developer...In the interview, I asked him (as a test) if WordPress used php. He was only 85% sure it was...doesn't get into the code much I guess. Using a fancy WYSIWYG editor/framework to arrange content doesn't make you a developer. :) "Go forth into the source" - Neal Morse
  • 0 Votes
    4 Posts
    0 Views
    U
    This is how I fixed with help from a post on an another site. I do have one question though. If I comment out the first db connection - ConnDB() I get an error. Why does it need two connection to work? It makes a connection in the using command. I had setup a data table from a class I wrote to make a connection and set it up so I declare Private Access As New DBControl at the top and I can add parameters and do my additions and edits that way. I didn't know how to make that work with the existing connection to the Access DBControl so I just did another connection. Not the best but I am a beginner and don't know how to do things with more efficiency yet. Private Sub tbStudentID2_TextChanged(sender As Object, e As EventArgs) Handles tbStudentID2.TextChanged mySql = "SELECT DateDiff('d', [DateofRank], [currentDate]) FROM StudentData" '"SELECT DateDiff('d', [DateofRank], [currentDate]) FROM StudentData WHERE id={id}" ConnDB() 'myCommand = New OleDbCommand(mySql, myConnection) 'myCommand.ExecuteNonQuery() Dim studentID As Integer If Not Integer.TryParse(tbStudentID2.Text, studentID) Then ' Not a valid ID tbDays.Text = String.Empty Else Using command As New OleDbCommand("SELECT DateDiff('d', \[DateofRank\], \[currentDate\]) FROM StudentData WHERE StudentID = @StudentID", myConnection) command.Parameters.AddWithValue("@StudentID", studentID) ConnDB() Dim days As Object = command.ExecuteScalar() tbDays.Text = If(Convert.IsDBNull(days), String.Empty, Convert.ToString(days)) End Using ' ADD PARAMETERS - ORDER MATTERS !!! Access.AddParam("@TIG", tbDays.Text) Access.AddParam("@SID", tbStudentID2.Text) ' RUN COMMAND Access.ExecQuery("UPDATE StudentData " & "SET TimeinGrade=@TIG " & "WHERE StudentID=@SID") ' REPORT & ABORT ON ERRORS If NoErrors(True) = False Then Exit Sub End If End Sub
  • 0 Votes
    8 Posts
    0 Views
    D
    No, it just creates a OldDbCommand object. You actually have to tell it to execute using one of the Execute... methods. Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak
  • 0 Votes
    2 Posts
    0 Views
    L
    [MySQL :: MySQL Connector/NET Developer Guide :: 8.1 Entity Framework 6 Support](https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html) It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it. ― Confucian Analects: Rules of Confucius about his food