Category: Databases

Hi, I'm using a MDB database that i would like to filter based on selections made in 2 comboboxes.

say: cmbBase and cmbMix.
cmbBase connects to "Base"
cmbMix connects to "Mix"
I have use the automated database method in C#
Click Here

 private void BaseMixBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.BaseMixBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.DSBaseMixDataSet);

        }

        private void frmImport_Load(object sender, EventArgs e)
        {
//filter out doubles

                    cmbBase.DataSource = DSBaseMixDataSet.BaseMix.Select(x => x.Base).Distinct().ToList();


        }

The problem is that i have no idea how i can filter the other combobox in such a way that it only shows the data in the next row of the selcted combobox.

So if i select "A" in cmbBase, cmbMix should only show the values "A+1; A+3; A+6" if there were only a few values i could use an if function, but this is a database with a lot of numbers. I tried many of the solutions i found, but none of them work as i expected. Anyone that can help me out here?

hello,
im developing a Windows application with MariaDB database for criminals, i designed the whole database schema but i need an expert to help me study it if it is mall designed.

Do you think blockchain will replace the traditional database

Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query:

IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition
FROM sys.columns
WHERE name = 'ModifiedDate'
AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE())

However, you can not compare a function (GETUTCDATE()) to this Select Statement. I need to do it this way because I am building an update script and it can only update the table IF the table definition is NOT equal to UTC TIME Any ideas? Thank you

Hi all.

i have a trouble of my testing project. could anyone can guide me to solve the problem. million thanks~~ newbie of programming.

error : System.Data.SqlClient.SqlException: 'Incorrect syntax near 'card'.'

string connectionstring = ConfigurationManager.ConnectionStrings["library2ConnectionString"].ConnectionString;

SqlConnection con = new SqlConnection(connectionstring);

        con.Open();

        string sql = "Select librarycardid, password" + 
            "from library card information" +
            "where librarycardid = '" + librarycardid + "'" + 
            "and password = '" + password + "' ";

        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataReader reader = cmd.ExecuteReader();  <<<<<<error at here 

        if (reader.HasRows)
        {

            Label3.Text = " login success";
        } else {
           Label3.Text = "login fail";
        }

con.Close();