Comments by Gopal Rakhal (Top 61 by date)

Its works fine, m getting all columns name but it is necessary to loop through all rows, Is there any way to not loop all rows.
Thanks a lot

Not in View rather in controller
List<PovertyModel> tempPovertyList = new List<PovertyModel>();
tempPovertyList = ent.Database.SqlQuery<PovertyModel>("PopulatePovertyRecords").ToList();

Now I want to get the list of fieldname/columns name in tempPovertyList.....

Is this above code is for working in LAN?Here remote is for server located not in LAN, different place say different district of state.

Actually I want to know methods for same and if I go for asp.net to do same how can I do.

Thanks i will search for it.

templist is a list which is populated with item in BillingCounterTestListModelList using loop, now what I need is to have extra two columns in templist which are not present in BillingCounterTestListModelList.

Atlast I solved, its just bcoz of line "gv.DataBind()" in ExporttoExcel(GridView gv)

I have already tried this but not working any other alternative ..

thanks everyone, I got track to start with...

it is almost similar, but if i can know what is error?

response.write("<script>return confirm('Are You Sure');</script>");

plz clear your question little..

sub-directory inside root directory....

yes.....

when i upload images it gives "Access to the path 'D:\inetpub\vhosts\.....(url)\httpdocs\22-11-2012' is denied."

thanks its working, but when new window opened the main window become blank, its only shows "[object]" in the top of page, m not able to make it work properly...

its showing this error only in IE but its working in chrome

i have two functions for two separate insert command, now if i call both functions separately in button_click then one function may execute and another may not execute, so i want to execute both function if both are fine else want to roll back both insert commands..

Can u make your question more clear?, do u want to populate gridview with employee_id from database on button click?

Am using System.drawing, I have create a application to crop image in rectangular shape, but how to write code to make handfree selection/cropping tool

I tried, actually my problem is that it get display but get hide when button click or on postback...

thanks,

I need 3year 9months.. is it possible in sql or i need to write coding?

thanks, but if i have 45 months then it will give 3.75 year, so what to do in this case.....

thanks

thanks.....

//sqlconnection
string StrCon = ConfigurationManager.ConnectionStrings["idol"].ToString();
SqlConnection objcon = new SqlConnection(StrCon);
objcon.Open();
//oledbconnection
string filepath = FileUpload1.PostedFile.FileName;
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
string FilePath = Server.MapPath(FolderPath + FileName);
string stroledbCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=Excel 12.0 ";
// "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";


OleDbConnection oledbCon = new OleDbConnection(stroledbCon);
oledbCon.Open();
string strOledbQuery = "select * from [Sheet1$]";
OleDbCommand cmd = new OleDbCommand(strOledbQuery, oledbCon);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string strinsert = "insert into student_tbl(slNo,Rollno,Name) VALUES ('"+dr[0].ToString ()+"','" + dr[1].ToString() + "','" + dr[2].ToString() + "')";
SqlCommand cmd2 = new SqlCommand(strinsert, objcon);
cmd2.ExecuteNonQuery();
}

thanks

My result will be only single value from first procedure and that i want to used as parameter in another procedure

do i need to use any dll comes with that barcode reader...

thanks, i was having no idea, i got an idea ...

thanks

then did u got any solution for that if then plz suggest me.....

thanks Sandeep, but i didn't get any solution out of these links, if possible plz suggest me else way...

thanks

Thanks but I am not understanding you, I want to validate my textboxes inside Gridview. I want to restrict the user that he/she should not enter the marks greater than 80 or else. how can i do so...

Thanks Sandeep, I tried ur code, but its giving "Object reference not set to an instance of an object." error, Actually i am loading my gridview on pageload, and want to check/validate on onekeypress event..

thanks

Thanks

thanks, but i need just for user not for programmer...

thanks, i got it....i need to purchase another

In my pc its working f9, its not working in web server...

thanks, but i have not fixed number of subjects...

Ohhh I just got hint from u and solved it!!!!!!!!!

Thanks I have solved.........

thanks, but it is not working, please give perfect way to do so.

its navigating but not displaying result like names.., just navigating in sequence

I got u, thanks but as I am fist time working on Web application, don't have through idea please help little more, "Thanking You"

so funny dude...

Then plz suggest me else way...

Simply I want a Confirm Message as in Windows application. Say, Yes/No message Box, in C# asp.net

plz improve this....

plz send me code or steps for that..

I want Information messagebox and Confirmation messagebox in C# asp.net

Thanks for ur valuable suggestion, thats good option, but wat i need is when i move to previous page gridview textboxes should not be erased, or Is there any way through which I can make a single column (of GirdView) editable...
Plz suggest me....