Data Access and ObjectDataSource Control | Forum profile

Why dont you do the following: public static List<GroupResultsResul> GroupResults(Guid UserId) { dsDataContext db = new dsDataContext(); List<GroupResultsResult> myresults = db.GroupResults(UserId).ToList(); return myresults; } then u can iterate through the list like so foreach(GroupResultsResult item in myresults) { }

check this http://aspsnippets.com/post/2009/02/04/Read-Excel- using-ADONet.aspx

I'm not sure I'd recommend it. I don't know why you would want to. I've never heard of anyone wanting to. If you want to do it for security reasons, there are better ways. http://msdn.microsoft.com/en-us/library/89211k9b(V S.80).aspx

Hi, If Ur Code is Numberic then Try "Code = 01"

Hi, instead of writing all that code inside an sql datasource event sink (siteDS_Updating), you can write that code on a button click, for eg., something like this: siteDS.UpdateParameters(0).Value = HttpContext.Current.User.Identity.Name; siteDS.Up date();

Hi, Try this below. DataTable dt = new DataTable(); dt.Columns.Add("EmployerDesc", typeof(string)); //loop through your dataset to assign into datatable foreach (DataRow dr in dsEmployee.Tables[0].Rows) { dt.Rows.Add(dr["EmployerDesc"].ToString()); }

Will You plz give the code where u are using the session variable here no session variable so plz give some idea how u are using the session variable with this function

There is no limit on the datset size. But we get performance issues with the huge dataset. It will depend on the amount of memory that is available to the application.

Hi, if want Pass paramter using Asp.net then chk the below ,mention link http://www.c-sharpcorner.com/UploadFile/gtomar/sto redprocedure12052007003126AM/storedprocedure.aspx http://aspalliance.com/673_CodeSnip_Calling_a_Stor ed_Procedure_from_ASPNET_20 http://www.wwwcoder.com/Default.aspx?tabid=68&site =5014&parentid=255&type=art

hi, check your database columns i.e (gameName, gamePlatform) are set to varbinary or not , if it's varbinary then while adding parameter also you need to set SqlDbType.VarBinary instead of SqlDbType.VarChar

Can u post ur store procedure

Hi, Ther may Be problem with path Server.MapPath("../ExcelImport.xls") OR string MyPath = System.IO.Path.GetDirectoryName(Filename); string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +MyPath + ";Extended Properties='text;HDR=Yes;FMT=Delimited'"; string CmdText = "select * from " + System.IO.Path.GetFileName(Filename); OleDbConnection Con = new ...

do this.... if (!IsPostBack) { //any thing else u want } else { DetailsView1.DataSourceID = "ODS2"; DetailsView1.DataBind(); }

Try this: protected void DSAccountOverView_Inserted(object sender, ObjectDataSourceStatusEventArgs e) { if (e.Exception != null) { lblWarning.Text = e.Exception.Message; e.ExceptionHandled = true; } }

Hi, http://wiki.asp.net/page.aspx/978/sqlbulkcopy-with -cnet/ chk the sample above... Before Wrting To server just CHK At the trequired fileds are in Datable.. OR Post the code

Why dont you do the following: public static List<GroupResultsResul> GroupResults(Guid UserId) { dsDataContext db = new dsDataContext(); List<GroupResultsResult> myresults = db.GroupResults(UserId).ToList(); return myresults; } then u can iterate through the list like so foreach(GroupResultsResult item in myresults) { }