Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

how to data in gridview ?

Home
Forums
Learn iOS Programming

how to data in gridview ?

Ashutosh Pandey

13yAsked Aug 22, 2013, 2:51 AM1.1kLearn iOS Programming

GridView1.DataSource=command.executeReader();
GridView1.DataBind();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Iftikar Hussain13y ago
Hi,
Try like this

private void LoadData()
{
string strConnString = @"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=Mypassword";
using (SqlConnection con = new SqlConnection(strConnString))
{
string query = "select *from YourTable";
DataSet ds = new DataSet();
con.Open();
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
dataAdapter.Fill(ds);
con.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
}
}

Regards,
Iftikar
Sanjeeb Lenka13y ago
hi,

What the error you are getting..

try like this:

protected void BindGridview()

{

using (SqlConnection con = new SqlConnection("Data Source=Sanjeeb;Integrated Security=true;Initial Catalog=MySampleDB"))

{

con.Open();

SqlCommand cmd = new SqlCommand("Select UserName,LastName,Location FROM UserInformation", con);

SqlDataReader dr = cmd.ExecuteReader();

gvUserInfo.DataSource = dr;

gvUserInfo.DataBind();

con.Close();

}
}