|
hiii
how can i get the column values(int) from database...
this code is not workin:....
while (dr.Read())
{
string dqty = (string)dr["Quantity"];
string qty=Txtproductquantity.Text;
int Q = Convert.ToInt32(dqty) - Convert.ToInt32(qty);
string dtp = (string)dr["TotalPrice"];
string Tp = Txttotalprice.Text;
int tprice = Convert.ToInt32(dtp) - Convert.ToInt32(Tp);
conn.Close();
conn.Open();
sql="Update PurchaseProduct set Quantity=Q,TotalPrice=tprice where ProductId=@id AND ProductCategoryId=@catid";
}
|
|
|
|
|
Did you tried to follow my suggestion, that I have mentioned at your few post back. Please Buy some Beginners .NET book, and start reading.
This is not they way to learn.
|
|
|
|
|
Why don't to try to debug it?Then you will come to know what is actual problem whether data could not read properly or nay else
|
|
|
|
|
That's a poor way of reading from DataReader. Use the type safe accessors like GetInt32. Here[^] is more information if you are interested.
modified on Saturday, July 11, 2009 1:51 PM
|
|
|
|
|
Hi all,
I want to display path(Path of a word Doucument file) stored in a Table (Sql Server 2005) in FileUpload Control through coding.
Please Help me.
Thanks !
Pankaj
|
|
|
|
|
Pankaj18 wrote: I want to display path(Path of a word Doucument file) stored in a Table (Sql Server 2005) in FileUpload Control through coding.
What does it mean ?
|
|
|
|
|
Perhaps you should read this article[^] and that wil make clear what are properties of FileUpload control.
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.
|
|
|
|
|
You can’t assign values to file upload control. It is read only because of security reasons.
|
|
|
|
|
i get the directory this form:
string[] dirs = Directory.GetDirectories("d:\\");
this code show me all directory but i dont want see the hidden directory or system directory
how should i do, does any body know?
|
|
|
|
|
ptvce wrote: this code show me all directory but i dont want see the hidden directory or system directory
ptvce, you can check the directory attributes before displaying,
string[] dirs = Directory.GetDirectories("e:\\");
DirectoryInfo dirinfo = new DirectoryInfo(dirs[0].ToString());
Now, Check, dirInfo.Attribute and Match with FileAttributes.Hidden or FileAttributes.System, etc...
Hope this will help you
By the way, what you are trying to do it in ASP.NET ?
|
|
|
|
|
|
i wanna to get values from particular columns of the database and then subtract that value from the
textbox value.can u help me.i hav tried it....lik this
int q = dr.GetValues["Quantity"]- Convert.ToInt32(Txtproductquantity.Text)
|
|
|
|
|
pariofshona wrote: int q = dr.GetValues["Quantity"]- Convert.ToInt32(Txtproductquantity.Text)
Did you tried to debug it?
what dr.GetVales["Quantity"] return ?
|
|
|
|
|
int q = int.Parse(dr.GetValues["Quantity].ToString()) - int.Parse(Txtproductquantity.Text)
Be sure that dr.GetValues["Quantity].ToString() return integer value.
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.
|
|
|
|
|
|
Hi everyone,
I am working with Asp.net 1.1
I want to list folder items (newly add first or only newly add items only (display in datagrid)) sorting
i am trying this code
Dim objFSO, objFile, objFolder
objFSO = Server.CreateObject("Scripting.FileSystemObject")
objFolder = objFSO.GetFolder(Server.MapPath("~/big/"))
For Each objFile In objFolder.Files
Response.Write(objFile.Name & " : ")
Response.Write(objFile.DateLastModified & "<br>")
Next
objFolder = Nothing
objFSO = Nothing
please can any one help me on this script
or any other
Thanks
Kirthi
|
|
|
|
|
kirthikirthi wrote: please can any one help me on this script
What is the problem?
|
|
|
|
|
Thx for reply
I want to list folder items (Listing folder items(images) in datagrid)
But i want show
(newly added first or only newly added items in the folder and display in datagrid)
I am trying this code
Dim objFSO, objFile, objFolder
objFSO = Server.CreateObject("Scripting.FileSystemObject")
objFolder = objFSO.GetFolder(Server.MapPath("~/big/"))
For Each objFile In objFolder.Files
Response.Write(objFile.Name & " : ")
Response.Write(objFile.DateLastModified & "<br>")
Next
objFolder = Nothing
objFSO = Nothing
Thank you
Kirthi
|
|
|
|
|
I stopped development on framework 1.1 few years before. I think there is a function System.IO.Directory.GetFiles which will return string array of file names on a given folder name.
|
|
|
|
|
|
Response.Redirect("index.asp");
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.
|
|
|
|
|
It is very Rude to delete your message, after getting the Answer 
|
|
|
|
|
I didn't delete the question because I got the answer. The answer I got is poor. It didn't resolve my problem and don't think it will resolve anyone's problems also. I delete the question because I want to repost it in better manner so everyone can understand what I really need.
|
|
|
|
|
Deleting is not way to modify your question,you could edit your first post and modify it but not deleting it.
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.
|
|
|
|
|
astrovirgin wrote: The answer I got is poor. I
Then you should reply the member who gave you the answer that, your solution is not working, do you have any more idea on that? Simple. Not to delete the message.
astrovirgin wrote: I delete the question because I want to repost it in better manner so everyone can understand what I really need.
It would be better, if you modify the existing message, rather than thinking of Repost.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
