|
Is it possible without using Datatable, dataset or datareader , retrive
records from database. We can use SqlConnection. Can we retrive using System.Object array. Try read whole databas ,from table retrive one record and display or modify
|
|
|
|
|
Dharti Gajjar wrote: from table retrive one record and display or modify
ExecuteScalar() ?
|
|
|
|
|
but to retrive all records , not one row from databse,but retive table it's row
from database and store into system object array
|
|
|
|
|
Why do you want to do this ? You can feth data into any of these (Reader/Datatable), and loop through each rows and put it in an array.
|
|
|
|
|
please tell me the code for the upload the file in the server root path
|
|
|
|
|
Please don't create multiple post for the same question.
Apurva Kaushal
|
|
|
|
|
hi frd...this is code for upload image.....![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
string sPath;
sPath="../Images/Logo.jpg";
if(BuildersLogoFile.PostedFile!=null)
{
HttpPostedFile photoFile=BuildersLogoFile.PostedFile;
int photoLength=photoFile.ContentLength;
string fileName=Path.GetFileName(photoFile.FileName);
if(photoLength==0)
{
Label1.Text="There was not any file uploaded";
return;
}
if(File.Exists(Server.MapPath(sPath+fileName)))
{
Label1.Text="File already exists";
return;
}
if(Path.GetExtension(photoFile.FileName).ToLower()!=".jpg")
{
Label1.Text="The file must have extension of JPG";
return;
}
byte[] myData=new byte[photoLength];
photoFile.InputStream.Read(myData,0,photoLength);
int file_append=0;
while (System.IO.File.Exists(Server.MapPath(sPath + fileName)))
{
file_append++;
fileName = System.IO.Path.GetFileNameWithoutExtension(photoFile.FileName) + file_append.ToString() + ".jpg";
}
FileStream newFile=new FileStream(Server.MapPath(sPath+fileName),FileMode.Create);
newFile.Write(myData,0,myData.Length);
newFile.Close();
buildersClass.BuildersLogo=sPath+fileName;
}
Vijay
|
|
|
|
|
iam setting a grid view in a panel and iam having a text box when i enter some text in the text box i wrote a code in a such a way that the text box value should come in the grid view..by using view state its working fine ..and the iam viewing the last genarated row of the grid view ..but the pproblem was when grid view becomming larger the scroll bar of panel is appearing and iam uanable to view the last genarated row its going down in the pannel...how this problem solve...will some one help for me...plz
|
|
|
|
|
jagadeeshkumar2106 wrote: iam uanable to view the last genarated row its going down in the pannel..
How come you are not able to view?? You mean, you don't want to scroll down to view the last row?? then, you can set the scroll position of your DIV from Javascript.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
my intension is the grid view row is added at the last and it is coming from the top of the panel ...is there is any way to come from the bottom of the panel and the auto genarate to come at the top...
|
|
|
|
|
As Apurva suggested, you can sort your data in descending order. or try to insert the new row at the top of your datatable. (dt.Rows.InsertAt())
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
dt.Rows.InsertAt() how to work with this will u help me plz
|
|
|
|
|
If you just want to see the last inserted record without scrolling then you can show that at first and it will be displayed at the top. 
Apurva Kaushal
|
|
|
|
|
hi wat u said i think it will com but will u plz help how to get the grid in reverse order madam
|
|
|
|
|
You can sort your records based on the ID column (if you have) in descending order or by the created date again in descending order.
jagadeeshkumar2106 wrote: reverse order madam
I am a Male dude... 
Apurva Kaushal
|
|
|
|
|
sory sir for calling mam .... actually iam having columns whic are string data type ...
|
|
|
|
|
You can have one more column for ID and can make that column auto generated and sort it accordingly.
Apurva Kaushal
|
|
|
|
|
sir will u guide me how to do now i created a row with a id wehn a new row is genarated it is getting 1,2,3,.... now plz gudie with code how to sort the auto genrated columns
|
|
|
|
|
You can do it some how like this:
string strExpr;<br />
string strSort;<br />
<br />
strExpr = "id > 5";<br />
strSort = "name DESC";<br />
DataRow[] foundRows = <br />
customerTable.Select( strExpr, strSort, DataViewRowState.Added );
Apurva Kaushal
|
|
|
|
|
sir will u guide me how to do now i created a row with a id wehn a new row is genarated it is getting 1,2,3,.... now plz gudie with code how to sort the auto genrated rows
|
|
|
|
|
can anyone help me to upload the image file in my project folder
|
|
|
|
|
Ravi_21 wrote: my project folder
You can only upload the file to Web server.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
sir so tell me the code for the file upload in the server
|
|
|
|
|
If you just want to ask something from a particular person then reply to his thread.
Apurva Kaushal
|
|
|
|
|
You can take help from Here[^] for uploading a file.
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
