🔒 Closed Help ASAP C# Begginer!!

[PHC - Naethan]

wala akong alam dyan. gawa ka na lng bago thread sa programming section

sige salamat parin

 

[deanmonio81]

windows b to o web?
anu sql m? sqlserver

 

[1nn0c3ntv5]

Siguro ni run mo dati at nag lagay ka lang ng <form name>.close() o baka naka run yung app mo sa background task. Punta ka task manager tas tignan mo kung nandun yung naka execute na program. I end task mo pag nakita mo then run mo ulit.

 

[den lee]

Pano nga mag Display sa Data Grid View gamit SQL? INSERT ba??

Select * query then show

 

[deanmonio81]

tama yang query m select..

dapat m lng ibind yung datagriedview sa result ng query m

sample
You do not have permission to view the full content of this post. Log in or register now.

 

[hase0278]

Pano nga mag Display sa Data Grid View gamit SQL? INSERT ba??

Ito gamitin mong code edit mo na lang depende sa kailangan mo:

using (adapter = new SqlDataAdapter("SELECT * FROM tbl1", connectionString))
{
    DataTable data = new DataTable();
    adapter.Fill(data);
    dataGridView1.DataSource = data;
}

 

[Katipunero-]

Ito gamitin mong code edit mo na lang depende sa kailangan mo:

using (adapter = new SqlDataAdapter("SELECT * FROM tbl1", connectionString))
{
    DataTable data = new DataTable();
    adapter.Fill(data);
    dataGridView1.DataSource = data;
}

This one is good. (Dahil sa paggamit ng auto-dispose)
But you can improve this by using parameters.

 

[programtayo_bspotcom]

Para mapopulate mo ang DataGrid, eto example


private void BindGrid()
{
string constring = @"Data Source=.\SQL2005;Initial Catalog=Northwind;Integrated Security=true";
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("SELECT CustomerId, ContactName, Country FROM Customers", con))
{
cmd.CommandType = CommandType.Text;
con.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
dataGridView1.DataSource = dt;
con.Close();
}
}
}

 

[programtayo_bspotcom]

Dapat yung close mo before sa return. Kapag nagreturn ka lahat ng code after non di na ma-eexecute.

 

[programtayo_bspotcom]

Kailangan mong gumamit ng SqlCommand.