DataSet bulk update problem - ASP.NET Discussion Boards

Hi Pilo,

Thanks. Its working.

Regards,

Prya

please give a simple code to understand easy since i am a beeginner ain asp.net

take it.
Link[^]

Pathan

Have you Tried?

http://www.programmingknowledge.com/DataGridCheckBox.aspx[^]

Hi i am using System.Data.OracleClient.dll file, on development computer its work fine.but when i deploy on server i am getting following error in web.config file in assembly section

The format of file System.Data.OracleClient is invalid

Any idea please.

Know Yourself Then Grow Yourself.

what version of .Net ur using and what version of SQL?

Windows Server 2003.
Framework 2.0
I am using Access database, and SQL Server 2000 also installed on server.

Know Yourself Then Grow Yourself.

Hi,

I am developing a web appication using asp.net with c#.
I am updating Dataset using datgrid EditItemTemplate and storing in cache.
finally i want to update my table using SqlAdaptor Update mathod but i am gatting error.Please help me..

This is my Dataset Update mathod:
public void grdEmployee_Update(Object o,DataGridCommandEventArgs e)
{
int id = (int)grdEmployee.DataKeys[e.Item.ItemIndex];
TextBox txtName,txtDesignation,txtSex,txtAge,txtSalary;
txtName =(TextBox)e.Item.Cells[0].Controls[0];
txtDesignation =(TextBox)e.Item.Cells[1].Controls[0];
txtSex =(TextBox)e.Item.Cells[2].Controls[0];
txtAge =(TextBox)e.Item.Cells[3].Controls[0];
txtSalary =(TextBox)e.Item.Cells[4].Controls[0];
if (Cache["EMPCACHE"]!=null)
{
DataSet dsUpdate= (DataSet)Cache["EMPCACHE"];
dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["NAME"]=txtName.Text;
dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["DESIGNATION"]=txtDesignation.Text;
dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SEX"]=txtSex.Text;
dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["AGE"]=Convert.ToInt32(txtAge.Text);
dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SALARY"]=Convert.ToSingle(txtSalary.Text);
dsUpdate.AcceptChanges();
Cache["EMPCACHE"]=dsUpdate;
grdEmployee.EditItemIndex = -1 ;
grdEmployee.DataSource = dsUpdate;
grdEmployee.DataBind();
}}

Finally i am going to update on Database using this code
private void btnDatabaseUpdate_Click(object sender, System.EventArgs e)
{
try
{
string strConnection= System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
SqlConnection con = new SqlConnection();
con.ConnectionString = strConnection;
SqlDataAdapter sda = new SqlDataAdapter("select ID,NAME,DESIGNATION,SEX,AGE,SALARY from EMPLOYEEDETAILS",con);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Fill(dsObj,"EMPLOYEEDETAILS");
DataSet dsUpdate = (DataSet)Cache["EMPCACHE"];
dsObj = dsUpdate.Copy();
int success=sda.Update(dsObj,"EMPLOYEEDETAILS");
dsObj.AcceptChanges();
grdEmployee.DataSource = dsObj;
grdEmployee.DataBind();
}
catch (Exception ex)
{
Response.Write("
" + ex.Message.ToString());
}
}

I am gatting this error:
Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

waiting for promp reply

Hi all,

I am using validation controls on one of my pages. They work properly the first time and validation is done correctly. After I put all the right values in the fields and the fields are validates and the pages is posted to the server, the validation controls dont work anymore. If i mess up the fields, the validation controls dont catch the errors and allow the page to be posted to the server - this should not be happening.

Anyone ever had a problem like this? Any ideas on how i can conquer this.

Thanks in advance

Kulile --- RSA

Hey everyone,

Im pretty much a n00b to asp but have a bit of programming experience. Im currently workin on a little project for work which is driving me insane! I didnt want it to come to this (asking experts for help) but i feel the project needs some fresh eyes to guide me to a better solution. So let me just outline what im trying to do;

First, we have a large list of customers on our server, approx 1316 customers. Now on our intranet webpage i wish to create a fast way of finding customers using an ASP tree. So consider a list of customer names returned from an SQL query into a large array. I then wish to check the first couple of letters of each customer, and group customers with similiar names together under one branch in the tree.

The Result would look something like this;

Customers
|
|-A
___|-ar
______-arson, pat
______-arson, mick
______-arsen, jon
______...
______...
___|-as
______-asnot, mark
______...
______...
___|-Other A's
______...
______...
|-B
___|-ba
______|-bai
__________-bailey, john
__________-bailey, mark
__________...
__________...
______|-bar
__________-barker, paul
__________-barton, mike
__________...
__________...
___|-br
______-bromich, dave
______-brockurst, mick
______...
______...
___|-Other B's
______...
______...
|-C
___-charles, john
___-chaplin, pat
______-chan, johnny
|-D
___|-da
.
.
.
....

just to explain anything with a | beside it represents a branch which has leaves while anythin with just - represents a leaf which will hold a customer name

One main important thing about this code is that i want it to be very dynamic and one important feature is groups of similar names, being grouped in their own branch. For example the code should read like;

if there are less than X names beginning with 'ar' then group these names under a branch called 'ar'
But if there are more than X names beginning with 'ar' then search again through this group and compare the first 3 letters for similarity.

This idea is shown in the B section, here the code found more than X names with -ba as the first two letters, and so and the code ran again comparing the first three letters, these groups of three letters had less hits than X and so are plotted in their own trees -bai and -bar.

I hope you can follow me now as you read this and it makes some sort of sense!

I want it to be so dynamic that lets say, we enter many customers with names starting with -bai, the program will then scan the first four letters of the name and if this is over X, it will scan the first five letters of each name, if again theres more than X it will move onto scanning 6 letters.

Thats is why i call it 'intelligent sorting' i want it to be so streamlined that you could have 200 -bai customers sorted into 5 or 6 branches, while you may have only 5 -D customers which will only fall under the -D branch!

I've been trying to do this with a simple checkltr = left(myarray(1,k),3) command and lots of array sorting, which works. but when i move onto checking 4 letters and 5 letters the code gets way too big and eventually just becomes inefficient, there has to be a way of doing this with not much code.

Please, please, please if anyone can help it would be great!

Can any1 help please, i just need some advice on the best approach to this problem!

Since no-one knows how to do this can anyone direct me to a webpage or an .asp script that could do this!

Is there a name for this kind of sorting?

Line 18: <providers>
Line 19: <add name="AspNetSqlSiteMapProvider"
Line 20: type="SqlSiteMapProvider"
Line 21: description="SQL Server site map provider"
Line 22: securityTrimmingEnabled="true">

Trying to implement SqlSiteMapProvider from Jeff Prosise (MSDN) but get the above result (error on line 20).

Anyone can teach me how to solve the problem?

Hi All,
I built multiple datagrid controls on my asp.net page in the code behind.
I create the datagrid control, set its properties including ID, define its columns then binds data to it from database queries.all these are done in the code behind not at the design time(i didn't drag and drop the datagrid control from toolbox)
I allow paging in each datagrid.
I need to add handler to enable the paging.
I don't know how to do that.
Please help.
thanks
Samah Helal

Hi How to run an Dotnet Application in the system which donot have dotnet framework installed.

Reply soon.

Thanks & Regards,
Hari

write a asp.net app, browse from the machine where u dont have .Net

Please Help Me Everyone!
That's several days I have started to make possible for my project manager to create crystal report at runtime (ReportGenerator), but I haven't find solution yet.
Answer these Qs my friends in CodeProject, please :
1. What's the best way for my target?
2. Is it possible to add ReportObject to ReportDocument and set Datasource for it and ... , otherwise create Reports at Runtime.

Sincerely bye.

HI friends,
i'm Using asp.net 2.0. i hosted my asp.net application at other host application.
Problem is when i deployed it Host application , my application is not considering my Bin folder ,it is using Host application Bin Folder.

how can i use Bin folder at my application...? D'Oh! | :doh:

Thanks and Regards,

-- modified at 2:29 Tuesday 12th December, 2006

Vijay Kumar Daivam

where are inmemory cookies stored in asp.net

ravi

They aren't. The cookies are always stored by the browser, not on the server.

---
It's amazing to see how much work some people will go through just to avoid a little bit of work.

Its stored onto the Temporary Internet files Folder in the user's PC

keep Learning and you never will be out of date...

hi friends,
i have made an application using vs 2005, i have used aspnetdb as database for security of the application and i am using all the controls login control,password recovery etc.
my problem i have assigned some roles in my application administrator,itstaff,users when i am logging as an administrator and creating a user using createuserwizard my current account is changing to user account.
how to solve this problem.

regards jabbar

jabbarsb

I have a textbox control, which is binded through code, to populate a listbox which brings the matches of the textbox control from a database. All this works perfectly, but the listbox is always shown to the user. I want to let the listbox be visible when the user press any key and some data is populated to the listbox.
I had tried doing it with the ajax popupcontrolextender, but it doesn't work as demanded.
Pls help.

add an attribut in text box in page_init method like :
page_init()
{
TextBox.Attribute.ad("onkeypress","javaScriptFunction()")
}

in javascript body

JavaScriptFunction()
{
var obj=document.getElementByid("TextBoxID");
obj.visible=false;
}

it's kind of a suggetion u can do with the help of.

Keep Smiling !!!
Parwej Ahamad
g_parwez@rediffmail.com

Dear All,
I am bit new to asp.net. i am making web application using C# and asp.net. In a web form i have multi selectListBOX that i am populating from table. I want users to be able to select multiple items.When the form is submitted it should create as many rows in the table as selections.
HOw this can be done. please Help

Thanks in advance for your help.

-- modified at 2:33 Tuesday 12th December, 2006

regards
imran khan