Comments by sameer549 (Top 57 by date)

yes but stringBuilder cant hold string for lakhs of records, definitely it throw memory out exception at some point.

when you are working with bulk data, need to read the rows in a chunks/loop, for example, 1000 rows each time

can you explain, y do u need this ?

welcome, please always check google before posting question.

may i know what problem you facing ?

what ajax you tried ? did you search your question on google ?

i need suggestion on how best we can display differences on UI.

give your exact input string.. is it contains multiple lines as you given above?

then it should work, debug and check data in dt (gvDetails.DataSource = dt;)

did you bind gridview after inserting data ?

keep your question simple, no one will look into this much big code.
what you want ? what you tried? where you facing problem ?

if its working in localhost then it should work on server also,
check your server credentials
and be sure whether ajax request hitting the right path

you cannot achieve this directly, you need to save the checkbox state in some variable and then hide/show checkbox in subform load event.

http://stackoverflow.com/questions/14616958/saving-the-form-state-then-opening-it-back-up-in-the-same-state

if (lbl.Text == "Empty")
{
e.Row.Visible = false && RENT == 0;
return; //will stop here
}

is this what you are expecting ?

ohh i didn't observed, good.

Hi karthik, i guess filter should be like this,

string filter = string.Join(",", list.Select(r=> "'"+ r + "'"));

try commenting ClientScript.RegisterStartupScript, and try again.

try inspect element and check whether class is applying or any other css overriding.

yes you are right Richard

yes, read my above comment properly, in your c#,
step1: access gridview from master page
step2: loop through gridview rows
step3: while looping, find any controls(label/textbox/linkbutton) from gridview row, and then you can get the properties/values from that control

from where did you added the office2013.dll reference ?
did you check version issues ? All systems have office application of same version ?

if you are using item templates, then first you need to access the item control from the gridview row, and then you can access the text of particular control.

for example,
Label lblID = (Label)gv.Rows[index].cells[0].FindControl("lblID");
string value = lblID.Text;

are you getting any exception ?
have you used any item templates in gridview designing ?

can you explain clearly what you want to achieve, and where are you stopping ?

as per my understanding, your code needs modification like this,

if(Result.HasRows)
{
while (Result.Read())
{
//do here data reading stuff here
}
}

i think in butUpdateMember_Click, you are missing update command before line, adp.Update(dtEditMember)
it should be something like
//select the update command
adp.UpdateCommand=cmd;
//update the data source
adp.Update(dtEditMember);

check this link once,
http://www.c-sharpcorner.com/uploadfile/61b832/sqldataadapter-update-method/

prepare steps for your program and search on google accordingly,
for example:
step1: reading text from file line by line
step2: fill the datatable in a loop
step3: bind datatable to gridview.

Sample code will be something like this, (code not tested)

StreamReader fileReader = new StreamReader(filePath);
string line; DataTable dt = new DataTable();
dt.Columns.Add("Column1");
while ((line = fileReader.ReadLine()) != null)
{
DataRow dr = dt.NewRow();
dr["Column1"] = line.ToString();
dt.Rows.Add(dr);
}

GridView1.DataSource = dt;
GridView1.DataBind();

Hey Richard its working fine, Thank you.

similarly, can you please make the first regex to work for any word ?

hi richard,
thanks for comments, in the second regex u have hardcoded "simp", which will work for simplg but not for other words. Can you make it more helpful, because i am working on find replace kind of thing and user can enter any input.

Can Anyone plz guide me on this ?

Hi pete, thanks for the link, but i found it very complex to understand.

anyone plz help me for this ??

i suggest you its better to ask a question in github, you will get quick solution.. https://github.com/MahApps/mahapps.github.com

your question is not clear..

Hi,
Thanks for your solution. But i know this what you have given.. please read my question clearly

I dont think there will be a need of different connections. do u want to use different connectionStrings/same connectionstring with different connections ?

I think there is no other way, you have to implement this in your code logic. At runtime you have to when application starts, store the connectionString as it is in Use, and you have to release the connectionString when application terminates.

Hi Mehdi, thanks for ur reply, i have already gone through this link, but i didn't found File->Export->Forward Engineer SQL CREATE Script option in workbench 6.1 . However i generated script using right click option by selecting all the tables,and stored procedures.

there are many options first decide what you want to do. whether you want to enhance your career a web developer or if you want to stick to windows development.!!

you can do it in your c# code in the code behind, on your button_click event you can store the procedure result in DataTable, use a for loop and build a html string using string builder,meanwhile add Total/GrandTotal and then you can use,

here is some sample code

StringBuilder Htmlstr = new StringBuilder();
//build html string for report here
Htmlstr.Append("<script = language='javascript'>");
Htmlstr.Append("window.open('/Report.aspx');");
Htmlstr.Append("</script>");
ClientScript.RegisterStartupScript(GetType(), "GenerateReport", Htmlstr.ToString());

please be clear, what is the symbol you are using to seperate numbers ?

yes you are rite. actually mine is a typing mistake :)

Hi khan, check if u have added 2 references of excel.or else Remove the reference and add once again. And to make 'embed interop types' to false,open solution explorer right click on reference, goto properties, and set Embed Interop Types to false.

hope it helps
Regards Sameer

check what values are there in combobox2, if combobox2 has a item with value dt1.Rows[6]["Value"].ToString(); then you will get it , or else u can also add items to combobox at runtime, like combobox2.items.add("")

code behind file means the file in which u implement code logic, in code behind file u can use only c#.net and vb.net. In designing u can use html tags instead of asp tags, but for calling events u may need some additional logic

Hi karthik, the file stored in the sql db will be in encoded(unreadable) format. So first u have to extract the original text from that and then u can update/delete the sql db record based on the requirement

Hi Murugappan, If u have client side validations on your aspx page, then the button click code will not execute if any validation error,to redirect u can use Response.Redirect("yourpagename.aspx"); method,
Hope this helpful,

Regards
Sameer

Hi Bernhard, we are using office 2007 only both in my system and client system .

Hi richard, thanks fr ur reply
I am getting exception while trying to access MailItem ex code :
subject = ((Microsoft.Office.Interop.Outlook.MailItem)myInbox.Items[i]).Subject;

can i know what will be the reason for this exception ??

Error Message :

Unable to cast COM object of type System_ComObject to InterfaceType “Microsoft.Office.Interop.Outlook.MailItem” . This operation failed because the QueryInterface Call on the Com Component for the Interface with ID’{00063034-0000-0000-C000-00000000046} failed due to the following error. No such interface supported (Exception from HRESULT: 0x80004002)
(E_NONINTERFACE)