Comments by Ragi Gopi (Top 154 by date)

DataTable dt;
dt = ChartDataView.Table.Clone();


there is no attribute called table for gridview in asp.net

yes....
iam getting error in this line
dr[i] = row.Cells[j].Text;
thanks for responding

Sorry.....
nothing is use full..
thanku for your time

i used the following code
but it is generating error
protected void gv1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
gv1.DeleteRow(e.RowIndex);
}

i have no connection with database

i had added all these ...
still not working..

now the error is

CrystalDecisions.CrystalReports.Engine.DataSourceException: The report has no tables. at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet) at RME_rme_default.bt_rep0_Click(Object sender, EventArgs e) in f:\workson\Virtual_Office_KFRI\RME\rme_default.aspx.cs:line 821

were report is dataset.xsd

the query had worked when populated the grid view...
i think the error with the part
c27.cmd = new System.Data.SqlClient.SqlCommand(query, c27.connect());
c27.da = new System.Data.SqlClient.SqlDataAdapter(query, c27.connect());
report ds = new report();
c27.da.Fill(ds, "dynam_report");//error is showed here.
objRpt.SetDataSource(ds);
CrystalReportViewer1.ReportSource = objRpt;

i had no friends using crystal reports that's y i am asking help here..

question improved...

the error is
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'monitor'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at RME_rme_default.bt_rep0_Click(Object sender, EventArgs e) in f:\workson\Virtual_Office_KFRI\RME\rme_default.aspx.cs:line 820

i am working on web application
and using asp.net
then how to set platform target.

ok,thanks

Can Any one plz help

Sorry this is not the answaer..
i am talking about, if it happens with more than 6 or seven coloumns.

Had updated my question

ok will try thanks..

Can you make it clear.

SQL i used is Updated in my question.
thanks in advance

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

Dear frnds iam talking about assigning current date to datetime variable in yyyy-MM-dd format in asp.net not to string datatype.

ok..then how can i use it???

am not asking about how to list files......

i want to know how to search files...as per the key word in the textbox...

that is now i am extracting files by one key word ..now i need to use multile key word search as in google......(but from my server)

i need to find files from my server using the key words...
now i had implemented it by searching with single word.......
now i need to seearch with multile keys as we do in google...

can we open file as google docs do?????
did any one know about it.

Rakesh meal

i want to display doc file only in click event of bulleted list

1)ms office 2007 is installed in my system..
2output is showing in browser window itself......
and my code to display file is above in my question..

suman iam now working with iframes..

if u r not busy....can u plz look to my problem??

http://www.codeproject.com/Questions/309579/how-to-open-a-word-file-in-iframe


here is my problem..
plz help meeee

thanks Suman....

protected void bl_procedures_Click(object sender, BulletedListEventArgs e)
{

try
{
string path = Server.MapPath("PROCEDURES/" + bl_procedures.Items[e.Index].Text);
System.IO.FileInfo file = new System.IO.FileInfo(path);
Label2.Text = file.Name +"###" + file.FullName;
//Response.Clear();
//Response.AddHeader("Content-Disposition", "inline; filename=" + file.Name);

//Response.AddHeader("content-length", file.Length.ToString());
//Response.ContentType = ReturnExtension(file.Length.ToString());
//Response.TransmitFile(file.FullName);
//Response.WriteFile(file.FullName);
//Response.End();

frmWord.Attributes["src"] = file.Name;
}
catch(Exception ex)
{
Label2.Text = ex.ToString();
}


}


done this code but not displaying data in iframe ..its showing error...what to do???

Sorry not working

its showing the file ...but the content is like as beloww

��ࡱ�>�� 
{}
����z���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������[� ��)bjbj���� 4�ΐ
)���������+++++����????K�
?w:
?????�������$��S@+++??�1222�+?+?�2�222?����P�v}���
? 2�G0w2��2�+2�2( w���������������������������������������������������������������������� �:

Purchase of Equipments: PROCEDURES OriginatorsForwarding throughStepsIndividuals/ CommitteesActions by Individuals/CommitteesScientistHOD1OriginatorsRequest for the equipmentHODPC2Equipment CommitteeEvaluates the requestPCEvaluates the availability of fundsSIC-CIUEvaluates necessity of the equipmentEnggPrepares the MinutesDirector3Chairman, Equipment CommitteeForwards the Minutes to Sr. Supdt. (Purchase)Dy. Regr (Admn)Registrar4Sr. Supdt. (Purch)Invites QuotationsDy. Regr (Accts)RegistrarMakes comparative tablesRegistrarForwards Quotations to Equipment CommitteeSr. Supdt. (Admn)Dy. Regr (Admn)5Equipment CommitteeExamines the QuotationsSr. Supdt. (Accts)Dy. Regr (Accts)Shortlists the QuotationsSr. Supdt. (Purch)Sr. Supdt. (Admn)Prepares MinutesSr. Supdt. (Stores)Sr. Supdt. (Admn)6Chair, Equipment CommitteeForwards the Quotations to Purchase CommitteeSr. Supdt. (Vehic)Sr. Supdt. (Admn)Forwards the Minutes to Purchase Committee7Purchase CommitteeEvaluates the Minutes of the Equipment CommitteeNegotiates with the FirmsProvides Recommendations to the Director8DirectorDisagrees to purchase the equipment, orAgrees to purchase the equipment9Sr. Supdt (Purch)File transferred to Sr. Supdt (Purchase)Initiates Purchase ProceedsOpens LCReceives the EquipmentTransfers the Equipment to Sr. Supdt (Stores)Communicates the price to Sr. Supdt. (Accts)10Sr. Supdt. (Accts)Debits the price to the project or to appropriate heads11Sr. Supdt (Stores)Takes stock of the EquipmentConveys the arrival of the Equipment to the Originator12OriginatorProvides indent for issue of the Equipment 13Sr. Supdt (Stores)Issues the Equipment to the Originator 
$%EI�()����ǷǨ�h�E�h�v�CJOJQJaJh�E�h�K5�CJOJQJaJh�E�h�v�5�CJOJQJaJhr5�#h�E�h�*�5�CJOJQJ^JaJ#h�E�hr5�5�CJOJQJ^JaJ #$%1<DJb����������
Ekd$
$
If
T
�l�
����" t�
�
6
���������4�
4�
la�h�yt�E��T
$
$
If
a$
gd�E�l� ��%�kdS$
$
If
�l�





�r|�oc ' x(#p� �

 t�
��������������0�
�
�
�
�
�
��+6
�������������������������4�
4�
la���p�������������yt�E�
�����������$
If
gd�PMl�$
$
If
a$
gd�E�l�$
If
gd�v�l�$
If
gdTx�l���%�kdp
$
$
If
�l�





�r|�oc ' x(#p� �

 t�
��������������0�
�
�
�
�
�
��+6
�������������������������4�
4�
la���p�������������yt�E�
�����������$
If
gd9h�l�$
If
gd�PMl�$
$
If
a$
gd�E�l�$
If
gd�v�l�$
If
gdTx�l���%�kd�$
$
If
�l�





�r|�oc ' x(#p� �

 t�
��������������0�
�
�
�
�
�
��+6
�������������������������4�
4�
la���p�������������yt�E�
����� �����$
If
gd9h�l�$
If
gd�

what to do to clear the session while closing the browser

master page is not the login page..(here its displaying home page)
i just kept a login button on master..and it navigates to a login page...
there login function is done then after the login process it is redirected to home ..then the login button should change its text to username thats my aim...

can u plz show me an example.....plz help me

can u make more clear....

selected node change event is not firing

how to open files from tree-view (pdf,docx,xls) in the browser

how to open files from tree-view (pdf,docx,xls) in the browser

can any one help me

string path = Server.MapPath("files/" + resultsList.SelectedItem.Text);
System.Net.WebClient client = new System.Net.WebClient();
Byte[] buffer = client.DownloadData(path);

if (buffer != null)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-length", buffer.Length.ToString());
Response.BinaryWrite(buffer);
}



this code opens the page in browser itself


but i need it in a pannel

ya i tried the first link....

second one is not clear for me..

its showing some thing like

T��a ����h�D|�"lU�)L0����vAq�Vv& ���P�!�b���٨L�!$��KA`��s)��`��+�pP��,�H(D``������`#��hGP�H��5��%uh&eq6�qq([s%���-�@����x"?!��7�o�����������B�t�M�p��td��߯�_����E.:_���O��d�giJ�)��ZO|�0�������_�c5��Ke�!U��0y�'�Y���#�:#��a`��DG�����"97������[��L�u�?Mg㟔��E�B�x���o)��u_��`��E���(o8��:=?�%��z�_�<���-����:X<����{ǣ�`�̖����aʂ�Sү������~���<�}�Cxr�����>���#g��oo��Ct?Ο��]��~���Ͱ^S�v�_�-���S%��ʖ���bJ]�녫���Ν~��������a�bA����w�Wӥ~�#ͪ��A7����賌[��v��P���?��#�d�e�X��W���~DY.�ZƸv���`��e�Bb��j�#�H$��d��u��a�m}$�X�da�kT�~/,W?�J��#�2F�V���/�A/���#��u��TGM���3�%"*c�+�^�>���_0��j#�% ^��s��}ׄ�QX����@�ʤv���X���z(@����w

sorry.....its not the answer for me


i know the code for down loading ....
now i want to just display the files

thanku....

what should i do to display in a panel in web page itself....


thank u for your help...
plz help me for this query tooo...

that i know...but iam asking about how to design...

can we do designing as in visual studio....

i tried that ..
i need to login in sql server authentication mode....

can u plz provide me an example

plzzz help me.......

can u do me a favor .....
sorry for disturbing u...




i need to display list of files from remote server which has the keyword i specify in a textbox. and also need to see that file when double cliked on it.
which control should i use to display the list...if i use listbox, i think there is no double click event.
i tried your code :-

string filename = TextBox1.Text;
if (File.Exists(Server.MapPath("files/" + (filename))))
{
Response.Write("file exist");
ListBox1.Items.Add(filename);

}
else
{
Response.Write("no");
}

here file is the folder name,
the above shows only single file, and it is displayed only when the complete name is inputed.


can you plz help me...
thanks in advance...

can u plz help

how can i display that file in my page for download???which control i should use for that

which control i should use for that

how can i display that file in my page for download???????

thanks dear...
it works

oooppps.....its not working ,,but your answer seems to be correct...
can u plz guide me to a full example..

thanks in advance

thanks dear....
may i work on this ....

and for searching????

thanks for your help..and for considering me...

sorry again the same error occurs.

Ashish Tyagi...Can u plz help me

hii tried ur code, but iam getting the following error..
if u don't mind can u help me..plzz


System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: The remote name could not be resolved: 'smtp.gmail.com' at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6, Int32 timeout) at System.Net.PooledStream.Activate(Object owningObject, Boolean async, Int32 timeout, GeneralAsyncDelegate asyncCallback) at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) --- End of inner exception stack trace --- at System.Net.Mail.SmtpClient.Send(MailMessage message) at home_page.btsignin_Click(Object sender, EventArgs e) in e:\kfri_auto\automate\home_page.aspx.cs:line 146

then the error is:


System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: The remote name could not be resolved: 'smtp.gmail.com' at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6, Int32 timeout) at System.Net.PooledStream.Activate(Object owningObject, Boolean async, Int32 timeout, GeneralAsyncDelegate asyncCallback) at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) --- End of inner exception stack trace --- at System.Net.Mail.SmtpClient.Send(MailMessage message) at home_page.btsignin_Click(Object sender, EventArgs e) in e:\kfri_auto\automate\home_page.aspx.cs:line 146

am using ms access 2007

Sorry
its not clear for me
as iam new to asp.net
plz help

how can i start with that????
can u plz help with a link

whats difference between ASP.net Web Application and Website

got one....
thanks

but i came to know iis 7.5 only work with .NET Framework 4.0

is it Compatible with VS 2008 and OS is Windows XP SP2.

yes, i want different user to fill different parts of the same form.

This XML file does not appear to have any style information associated with it. The document tree is shown below



hi
i want to upload a MS infopath file in LAN server in my institution ...
the people in the institution will fill the form and will submit.
So for a trail i installed wamp ...

I put the infopath form.xml in C:\wamp\www\xml\ ..its not working..

the error is : This XML file does not appear to have any style information associated with it. The document tree is shown below.
for appearing it as it is,
what should i do .......

plz help thanks in advance

thank u.....
very much

Error 1 'System.Windows.Forms.DataGridView' does not contain a definition for 'ExportSettings' and no extension method 'ExportSettings' accepting a first argument of type 'System.Windows.Forms.DataGridView' could be found (are you missing a using directive or an assembly reference?) D:\ETMS\ETMS\ETMS\edit_fund_agen.cs 336 18 ETMS



got this error

got the ans ...
but its not appearing in table format

got it...

transferred to exel..
i

got the ans....

i used the following code


private void button3_Click(object sender, EventArgs e)
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;

xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;

for (i = 0; i <= dgv1.RowCount - 1; i++)
{
for (j = 0; j <= dgv1.ColumnCount - 1; j++)
{
DataGridViewCell cell = dgv1[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}

xlWorkBook.SaveAs("csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();

releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);

MessageBox.Show("Excel file created , you can find the file c:\\csharp.net-informations.xls");

}



but what to do display the header of each column

Toniyo Jackson....NOW() its only working for date..thatis not considering month or year...

mmhhh......

Ya buddy its working ..thanks....
then wat happen to GETDATE....

no...
but when i executed quarry wit GETDATE()in access it shows error..otherwise its working in access.

sorry, not working ....

thankss...

thanku...

Can u plz help me....

@meBalkrishna

I have doubt about datagridviewcell.
i have created textboxcolumn in datagridview. when ever i click the particular cell the cell should change to datagridviewcomboboxcell. Also i need to add the item in combobox collection.
when i go to another cell then, the new cell get datagridviewcombobox cell and existing cell should change to datagridviewtextbox cell...

thx...

yes, am working on forms application.
i tried first link...but its clear for me..

Can u plz guide me to another example..plzzzzz

thanku
nit_singh

@Prerak Patel
not working..

@Joemar Valete
i tried solution of Uday P.Singh..
its works :)

@Uday P.Singh
Thanku buddy....
Its Works.......

@RakeshMeena
i tried ur linq but again the same error is generated...

following error is displayed....
"update requires a valid update command when pressed datarow collection with modified rows"

@tambores63
u r correct this is my question....

How do I update a modified row of my datagridview to the db?

tried a lot nothing works....
if any one can help..
plz help...

ok sure..

thank u., i will try this too...

private void tbph_MouseClick(object sender, MouseEventArgs e)
{
this.tbph.ContextMenu = new ContextMenu();
}

Got Ans...
@CS2011
thankuuuu

:)

if ((e.KeyChar < '0' || e.KeyChar > '9') && (e.KeyChar != '\b'))
{
MessageBox.Show("Only numbers Allowed");
e.Handled = true;
}
else
{
e.Handled = false;
}

atlast every thing is fine....

thankuuuuu.....
its workssss
thank u all

How can we disable Paste option????

ohhhhh..thats a problem.....

Windows forms

sorry......... down voting was a mistake..

datatype of kfri is Yes/No...and resid is autonumber..
and error is data mismatch..this happens because...rb1.checked returns the value..true or false..

'datatype of kfri is Yes/No...

improved question

iam trying this ..
http://www.codeproject.com/KB/aspnet/List_Box_Control.aspx

@Prerak Patel
thanks...
changed Target from 'Any Cpu' to x86..

thanks...
changed Target from 'Any Cpu' to x86....

@Uday P.Singh
its worksss
Thanks

@Uday P.Singh

then i got this error
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered "

@Prerak Patel
then i git this error
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered ";;;;

@Ramalinga Koushik
this wil not work
because Microsoft.Jet.OLEDB.4.0 is not seen in Windows7 , 64 bit OS.

@sindhu
this not working

@strogg
iam using windows7, 64 bit OS

@valery possoz
its works buddy....
thanks..........

can u plz suggest me a solution for that....

error "Cannot access a disposed object. Object name: 'frmSChild..."

k

method for activating disposed form in run time.

@Richard MacCutchan

can u plz say the method for that

can u plz help me

@parmar_punit@yahoo.co.in

but its not working.....
an error "Cannot access a disposed object. Object name: 'frmSChild..."
is generated
This happens when i select "new single" from "File" menu Second time..

not working

its not working

what is difference between Multi Instance Child and Single Instance Child

Thanks....

while checking each form in a project, is there any way to change the start form temporary.

ok ..
its works

thanks...wil bak with more doubts...
thanks

ok thanks buddy

is there any chance of error..when we install s/w developed(c#) in Windows 7 hat is developed in windows XP and vise versa

iam not asking about that ..
iam asking about the Softwares that developed in both os...can this softwares be installed both os...

Is there any difference between working in C# installed in windows 7 and Windows XP

ok thanks..

i will make ma question clear..