C#

Member 13683765 wrote:

cmd.CommandText = "insert into tblBook (Book_ID, Name, Authour, Category, Donater_ID, Section_ID) values ('" + txtBoxBookId.Text + "', '" + txtBoxBookName.Text + "', '" + txtBoxAuthour.Text + "', '" + txtBoxCategory.Text + "', '" + txtBoxDonaterId.Text + "', '" + txtBoxSecId.Text + "')";

try
{
    string MyConnectionStringHere = "";
    using (var con = new SqlConnection(MyConnectionStringHere))
    using (var cmd = con.CreateCommand())
    {
        con.Open();
        cmd.CommandText = @"
        INSERT INTO tblBook (
            Book_ID,
            Name,
            Authour,
            Category,
            Donater_ID,
            Section_ID
            ) VALUES (
            @Book_ID,
            @Name,
            @Authour,
            @Category,
            @Donater_ID,
            @Section_ID)";
        cmd.Parameters.AddWithValue("@Book_ID", txtBoxBookId.Text);
        cmd.Parameters.AddWithValue("@Name", txtBoxBookName.Text);
        cmd.Parameters.AddWithValue("@Authour", txtBoxAuthour.Text);
        cmd.Parameters.AddWithValue("@Category", txtBoxCategory.Text);
        cmd.Parameters.AddWithValue("@Donater_ID", txtBoxDonaterId.Text);
        cmd.Parameters.AddWithValue("@Section_ID", txtBoxSecId.Text);
        if (1 == cmd.ExecuteNonQuery())
        {
            // declare success here!
        }
        else
        {
            // panic here.
        }
    }
}
catch (Exception ex)
{
    MessageBox.Show(ex.ToString());
}

• You'll still need to set a connection-string in the example, but you don't need SqlConnections in multiple methods, or as a member-variable. It will be closed when exiting the "using" statement.
  
• You want the complete exception-text; it will tell you where and more.
  
• Those column-names using up many lines may seem excessive to you; go stand on such a line in the IDE and press Ctrl-X. Move the cursor down two strokes and press Ctrl-V.
  

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Rick_Bishop wrote:

They aren't read only

using System;
using System.IO;

public static class Globals
{
    public const Int32 MaxFormWidth = 1000;

    public static String SerializeFileName { set; get; } = @"Data.xml";

    static readonly String SerializeFolderPath = @"MyAppSavedData";

    public static string GetSerializeFilePath(string filename = "")
    {
        if (filename != "" && SerializeFileName != filename)
        {
            SerializeFileName = filename;
        }

        string path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);

        path = Path.Combine(path, SerializeFolderPath, SerializeFileName);

        if(IsValidPath(path)) return path;

        throw new FileLoadException($"{path} is not a valid file path");
    }

    static bool IsValidPath(string path)
    {
        // code omitted
    }
}

public static String SerializeFileName { set; get; } = @"Data.xml";