Comments by preet88 (Top 51 by date)

you can go for float, the same syntax can work for float by replacing int with float :)
my main motive is to tell how to do it.

thanks :)

yes i want to perform certain set of operation on selected data into the table
and then store that data into another one.

hi then you must be storing image data instead of url of image... for now i suppose you may to take asp:imagefield as suggested in solution 2 but i'm not sure if it works with data..
im able to find some links hopefully they may help you
http://www.aspsnippets.com/Articles/Display-images-from-SQL-Server-Database-in-ASP.Net-GridView-control.aspx
http://www.dotnetfunda.com/articles/article1084-saving-images-into-the-database-in-aspnet-and-displaying-to-the-gridview-.aspx
For future i suggest you that store relative path instead of image data as image data degrades your query performance..
thanks.

hi asim please make it clear from where you are getting the data or url of pic.

:) your welcome
mark your question as solved by accepting answer it may help others as well.
thanks :)

use ORDER BY in your query
like select * from tablename ORDERBY attributename

see it is possible to diplay whatever is there in your join queries

in your comboBox_SelectedIndexChanged event write like this

comboBox1_SelectedIndexChanged(object sender, EventArgs e){

if(combobox1.SelectedValue=="All") {

/* write your appropriate query here for fetching all the data(apply joins if you are having multiple tables)*/

}}I hope this will help :)

its ok hope it'll help :)

why you want 2 different select statement when you want to display whole data of orders and the details of customer related to that orders.
I suppose i may be getting your question wrongly.. Will you come again with little more explanation about what you want to do???

Hi friend please make it more ellaborative, it will help us to give solution in a better way.
thanks

hi Ranjith Reddy i have seen your same kind of problems with different styles of questions, it'll be better for all of us to answer if you'll post your question in same thread.
however for this i have mentioned in other post you can use rowCommand event as well as rowBataBound event..
thanks

thanks i have done some similar kind of code in javascript itself thanks for your help.

hi karthik yes you are correct i have resolved the problem and it is because of instance problem

sorry i didn't get that!!!
what exactly you are trying to convey..

thanks:)

i have tried that client id as well but not able to access
however without doing so in simple page i.e without master page is working well
So please if you can provide me the way to access that then it'll be great!!!
i've tried using this code '<%=form1.ClientId%>' to have client id in document ready

hi manohar
Abhijeet has given right answer. The best way to avoid this kind of errors is use the features of framework Drag-Drop image which you want to display.

thanks

how we can access all text boxes can you tell me??
for eg $(.textbox) refers to class of textbox
similarly if i want to refer all textboxes how to do that???

thanks

aah! sorry i was thinking it in a wrong way.
i think in this syntax you can also access the table
for eg from a in display.sometablename
select a;

here sometablename refers to a ienumerable class which has a same name that your table has in database and i hope that it may solve your problem i'm not sure but you can give a try

i hope you have looked into this as well
http://msdn.microsoft.com/en-us/library/cscsdfbt.aspx
check this post too
http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=21
hope you'll get answer to your queries.
Thanks

this a link i found it to be very precise and clear
http://www.w3schools.com/asp/asp_sessions.asp
however it is for asp but it hardly matters, it'll work well in asp.net as well.

this is another link which is gives you a detail on cookies
http://www.codeproject.com/Articles/31914/Beginner-s-Guide-To-ASP-NET-Cookies

hi afzal you can do this in other way also... you can have a class and store the data of the grid accordingly in the data members.
Once you have the data in class object you can pass that object to other page by get methods(if there is direct navigation from 1page to other) or you can also pass this using session variables

please specify the code that is giving problem to you.
we have not understood your problem. Apologies for that. please make it more ellaborative.

which row?? please mention clearly and make it more elaborative..
and mention in which table whether it is database table or html or table of dataset..

@enhzflep: thanks for sharing your knowledge. This is what i don't know.
Thanks

@CIDev thanks

my pleasure feel free to ask queries
thanks for accepting solution.

No its not if you want in c++ i suppose you have to do it in other way. it is for c#

you can use javascript for this.
it will be a good option according to me.
thanks

see you can access your control properties using the control object
if in case you are finding that control so do make a reference of that control and then access properties of control using that reference.
thanks

@chowdary2005 hi i have tried similar kind of code using int and for 100000 rows in datatable. i suppose there is no problem in the code for fetching data please debug into the code and check for the rows count or values in column whether they are present or not...

void BindMenu(){
String connectionString = WebConfigurationManager.ConnectionStrings["DatabaseConnectionString1"].ConnectionString;
SqlConnection con= new SqlConnection(connectionString);
SqlDataAdapter dadCategories = new SqlDataAdapter("SELECT CatId,CatName FROM Category order by CatName", con);
SqlDataAdapter dadSubCat= new SqlDataAdapter("SELECT SubCatId,CatId,SubCatName FROM SubCategory order by SubCatName", con);

//' Add the DataTables to the DataSet
DataSet dsCat =new DataSet();

con.Open();
dadCategories.Fill(dsCat, "Category");
dadSubCat.Fill(dsCat, "SubCategory");


//' Add a DataRelation
dsCat.Relations.Add("Children", dsCat.Tables["Category"].Columns["CatId"], dsCat.Tables["SubCategory"].Columns["CatId"]);
//' Add the Category nodes
int count = 0;
foreach( DataRow categoryRow in dsCat.Tables["Category"].Rows)
{

var mNode = new MenuItem();//here you can check for overloaded menuitem constructors which suits you best i'm takin default constructor
Menu1.Items.Add(mNode);

//' Get matching Sub Category
DataRow []subCatRows = categoryRow.GetChildRows("Children");
foreach(DataRow row in subCatRows)
{
String subCatName= row["SubCatName"].ToString();
var subCatItems =new MenuItem(); // again here also look for best overloaded constructor
Menu1.Items[count].ChildItems.Add(subCatItems);
}
count = count + 1;
}
}

void BindMenu(){
String connectionString = WebConfigurationManager.ConnectionStrings["DatabaseConnectionString1"].ConnectionString;
SqlConnection con= new SqlConnection(connectionString);
SqlDataAdapter dadCategories = new SqlDataAdapter("SELECT CatId,CatName FROM Category order by CatName", con);
SqlDataAdapter dadSubCat= new SqlDataAdapter("SELECT SubCatId,CatId,SubCatName FROM SubCategory order by SubCatName", con);

//' Add the DataTables to the DataSet
DataSet dsCat =new DataSet();

con.Open();
dadCategories.Fill(dsCat, "Category");
dadSubCat.Fill(dsCat, "SubCategory");


//' Add a DataRelation
dsCat.Relations.Add("Children", dsCat.Tables["Category"].Columns["CatId"], dsCat.Tables["SubCategory"].Columns["CatId"]);
//' Add the Category nodes
int count = 0;
foreach( DataRow categoryRow in dsCat.Tables["Category"].Rows)
{

var mNode = new MenuItem();//here you can check for overloaded menuitem constructors which suits you best i'm takin default constructor
Menu1.Items.Add(mNode);

//' Get matching Sub Category
DataRow []subCatRows = categoryRow.GetChildRows("Children");
foreach(DataRow row in subCatRows)
{
String subCatName= row["SubCatName"].ToString();
var subCatItems =new MenuItem(); // again here also look for best overloaded constructor
Menu1.Items[count].ChildItems.Add(subCatItems);
}
count = count + 1;
}
}
i suppose this will help to sort your problem...
thanks

instead of CheckBoxChecked event you can try CheckBox_CheckedChanged Event

even i'll also give +5

@chowdary2005 there is no such data type as longint however long is there. Do run your loop condition upto (DT.rows.count - 1) instead of DT.rows.count

i have told you that in my case it was installed in c:, i think you havenot read my comment properly i have mentioned that i have installed windows n c:

@shahin: yeah you are correct but here the problem may be caused due to the usage of int16... because if it has 100000 rows then this is the most probable reason according to me.
Moreover Chowdary i'll suggest you to write (DT.rows.count - 1) as index stars from zero this may also cause bug

but the boot.ini will always reside in c: and in my case i haven't formatted the windows which was firstly installed(in c:) and then ubuntu was installed in different drive

i have installed a fresh coy of the windows and i have access to the drive where the old coy of windows Xp is present but still not able to fix this problem

thanks for your suggestions.

when i'm storing the same path in different program it is working well
but it is not working here

hi dalek it was not working i have done this as following
Image image = Image.FromFile(temp); //here temp stores image path from root
Bitmap bmp = new Bitmap(50, 50, PixelFormat.Format24bppRgb);
bmp.SetResolution(50, 50);
Graphics gfx = Graphics.FromImage(bmp);
gfx.SmoothingMode = SmoothingMode.AntiAlias;
gfx.InterpolationMode = InterpolationMode.HighQualityBicubic;
gfx.PixelOffsetMode = PixelOffsetMode.HighQuality;
gfx.DrawImage(image, new Rectangle(0, 0, 80, 80), 0, 0, 80, 80, GraphicsUnit.Pixel);
// Dispose to free up resources
image.Dispose();
bmp.Dispose();
gfx.Dispose();