ASP.NET 2.0 wrote:

and write this in for loop.

Means, I have to write this whole code in for loop of each and every row of DataTable or this is enough ?? Thanks for your posting. Please, Reply of this my confusion. Thanks in advance.

Regards, Abhi

Hi... All I've database table named : tblCategory. The Table's structure is like : ChildID-------Category Name---------ParentID 1------------ Category 1 ---------- 0 2------------ Category 2 ---------- 1 3------------ Category 3 ---------- 1 4------------ Category 4 ---------- 2 5------------ Category 5 ---------- 3 6------------ Category 6 ---------- 4 Here, For Example : 'Category 4' is the Child Record of 'Category 2' because 'Category 4's ParentID is 2. Now, I want to find the all child record from ParentID. Like : If I entered simple ParentID 1, then I want the all nested child record of Parent 1. So, If Possble, Please give me sql query of it or any relavant solotuion. Thanks is advance.

Regards, Abhi

Sonia Gupta wrote:

According to my understanding , Dataset can contain any no of tables.

If It containg any number of tables, then It will occupy more bandwidth and server memory while the in the running mode, when number of user more then 10000. So, I think there should be a limit. But I dont know it !! Thanks.

Regards, Abhi

Hi..All Please, Give me answers of this question : How many maximum DataTable can contains by DataSet ?? Thanks in Advance.

Regards, Abhi

Kasi Viswanathan wrote:

out time of(02:42:15) with in time of(02:43:20)

Try this : TimeSpan T1=new TimeSpan(System.DateTime.Now.Day,System.DateTime.Now.Hour,System.DateTime.Now.Minute,System.DateTime.Now.Second,System.DateTime.Now.Millisecond); TimeSpan T2=new TimeSpan(System.DateTime.Now.Day,System.DateTime.Now.Hour,System.DateTime.Now.Minute,System.DateTime.Now.Second,System.DateTime.Now.Millisecond); string ans = T2.Subtract(T1).ToString(); Hope this will help you !!

Regards, Abhi

Piyush Vardhan Singh wrote:

COM type dll use in asp.net or not

Yes. Sure You can use your COM component in Asp.Net.

Regards, Abhi

Yes... This path works best in my Local project in my machine. But after uploading this project DLL to the server by FTP... Then I got error. I have used below code : System.Security.Permissions.FileIOPermission fp = new System.Security.Permissions.FileIOPermission(System.Security.Permissions.FileIOPermissionAccess.AllAccess, objFileInfo.Directory.FullName); But, I cant find solution with above permission code, this code is meaning less.

Regards, Abhi

Yes. Sure. System.IO.FileInfo objFileInfo = new System.IO.FileInfo(Server.MapPath("../File/") + Filename.ToString()); System.Security.Permissions.FileIOPermission fp = new System.Security.Permissions.FileIOPermission(System.Security.Permissions.FileIOPermissionAccess.AllAccess, objFileInfo.Directory.FullName); objFileInfo.Delete();

Regards, Abhi

No, Navneeth !! Not any files are open on the server. In my project, I have a admin panel.. With this, I m uploading file, and it uploads successfully... And Then, I m listing all files name and with button 'delete' for each file !! But when, I click on 'delete' button , I am deleting files from server by C# code..Then I got this error !! Regards, Abhi

Regards, Abhi

No, Sandeep !! Not any files are open on the server. In my project, I have a admin panel.. With this, I m uploading file, and it uploads successfully... And Then, I m listing all files name and with button 'delete' for each file !! But when, I click on 'delete' button , I am deleting files from server by C# code..Then I got this error !!

Regards, Abhi

Hi.. Friends.. When I delete file with C# code, I m getting error like "Access to the path 'g:\activewebroot\Active24\w11618838\web\content\File\xxx.zip' is denied." But I can upload new files on server, But I cant delete this files !! I dont know, Why this problem occurred ?? Please, Give me any solution ASAP. Thanks in Advance.

Regards, Abhi

Yes. Sure. See, I have a 'CartList' user control. Now, this 'CartList' control contais a 'private void BindCart()' methods that binds the current product items to the grid view those are purchased by client. Now, In my 'ProductListing.aspx' I have to refresh this User Control my 'Add to Cart' button click. Now, What i have done is : 1. I have made 'private void BindCart()' methods to 'public void BindCart()'. So, I have made public methods in my UserControl. 2. I have first of all inserted all product to the 'tblCart' those are purchased by client. 3. Then, I called this Methods on 'Add to Cart' button click event. Ex. ProductCart1.BindGrid(); 4. So, Now I've a refreshed product cart on my same page. That's it. Thanks for this conversation.

Regards, Abhi

Thanks so much from your reply post... But, the thing is that.. I got solution by other way... Thanks a lot !! Take care.. Bye.

Regards, Abhi

Hi.. Friends !! I want to refresh my user control after clicking on button... Means, I have a shopping cart page, and when I click on 'Add to Cart' button from GridView, I want to reload my 'CartListing' user control on the same page... Because, When I click on 'add to cart' button, It simply postback the current page, And I can not see the last added product in cart listing user control !! So, I have to dynamically refresh my 'CartListing' user control... And I dont know to to refresh it after clickin on button... So, If you have any idea regarding it, please given me ASAP Thanks in advance !! Bye.. Take care.

Regards, Abhi

SQL Server 2000 database 'bit' type problem. --------------------------------------------- I haven't given any initial value of that field in design time For Ex. The current value of 'Active' field is : 0 Now, I'm fire a update query of other fields except 'Active' field. But, this query update the value of 'Active' field with 1. Means, I haven't use this 'Active' field in my Query. My Query is : update tblProduct set Name = 'xxxx' where ProductID = 1 but, After fire this query, My 'Active' fields value become 1, while it was 0. So, This is my problem. Hope you will get this now. Please, Help me as soon as possible. Thanks. -- modified at 1:41 Friday 14th September, 2007

Regards, Abhi

I haven't given any initial value of that field in design type. Foe Ex. The current value of 'Active' field is : 0 Now, I'm fire a update query of other fields except 'Active' field. But, this query update the value of 'Active' field with 1. Means, I haven't use this 'Active' field in my Query. My Query is : update tblProduct set Name = 'xxxx' where ProductID = 1 but, After fire this query, My 'Active' fields value become 1, while it was 0. So, This is my problem. Hope you will get this now. Please, Help me as soon as possible. Thanks.

Regards, Abhi

Hi.. All I've a database table's 'bit' field type problem. The problem is : When I fire any update query to the table, my 'Active' (bit type) field automatically updated to value 1. But I have not taken this field in my update query. But this update query update the value of 'bit' field with 1. Please, Give me any solution as soon as possible. Thanks in Advance..

Regards, Abhi

You have to make a little change in your code.. Code: ===== Remove this code --------------- TextBox1.Text = str Apply this code --------------- 1. Take a one image html control on the form. like. 2. In the server side , Write this code.. MyImage.Src = server.mappath("" + str); Hope this will help you, Regards, Abhi

Hope you will find yourself..!! Regards, Abhi

Try this site : http://www.zazzle.com/ You can see the functionality and also get reference from it.. Good Luck.. God helps those, who helps other.