|
Hi,
I have a grid with 10K rows
and i'm trying to convert it to datatable.
<br />
First Ex.<br />
DataTable dt = (DataTable)GridViewArgs.DataSource;<br />
<br />
Second Ex.<br />
DataView dataview = (DataView)GridViewArgs.DataSource;<br />
DataTable dt = dataview.Table.Clone();<br />
In both ex. i got an empty datatable (the grid has values).
Can someone please tell me what i'm doing wrong?
|
|
|
|
|
treuveni wrote: I have a grid with 10K rows
 Which is not good design! Why 10 K Records in a grid? Does it really make any sense? It will hit your application performance very badly. Show only those data that are required. Use some filter to show less amount of data.
treuveni wrote: DataTable dt = (DataTable)GridViewArgs.DataSource;
What is your Source of Gridview data ?
|
|
|
|
|
First example should works.
Second example:
DataView dataview = ((DataTable)GridViewArgs.DataSource).DefaultView;
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
If you are trying to retrieve the data after postback, datasource will return null unless you bind the data again.
If your GridView ViewState is not disabled, you can access the data by iterating rows and columns like this:
foreach(GridViewRow row in grdRawData.Rows)
{
myData = row.Cells[ColNum].Text;
}
If you are using controls, say TextBox, in GridView Columns, you can fetch the data by using FindControl method.
TextBox txtName = (TextBox)grdRawData.Rows[rowNum].FindControl("IdOfTextBox");
myData = txtName.Text;
Hope this will help.
|
|
|
|
|
I want to remove defaultvalue that dropdownlist captures when I bound the control to sqldatasource. So that user selects from list.
Secondly,
How to dropdown the list when it got focus.
Regards
Asif Rehman
|
|
|
|
|
Asif Rehman wrote: I want to remove defaultvalue that dropdownlist captures when I bound the control to sqldatasource. So that user selects from list.
Try this,
myDropDownList.Items.RemoveAt(0)
Asif Rehman wrote: Secondly,
How to dropdown the list when it got focus.
Didn't get your question 
|
|
|
|
|
Abhijit Jana wrote: Didn't get your question
Actually I'm basically a windows developer in which on gotfocus event I can dropdown list which makes user easy to select and type.
Is there any way when I dropdownlist gets focus it automatically opens(drop down).
Hope you understand what I'm trying to say.
Regards
Asif Rehman
|
|
|
|
|
|
سلام
من مي خوام يه كدي بنويسم كه مشخصات سخت افزاري سيستم رو با اگوريتم
aes
رمز كنه و به وب سايت كه طراحي كردم بفرستم
ميشه راهنمايي كنيد
مرسي
lf8898@yahoo.com
|
|
|
|
|
gghhmmll wrote: لاممن مي خوام يه كدي بنويسم كه مشخصات سخت افزاري سيستم رو با اگوريتم aesرمز كنه و به وب سايت كه طراحي كردم بفرستمميشه راهنمايي كنيدمرسيlf8898@yahoo.com
It means?!
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Blue_Boy wrote: gghhmmll wrote:
لاممن مي خوام يه كدي بنويسم كه مشخصات سخت افزاري سيستم رو با اگوريتم aesرمز كنه و به وب سايت كه طراحي كردم بفرستمميشه راهنمايي كنيدمرسيlf8898@yahoo.com
It means?!
Did you try to get it using language translator ? 
|
|
|
|
|
Yes, but translation wasn't helpful to understand his/her question.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Yes. I also did a try. But no luck ! Leave it, he need help, he has to express in english.
|
|
|
|
|
yeap...
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
gghhmmll wrote: سلام
من مي خوام يه كدي بنويسم كه مشخصات سخت افزاري سيستم رو با اگوريتم
aes
رمز كنه و به وب سايت كه طراحي كردم بفرستم
ميشه راهنمايي كنيد
مرسي
lf8898@yahoo.com
If it's a question, please ask it in English !
|
|
|
|
|
Questions in the forum should be asked in English.
|
|
|
|
|
hi
i want to learn XML,Xhtml. please provide me the help.
why we use XML,Xhtml?
|
|
|
|
|
|
|
|
XML: It provides a common medium through which people/organizations can exchange data regardless of their own data format. The data format can vary from one to another and XML resolves this problem.
I have no idea about Xhtml. You can learn more if you visit the links given above.
|
|
|
|
|
HI, I write the following code to connect to my database
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Data.ProviderBase;
using System.Configuration;
namespace Hostel.Models.DataAccessLayer
{
public class PersonDataSet
{
DataSet DS = new DataSet();
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HostelConnectionString"].ToString());
SqlDataAdapter PersonDataAdapter = new
SqlDataAdapter(new SqlCommand("SELECT * FROM Person_prs", Conn));
}
}
but after running get this error:
<br />
Error 1 A field initializer cannot reference the non-static field, method, or property 'Hostel.Models.DataAccessLayer.PersonDataSet.Conn'<br />
does any one has any idea?
|
|
|
|
|
Initialize the constructor. Also didn't contain any methods. Try like this
public class PersonDataSet
{
SqlConnection Conn = new SqlConnection();
public PersonDataSet
{
Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HostelConnectionString"].ToString());
}
public MethodPersonDataSet
{
DataSet DS = new DataSet();
SqlDataAdapter PersonDataAdapter = new
SqlDataAdapter(new SqlCommand("SELECT * FROM Person_prs", Conn));
}
}
|
|
|
|
|
Hi every one,
I am new programmer and need a good example of MVC. in MVC I Model part I wanna use Dataset. Could you please give me an example or link regarding how to use Dataset in MVC model. I just need to insert data.
to be honest, I went trough internet by couldn't get good example.
I would please if some one help me.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
