C#

How to get an answer to your question

Be specific!
Don't ask "can someone send me the code to create an application that does 'X'.
Pinpoint exactly what it is you need help with.

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";