|
ok, thanks for your solution
angela
|
|
|
|
|
Hi
I have a simple web page that written in C# and Asp.Net.
In that page i have asimple insert query that work by
Microsoft Accees .
When I run it in my camputer az a project I don't reciev this message but when i placed on my host or on my iis I reciev this massage .
If You Know How Can I solv this problem plz
answer me az soon az possible:->
Thanks alot .
-- modified at 8:22 Sunday 11th June, 2006
|
|
|
|
|
isiran wrote: When I run it in my camputer az a project I don't reciev this message but when i placed on my host or on my iis I reciev this massage
Sounds like a permissions issue. Make sure the db is in a location where the web user has permissions to write to.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
-- modified at 2:33 Tuesday 13th June, 2006
|
|
|
|
|
Hi
I checked it befor.
I have write access on my db folder on my camputer an host.
Thansk alto.
|
|
|
|
|
isiran wrote: I checked it
mmmm
isiran wrote: I have write access
Your account and the web user account are differnt, remember that ISS runs with different (even more restricted) permissions than you.
Failing a permissions issue, I have no idea then. The only issues I have expereinced and seen posted on the net have been permissions related.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
|
isiran wrote: Thanks
Your welcome, its nice to help polite people.
So I take it, the problem was a permissions one?
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
Hi
Yes it is and I checked every permissions on my folder on my host that contains my db file .I had write permission;)
I checked my host permissions on my folders(what ever that every one noticed me!)
But I had this problem yet
If U can plz help me.
Thanks alot.;)
|
|
|
|
|
I have a problem in microsoft access -- How i can retrieve AutoNumber Field After Insert a new record in microsoft access 2000
Is any one answer to me ?
|
|
|
|
|
I found my solution. it is Max(FieldName)
|
|
|
|
|
I have two datasets,
one derived from a database.
one derived from an xml file.
Is there any way to compare both these datasets?
Thanks,
Fen
|
|
|
|
|
If the schemas are the same, the you will basically need to create 2 'diff' files.
Begin in the first dataset, and go through each table, and each column. Check the other dataset to see if that row exists, and if it does check to see if the values in each column exist.
What you do with the 'diff' data is up to you.
|
|
|
|
|
I'm working on an Access DB and the OLEDB data adapter in a VB.net project,
I've a windows form in vb.net called Customers orders (partno,name,orderedquantity)
When I fill all the texts with it's data Pay attention to the txt of( the ordered quantity ) ,then I press the oreder button which save the entered data to it's table in the DB.
How can I make the (avaliablequantity) column in the other table (parts) updates it's selfe according to the ordered quantity.
I made an update query in the Access which update the table just when I click on it here it's( .
Please help me how can I make the update process work through the following code of the Customerorders .
<br />
Dim as strcon<br />
Try <br />
Strcon="provider=Microsoft.jet.oledb.4.0;data source=Sales.mdb" <br />
<br />
Dim con as new oledbconnection(Strcon)<br />
Con.open<br />
Dim cmd as new oledb command<br />
cmd.commandtext=" insert into parts (orderno,partno,orderedquantity)values(" & textbox1.text & "," & textbox2.text & "," & textbox3.text & ")"<br />
cmd.executenonqeur<br />
<br />
con.close<br />
catch exp as exception<br />
msgbox(exp.tostring)<br />
end try
with thanx
-- modified at 9:35 Saturday 10th June, 2006
|
|
|
|
|
You will need to run another query to update that table
"update available_parts set quantity = quantity - " & textbox3.text & " where partno = " & textbox2.text
You should really look into using parameterized queries. Also rename textbox1, 2, 3 to something more meaningful.
|
|
|
|
|
How I can Stop Error Message When any exception occurred like where divide by zero exception occurred then error message came. But I don't want to display that message and come my message. Please give any Query example to stop error message.
Rakesh Jha
|
|
|
|
|
use loop
try<br />
{<br />
}<br />
catch<br />
{<br />
}
-- modified at 6:27 Saturday 10th June, 2006
|
|
|
|
|
albCode wrote: use loop
I don't see a loop
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
hi whan i try to connect to my database and fill the dataset it take about (2&3)minutes to fill dataset even if the table i fill from contain (2 or 3) rows i don't know why it take this is time to fill dataset and the application is hang_up until it's finishing fill dataset
and how i could increase data base performance and speed in fill and reterive data
i write that code but i it is doesn't effect the fill process it's still slow like it
***********************************The Code*******************************
Try
DataSet21.EnforceConstraints = False
DataSet21.Tables(0).BeginLoadData()
SqlDataAdapter1.Fill(DataSet21, "categories_dir_sp")
DataSet21.Tables(0).EndLoadData()
Catch ex As Exception
MsgBox(ex.Message)
End Try
**********************************************************************
ma_refay
|
|
|
|
|
How long does the stored procedure take when running in Query Analyzer?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
hi iam work in project and we use disconnected db in our project
what is the scenario?
1- we create adapter that contain 4 stored procedures (insert_update_delete_insert)
2-we generate dataset
4-the adapter create sqlconnection
4- in the add button (that we use to add new product to our database i write the code down but it dosn't work no new rows are add to database )
i need to know where the wrong
****************the code******************************************
Try
SqlInsertCommand1.Parameters("@category_name").Value = TextBox2.Text
SqlInsertCommand1.Parameters("@category_description").Value = TextBox3.Text
DataSet21.AcceptChanges()
SqlDataAdapter1.Update(DataSet21, "categories_dir_sp")
Catch ex As Exception
MsgBox(ex.Message)
End Try
***********************************************************************
no rows are add to database what is the wrong in my code
ma_refay
|
|
|
|
|
Hi,
I would like to know what is the advantage of using Sql types in C# like SqlString, SqlInt32,etc... versus the normal type string, int etc...
The scenario: Having a class representing each table of the database. Each class has Insert, Update, Select, Delete methods (plus possible others) to perform those operations on the specific table represented by the class. Will there be a significant improvement of performance if my class variables are SQL types or not really?
Thanks for the insight.
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
Depending on how you use those classes, it could even hurt performance. Type conversion is going to occur every time you need to display or update a class instance variable that is SqlString, for example. On the other hand the conversion would normally only happen once per database read or write if the variables were normal String types.
Also, it's normally better to model your classes after business objects, rather than the database structures, that makes it easier to co-ordinate multi-table updates.
|
|
|
|
|
Thank you for the advice. You're right, I do perform a lot of type conversion everytime I want to display or update data from the database. I guess I will revert back to normal types
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
Hi!
Don't forget that there is another big difference between Sqlxxx types and the normal types: Sqlxxx types can be null (Property Null ). If your fields support null-values you should use Sqlxxx types.
Regards,
Rainer.
Rainer Stropek
Visit my blog at http://www.cubido.at/rainers
|
|
|
|
|
Hi,
Yes exactly, I do have some fields that are allowed to be null, in fact I decided to use Sqlxxx types because of that null thing, but I guess I can get around this by putting empty strings for string values and some special integer value (like -1) for int values.
Thanks for pointing this out.
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|