Comments by Thirumadhi T Johnson

Thirumadhi T Johnson 16-Apr-24 3:58am View

Ohk will try this than Thank You Dave

Thirumadhi T Johnson 15-Apr-24 8:19am View

Yes the previous code is running in a desktop app. and we are only one in this XXX out project domain name is there...in this case what I can do Dave ??

Thirumadhi T Johnson 21-Mar-24 5:14am View

Yes Dave you are write there is a client side code with this

public static string DocConvertionUrl = "https://xxx.com/doc2pdf";

it is deployed in Server as below

<%@ Page Language="C#"%><%
                            var ins = Request.InputStream;

                            var loadOptions = new Aspose.Words.Loading.LoadOptions { LoadFormat = Aspose.Words.LoadFormat.Auto };
                            var pdfDocument = new Aspose.Words.Document(ins, loadOptions);

                            pdfDocument.Save(Response,"file.pdf", Aspose.Words.ContentDisposition.Attachment, new Aspose.Words.Saving.PdfSaveOptions() );
%>

Thirumadhi T Johnson 21-Mar-24 2:03am View

and this is desktop based application

Thirumadhi T Johnson 21-Mar-24 0:27am View

Hi Dave , This is only server side code ..this not a client side code...
public static string DocConvertionUrl = "https://xxx.com/doc2pdf"; is this code is causing an issue

Thirumadhi T Johnson 20-Jul-22 9:00am View

Ohk Thank You I will try this code .

Thirumadhi T Johnson 20-Jul-22 8:04am View

Hi @Richard Deeming any reference/guide how to write for

web server read the exe from disk and send it back in the response. The user will then be able to choose whether to open, save, or discard the file.Please

Thirumadhi T Johnson 13-Jul-22 23:22pm View

Hi @Nasir M@hmood and @Shivanand even I am also looking for same requirement even I too installed VS installer in VS 2015 but where and How we can mention this p.StartInfo.FileName = Path.Combine(Application.StartupPath, "setup.exe") please help me too

Thirumadhi T Johnson 23-Jun-22 0:29am View

Hi @Fydobas ...that autopopulate one is throwing error like after editing value An exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll but was not handled in user code

Additional information: Column named EffDtDataGridViewTextBoxColumn cannot be found.

but this only in gridview design name and through this name too update is happening.
Should we go desgin name or dataproperty name is only EffDt
but when I add your suggested codes in Cellendedit event or cellvalidating event ,it is throwing like column does not exist .Please suggest what to do here
after entering date eFfdate column it is throwing

Thirumadhi T Johnson 22-Jun-22 2:03am View

No there is nothing like special checkbox checking but it was working for me and suddenly stopped working

int total = dataGridView1.Rows.Cast<datagridviewrow>().Where(p => Convert.ToBoolean(p.Cells["chkbox"].Value) == true).Count();
and this total give me total number of count also and it was actually going in foreachloop for selected rows but suddenly last two days it is not working for me no Idea why

Thirumadhi T Johnson 21-Jun-22 4:56am View

Ok I will try this autopopulate one in Cellvalidating or CellEndEdit event and let you know .But again one Big issue came up before I used to selected mutltiple rows based on gridview now suddenly if I select one or two checkbox in gridview selected rows nothing is coming up . As I have two button click outside of gridview .It is placed in panel .
For delete button if I select one or more checkbox ,datagridview1.selectedrows are coming null (List or Count is null only )

but the same I do for update ,I will get id value only for one row no matter if I choose to update 2/3/4 rows based on checkbox selection.

Belows are code you might be knowing as I have been discussing with you before only
For Delete Button
private void btnDelete_Click(object sender, EventArgs e)
{
string Ids = string.Empty;
bool Msgalert = false;

int total = dataGridView1.Rows.Cast<datagridviewrow>().Where(p => Convert.ToBoolean(p.Cells["chkbox"].Value) == true).Count();

if (total > 0)
{

ColMessageBox.Instance.ShowMessageBox($"Are you sure want to delete {total} row ?", "Ok", "Cancel");
if (ColMessageBox.Instance.IsDialogResultOK)
{
//for (int i = 0; i < dataGridView1.RowCount; i++)
int i = 0;
foreach (DataGridViewRow dgvrow in dataGridView1.SelectedRows)
{
// "1,2,3"
// row = dataGridView1.Rows[i];
if (Convert.ToBoolean(dgvrow.Cells["TBL_POL_ID"].Selected) == true && i < dataGridView1.SelectedRows.Count - 1)
{

Ids = Ids + dgvrow.Cells["TBL_POL_ID"].Value + ",";

}
and Update Click

public void Update()
{
int tbl_pol_id = 0;
string LUB = string.Empty;
string POL_No = string.Empty;
DateTime POL_Effdate;
DateTime POL_Expdate;

ColMessageBox.Instance.ShowMessageBox("Would like to update then click yes!", "Yes", "No");
if (ColMessageBox.Instance.IsDialogResultOK)
{
foreach (DataGridViewRow dgvrow in dataGridView1.SelectedRows)
{

if (Convert.ToBoolean(dgvrow.Cells["chkbox"].Selected) == true)
{

LUB = dgvrow.Cells["lUBDataGridViewTextBoxColumn"].Value.ToString();
POL_No = dgvrow.Cells["polNoDataGridViewTextBoxColumn"].Value.ToString();
POL_Effdate = Convert.ToDateTime(dgvrow.Cells["EffDtDataGridViewTextBoxColumn"].Value)

Please help me I just do not understand why it is behaving weird suddenly before I used to get dataGridView1.selectedrows value based on checkbox selection.
Please Please save me from this trouble or else anyother way to get selected rows value based on checkbox

Thirumadhi T Johnson 21-Jun-22 2:26am View

I just commented selection_changed event and it worked for me @Fydobas. Hopefully one last help how can I autopopulate MM/dd/year in exp date column cell based of enter of the same format in effective date column cells . For example ,it will be always 1 year a head of effective date if User enter effective date 06/01/2021 after pressing enter in effective date column cell for the same row the exp date should be autopopulate 06/01/2022..this is the last enhancement looking for ..please help @Fydobas

Thirumadhi T Johnson 20-Jun-22 4:36am View

Ok I will look into it Thank You

Thirumadhi T Johnson 19-Jun-22 23:54pm View

@Fydobas ,two more help I am looking for please . 1st help is If in gridview having more than 10 records than I am not able to select the checkbox ,I can select if I start doing from bottom but from top If I do start selecting check box i can select only 1st box second box unable to do please help on this too .

Thirumadhi T Johnson 19-Jun-22 23:48pm View

Thank You once again for help ,kudos to you It worked .

Thirumadhi T Johnson 17-Jun-22 7:08am View

@Fydobas the issue still is there, after changing to any other dateformat which is not equal to MM/dd/YYYY
it is still taking the old value only from cell that I am checking on Datevalue while debugging if I changed the date 19/01/2021 but it takes only the value which is there in cell not the changed value

Thirumadhi T Johnson 17-Jun-22 2:38am View

So final code would be like this

private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
if(e.ColumnIndex != 0 && dataGridView1.Columns[e.ColumnIndex].Name == "EffDtDataGridViewTextBoxColumn")
{
string DateValue;
DateTime DateFormated;
DateValue = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
bool isDate = DateTime.TryParseExact(DateValue, "MM/DD/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out DateFormated);
if (!isDate)
{
MessageBox.Show("value should match MM/DD/yyyy format");
e.Cancel = true; // The important part
return;
}

}

and I want only after checkbox selection only of specific cell(which having dateformat) of row will validate ,means without checkbox mark it should not throw any validation message if I click on date cell simply
because of this I have added e.columnindex != 0 inside if conidtion
is it right @Fydobas

Thirumadhi T Johnson 17-Jun-22 2:30am View

Ok Thank You I will try and let u know the outcome .

Thirumadhi T Johnson 16-Jun-22 9:36am View

but for me here challenge is @Fydobas your statement
Try getting the row and cell via their indexes instead of the CurrentRow function and the name of the column, in case it does not read the correct value

and this is only causing issue ...though you might be knowing my almost gridview structure ..can you help me to write it index wise instead of current row function with name .Please it would be again another great help.

Thirumadhi T Johnson 16-Jun-22 9:32am View

Ok I will try to follow your step and debug. Thank You

Thirumadhi T Johnson 16-Jun-22 3:57am View

Hi @Fydobas That is working fine .You really saved me from 1 week of struggling . I have 3 more issues also. Hopefully I will not be irritating you :).

one issue is in the same grid view I have two columns name with effdate and exp date and in both columns I would like to add validation like user should not enter any junk/words/special characters rather than date format Month/date/year example (12/01/2020)
here is my below code

private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{

if (dataGridView1.Columns[e.ColumnIndex].Name == "EffDtDataGridViewTextBoxColumn")
{
string DateValue;
DateTime DateFormated;
DateValue = dataGridView1.CurrentRow.Cells["EffDtDataGridViewTextBoxColumn"].Value.ToString();
if (!DateTime.TryParseExact(DateValue, "MM/DD/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out DateFormated))
{
MessageBox.Show("value should match MM/DD/yyyy format");
e.Cancel = true; // The important part
return;
}

}
}

But it is not working properly ,can you please help me please

Thirumadhi T Johnson 16-Jun-22 3:07am View

Thank You I will update this and debug and let you know . Thank you so much

Thirumadhi T Johnson 16-Jun-22 2:27am View

Hi @Fydobas ....Thanks for taking time and helping me .I am really grateful :).But still there might be one more thing to rectify cellvalue means it is taking value of checkbox also which is not supposed to be .If checkbox is selected but no cell than this code is right .But in my case checkbox is also there once I select any checkbox it is appending that value too .Here is my code after applying your codes.

private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{

cellValue = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
// For this demo we will make exception for checkBoxColumn itself.
// So it is always editable.
if (e.ColumnIndex != chkbox.Index)
{

object rawValue = dataGridView1[chkbox.Index, e.RowIndex].Value;
bool value = rawValue is bool ? (bool)rawValue : false;
// But if checkBoxColumn is checked then editing not allowed
if (!value)
{

e.Cancel = true;
}

}

}

private void dataGridView1_CellEndEdit_1(object sender, DataGridViewCellEventArgs e)
{
if (cellValue != dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value)
{
cellUpdateCounter += 1;
}
}
}

and the Button Click

private void btnUpdate_Click(object sender, EventArgs e)
{
bool Msgalert = false;
int total = dataGridView1.Rows.Cast<datagridviewrow>().Where(p => Convert.ToBoolean(p.Cells["chkbox"].Value) == true).Count();

if (total > 0)
{
//dataGridView1.SelectedCells.Count > 0
//dataGridView1.CurrentCell.IsInEditMode ||
// dataGridView1.IsCurrentRowDirty

// {
if (cellUpdateCounter != 0)
{
Update();
}
MessageBox.Show("No records are updated");
return;

}

else if (total == 0)
{
MessageBox.Instance.ShowMessageBox("Please Select at least one checkbox");
Msgalert = MessageBox.Instance.IsDialogResultOK;
}
}

Looking for your help @Fydobas :)

Thirumadhi T Johnson 15-Jun-22 9:07am View

Hi @Fydobas Yes I have cellavalue changed evenet but it is in the name of cellvalue click
Here is the code for this event

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[0].Value != null && row.Cells[0].Value.Equals(true)) //0 is the column number of checkbox
{
row.Selected = true;
BtnCancel.Enabled = false;
row.DefaultCellStyle.SelectionBackColor = Color.LightSlateGray;

}
else
row.Selected = false;
BtnCancel.Enabled = true;
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
}

switch(dataGridView1.Columns[e.ColumnIndex].Name)
{
case "polEffDtDataGridViewTextBoxColumn":
_Rectangle = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true);
dtp.Size = new Size(_Rectangle.Width, _Rectangle.Height);
dtp.Location = new Point(_Rectangle.X, _Rectangle.Y);
dtp.Visible = true;
break;
case "polExpDtDataGridViewTextBoxColumn":
_Rectangle = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true);
dtp.Size = new Size(_Rectangle.Width, _Rectangle.Height);
dtp.Location = new Point(_Rectangle.X, _Rectangle.Y);
dtp.Visible = true;
break;

}
}

Looking forward for your help:) Thank You

Thirumadhi T Johnson 15-Jun-22 7:52am View

Hi I have 4 columns along with checkbox @Fydobas below is the Update Method
public void Update()
{
int tbl_pol__id = 0;
string LUB = string.Empty;
string POL_No = string.Empty;
DateTime Effdate;
DateTime Expdate;

//if (MessageBox.Show("Would like to update then click yes!!",
// "Input Policy", MessageBoxButtons.YesNo) ==
// System.Windows.Forms.DialogResult.Yes)
MessageBox.Instance.ShowMessageBox("Would like to update then click yes!", "Yes", "No");
if (MessageBox.Instance.IsDialogResultOK)
{
foreach (DataGridViewRow dgvrow in dataGridView1.SelectedRows)
{

if (Convert.ToBoolean(dgvrow.Cells["chkbox"].Selected) == true)
{

LUB = dgvrow.Cells["luBDataGridViewTextBoxColumn"].Value.ToString();
POL_No = dgvrow.Cells["polNoDataGridViewTextBoxColumn"].Value.ToString();
Effdate = Convert.ToDateTime(dgvrow.Cells["EffDtDataGridViewTextBoxColumn"].Value);
Expdate = Convert.ToDateTime(dgvrow.Cells["ExpDtDataGridViewTextBoxColumn"].Value);
tbl_pol__id = Convert.ToInt32(dgvrow.Cells["TBL_POL_ID"].Value);

collServClient.UpdateInputPolicyData(tbl_pol__id, LUB, POL_No, Effdate, Expdate);

}

}

MessageBox.Instance.ShowMessageBox(ConstantsUI.C_Close);
Globals.ThisWorkbook.Close(0);
}
}

and the same update method I am calling from
private void btnUpdate_Click(object sender, EventArgs e)
{
bool Msgalert = false;
int total = dataGridView1.Rows.Cast<datagridviewrow>().Where(p => Convert.ToBoolean(p.Cells["chkbox"].Value) == true).Count();

if (total > 0 )
{

Update();
}
else if (total == 0)
{
MessageBox.Instance.ShowMessageBox("Please Select at least one checkbox");
Msgalert = MessageBox.Instance.IsDialogResultOK;
}
}

So can you please help me now with given codes how to achieve my query if no cells value has changed than shows Messagebox like "No records updated "

Thirumadhi T Johnson 15-Jun-22 2:38am View

in your code where can I write the validation message like 'No records are updated'

Thirumadhi T Johnson 15-Jun-22 2:38am View

Hi @Fydobas there is no cellvaluechanged event in my code ,I have event cellClick,selectionChanged,CellBeginEdit,Scroll,CellValidating

Thirumadhi T Johnson 7-Jun-22 7:39am View

So do I need to add this line of code public void Quit (); after updating so that it will close my excel workbook immediately !!!

Thirumadhi T Johnson 30-May-22 8:16am View

Ohk Thank You

Thirumadhi T Johnson 30-May-22 7:00am View

such as any example @Richard

Thirumadhi T Johnson 30-May-22 6:20am View

hmm That is the Challenge because they are not looking for Password Protection

Thirumadhi T Johnson 30-May-22 3:48am View

but Richard if I click on Unprotect option in excel it allows the users to edit again no matter if cell is locked too the same cell we can do anything it is unprotected sheet.

Thirumadhi T Johnson 30-May-22 3:44am View

So Here I am looking for both ways either in event handler we can mention few users name who can do delete,insert or edit in specific sheet or in Sub by doing the same thing .I hope now it is clear .Looking forward for help please

Thirumadhi T Johnson 30-May-22 3:41am View

Yes u r right @matblue25 ,I want to do in a Sub not in event handler .Password Protecting is also not a requirement. So for specific users the sheets should be enable for everything and rest of the users only can see like read only mode ,if we click on option Unprotect Sheet also ,the same specific users should not be able to do anything rather than only seeing. Or else is it Possible to specify 5/6 Users name in event handler for specific sheet that they can have all the rights to perform .

Thirumadhi T Johnson 27-May-22 14:57pm View

I tried this way but nothing is getting locked @Richard my task is to lock the entire worksheet if it unprotected mode too but not through any event but calling any method such as public sub Protectcell() like this .

Thirumadhi T Johnson 27-May-22 14:57pm View

Public Sub hi()
Dim xRg As Range
Dim xr As Range
Dim xRgEx As Range
Dim xRgExEach As Range
On Error Resume Next
Application.ScreenUpdating = False
Set xr = Sheets("Sheet1").Range("A:N,1:15")
xr.Locked = True
'Set xRg = Sheets("Sheet1").Range("M:Z,15:30") 'Change the row range and column range you will lock without protecting worksheet
'Set xRgEx = Application.Intersect(xr, xRg)
'If xRgEx Is Nothing Then Exit Sub
'Cells(1, 1).Select 'Specify a cell you will shift to after selecting the locked cells
Application.ScreenUpdating = False
End Sub

Thirumadhi T Johnson 8-Sep-21 0:36am View

Hi Richard, I upgraded it to 4.6.1 using VS 2019 but in Web Config still I see 3.5.0.0 version.For reference please see the below---
<sectiongroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<sectiongroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<sectiongroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

Thirumadhi T Johnson 6-Sep-21 1:29am View

Hi @DonathanH, I have migrated the Web application from .NET framework v3.5 to v4.6.1. Version number got changed to v4.6.1 in project properties and compiled successfully.
But it is WCF related project so while running the project it is asking for add Service.
Before it was with 2010 VS and now I opened with VS 2015 with changing Target Framework 4.6.1.

Thirumadhi T Johnson 6-Sep-21 1:28am View

Hi Richard, I have migrated the Web application from .NET framework v3.5 to v4.6.1. Version number got changed to v4.6.1 in project properties and compiled successfully.
But it is WCF related project so while running the project it is asking for add Service.
Before it was with 2010 VS and now I opened with VS 2015 with changing Target Framework 4.6.1.

Thirumadhi T Johnson 6-Sep-21 0:28am View

is it supported VS 2015 also for 4.6.1 framework ?

Thirumadhi T Johnson 20-May-21 5:51am View

Ok Rick let me try and thank you so much

Thirumadhi T Johnson 20-May-21 3:01am View

Hi Rick...waiting for your response.Any luck

Thirumadhi T Johnson 19-May-21 5:48am View

Ok

Thirumadhi T Johnson 19-May-21 2:52am View

Hi Rick
After this how do I write in
private void btnBack_Click(object sender, EventArgs e)
{
this.Hide();
CollateralWelcome CW = new CollateralWelcome();
CW.Show();
}

Please suggest me as I am new in Coding

Comments by Thirumadhi T Johnson (Top 44 by date)