C#-Sql How do I connect DataGridView-label?

Question

I saved the text "** EXAMPLE **" in the first picture to the "Kurallar" column in the database and as 123 to the "Id" column.
In the second picture, when I type 123 into the TextBox under the DataGridView and click the "Göster" button, I want to show the text in the "Kurallar" column of the data with Id = 123 on label22.Text in the third picture.
I hope I could explain.

 Kurallar kurallar = new Kurallar();  
            SqlConnection baglanti5 = new SqlConnection(@"Data Source=(localdb)\mssqllocaldb;initial catalog = ELibraryInformation;integrated security = true;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");  
            baglanti5.Open();  
            SqlCommand komut5 = new SqlCommand("SELECT (Id) FROM [Table]", baglanti5);  

Please continue with the above code

Answer 1

FİNİSHED

I solved my problem by creating a new label. I also created a method to get better lines of code. all codes below ...

 public void kuralGöster()
        {
            SqlConnection baglanti5 = new SqlConnection(@"Data Source=(localdb)\mssqllocaldb;initial catalog = ELibraryInformation;integrated security = true;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
            baglanti5.Open();
            SqlCommand komut5 = new SqlCommand("SELECT (Kurallar) FROM [Table] WHERE [Id] LIKE '%" + tbxAyarlarSil.Text + "%'", baglanti5);
            label1.Text = komut5.ExecuteScalar().ToString();
            baglanti5.Close();
        }

kuralGöster(); ==> button2_Click and other form(Kurallar)'s Load part

private void Kurallar_Load(object sender, EventArgs e)
        {

            this.FormBorderStyle = FormBorderStyle.FixedSingle;
            Ayarlar ayarlar = new Ayarlar();

            ayarlar.kuralGöster();
            label22.Text = ayarlar.label1.Text;
        }

Answer 2

Hi

using System;  
using System.Collections.Generic;  
using System.ComponentModel;  
using System.Data;  
using System.Drawing;  
using System.Text;  
using System.Linq;  
using System.Threading.Tasks;  
using System.Windows.Forms;  
using System.Data.SqlClient;  
using Dapper;  
using DevExpress.XtraEditors;  
using System.IO;  
using EmployeePro.Model;  
  
namespace EmployeePro.View  
{  
  public partial class frmViewEmployee : DevExpress.XtraEditors.XtraForm  
  {  
    public frmViewEmployee()  
    {  
      InitializeComponent();  
    }  
    SqlConnection con=new SqlConnection("Data Source=.;Initial Catalog=TestDB;Integrated Security=True");  
      
  
    BindingSource bsEmployee=new BindingSource();  
    private void frmViewEmployee_Load(object sender, EventArgs e)  
    {  
      con.Open();  
      List<CLS_Employee> emp = con.Query<CLS_Employee>("SELECT Id,Fname,Lname,Adrs,Image_Employee,FinalTotal  FROM [dbo].[Employee]").ToList();  
      bsEmployee.DataSource=emp;  
      dgvEmployee.DataSource=bsEmployee;  
        
      con.Close();  
    }  
  
     
    private void gcEmployeeView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)  
    {  
       
      label1.Text = gcEmployeeView.GetFocusedRowCellValue("Id").ToString();  
           Byte[] image = (byte[])(gcEmployeeView.GetFocusedRowCellValue("Image_Employee"));  
  
            MemoryStream ms = new MemoryStream(image);  
            piBox.Image = Image.FromStream(ms);  
    }  
  
     
  }  
}  

Best Regards.
Please remember to mark the replies as answers if they help.

Answer 3

@Abdulhakim M. Elrhumi ,
As far as I know, there is no .Query() method for the SqlConnection class. Where did yours come from? I bet that it is an Extension method? Probably has something to do with that DevExpress stuff you've got there.

@Oğulcan Akca ,

Are you "persisting" the data that you retrieve from the database to a List or a DataSet/DataTable? Or are you reading the data from the database and entering it directly into the DataGridView's rows/column? (you shouldn't be doing this if you are). You're going to want to do some databinding, using a BindingSource, if you're not already.

You're also going to need to be able to pass the data to your Settings Form. I have a blog post that describes several methodologies to use to do that.

See these links to my blog posts:

http://geek-goddess-bonnie.blogspot.com/2011/01/passing-data-between-forms.html
http://geek-goddess-bonnie.blogspot.com/2012/12/passing-data-between-forms-redux_31.html

And this one is often relevant too:

https://geek-goddess-bonnie.blogspot.com/2010/06/program-to-interface.html

Hope that helps!
~~Bonnie

Answer 4

I searched for Id with tbxSettingsSil.Text and wrote the following to show the "Kurallar" column this Id on label22.Text, but it still didn't. What's my mistake ?

  SqlConnection baglanti5 = new SqlConnection(@"Data Source=(localdb)\mssqllocaldb;initial catalog = ELibraryInformation;integrated security = true;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
                    Kurallar kurallar = new Kurallar();
                    baglanti5.Open();
                    SqlCommand komut5 = new SqlCommand("SELECT (Kurallar) FROM [Table] WHERE [Id] LIKE '%" + tbxAyarlarSil.Text + "%'" , baglanti5);
                    kurallar.label22.Text = komut5.ExecuteScalar().ToString();
                    baglanti5.Close();