|
Now I am also doubting in that direction, I have installed the Python runtime and assigned the path, it fixed the issue, thank you so much.
|
|
|
|
|
Greetings experts,
I was looking for windows forms but didn't find one. I hope it is ok to post here.
I am trying to display records from the database so I can add/delete/update records.
The way I have this set up, clicking on a row of records populates the textboxes associated with the rows on the code below.
So far, when I click on any row, the textboxes are not getting populated.
My assumption is that I am not getting the correct rowindexes for each of the rows in DataGridView control.
Is there an easier way to find out which rowindex each of the rows belong to.
Better yet, is there a better way of displaying the records and when each row is clicked, the associated textboxes are populated?
The datagridview rows are getting populated. What is not working is clicking on a row and getting textboxes populated.
Your assistance as usual is greatly appreciated.
private void DisplayData()
{
con.Open();
DataTable dt=new DataTable();
adapt=new SqlDataAdapter("SELECT t.TransactionID,m.FullName,convert(varchar,m.registration_date,101) as registration_date," +
"m.enelope_number,Reg_Fee,t.Amount,t.AmountPaid,t.AmountOwed as Past_Due " +
"from dbo.Transactions AS t INNER JOIN dbo.Members AS m ON t .MemberID = m.MemberID INNER JOIN " +
"dbo.PaymentTypes AS p ON t .TypeID = p.PaymentTypeID", con);
adapt.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void ClearData()
{
Email.Text = "";
Phone.Text = "";
TransactionID = 0;
}
private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
TransactionID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
memberName.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
Email.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
Phone.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
Address.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
member_sex.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
date_member_registered.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
envelope_number.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
}
private void btn_Update_Click(object sender, EventArgs e)
{
if (Email.Text != "" && Phone.Text != "")
{
cmd = new SqlCommand("update Transactions set Name=@name,State=@state where transactionID=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", TransactionID);
cmd.Parameters.AddWithValue("@amount", Email.Text);
cmd.Parameters.AddWithValue("@paid", Phone.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Record Updated Successfully");
con.Close();
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Update");
}
}
private void btn_Delete_Click(object sender, EventArgs e)
{
if(TransactionID!=0)
{
cmd = new SqlCommand("delete from Transactions where transactionID=@id",con);
con.Open();
cmd.Parameters.AddWithValue("@id",TransactionID);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Deleted Successfully!");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
}
Does anyone
|
|
|
|
|
samflex wrote: I was looking for windows forms but didn't find one.
Windows Forms Discussion Boards[^]
The RowHeaderMouseClick event[^] only fires when you click on the row header, not when you click on the row itself. There isn't an event that's raised when you click on a row, but you can use the CellClick event[^] to fake it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Message Removed
modified 21-Jan-19 19:35pm.
|
|
|
|
|
Hi,
I am getting the above mentioned error when I am running my application, this application have been downloaded from my company Git location, I have installed Node and npm, those things are sorted out, except few components under npm folder are showing yellow sign that they are not installed yet. But I am not sure why is this error showing up when I am running the application. And another thing is I don't have Admin privileges on the same machine I am running the app, is it something because of that I have no idea - any help would be very very helpful.
Again the error message here:
The reference assemblies for framework ".NETFramework,Version=v4.6.2" were not found. To resolve this, install the SDK or Targeting Pack for this framework version or retarget your application to a version of the framework for which you have the SDK or Targeting Pack installed. Note that assemblies will be resolved from the Global Assembly Cache (GAC) and will be used in place of reference assemblies. Therefore your assembly may not be correctly targeted for the framework you intend. CustomerServiceWeb.Selenium.Test
|
|
|
|
|
The error message is telling you that you need to upgrade your version of .NET. If you cannot do it yourself then talk to your manager or system administrator.
|
|
|
|
|
It is saying that, but actually the problem was different, it was resolved when I made certificates off and installed the npm though. I have installed it from Nuget Package Console, I think which is better.
|
|
|
|
|
That usually indicates you're running an application that targets 4.6.2 on a computer which has a later version of .NET installed, and doesn't have the correct targeting pack.
You can download the 4.6.2 pack from Microsoft, but you'll probably need an administrator to install it for you:
Download .NET Framework 4.6.2 Developer Pack[^]
Packs for other framework versions are available here:
.NET SDKs for Visual Studio[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks Rick, it has been resolved my friend.
|
|
|
|
|
Just checking, why is my message is under review buddy, did you set up any filters for me?
|
|
|
|
|
yes. There are some filters and they need human help.
I just let your messages through. For the future... please be patient instead of posting again
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Why is it only with me? Like am I a terrorist or what? If there is any terrorist currently in the World, its our Indias Prime Minister Narendra Modi, he killed or let killed 1000s of people for his benefit in Gujarat.
It didn't happen to me in the past, just for saying against a mass murderer, my postings are being filtered, is CP an independent platform of Well educated people or run by the government of Saudi Arabia to punish people who speak openly?
modified 23-Jan-19 0:42am.
|
|
|
|
|
simpledeveloper wrote: Why is it only with me?
It is not only with you. I can tell that.
simpledeveloper wrote: my postings are being filtered, is CP an independent platform of Well educated people or run by the government of Saudi Arabia to punish people who speak openly?
Don't dramatize. You are not being censored, you have just been caught by a spam filter that is in continuously improvement. Your message has needed a human "go" to be posted, but your freedom of speech has never been in risk.
CP has a pretty big user database. Spammers are always trying to post their crap here and the filters and the volunteers are the only defense. Please be understanding.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
But this never happened to me in the past, can't you please use some better words than dramatizing? Now you know that I am not a spammer, you defense yourself Sir, but when you know that a person is not a spammer, can you please remove the filters now? What is stopping you from doing it?
|
|
|
|
|
Individual posters are not addressed by spam filters, they are a RULES based system and cannot be refined to suit 1 person in millions.
Oh and don't post the entire error message in the heading. Do you see anyone else posting multiple lines as their heading?
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Hi Holmes, thanks for the reply my friend
Quote: Oh and don't post the entire error message in the heading. Do you see anyone else posting multiple lines as their heading?
I have not seen many peoples posts as I don't like to put nose into some others issues until I really need to read about that topic.
Do you think, is that the reason why I am being spammed here in this post? Actual post didn't give me any filters though, I got hit by the filter when I was responding to Richards answer - anyways, I felt like alienated man, I felt it bad buddy. I am feeling like somebody is pointing at me my friend.
|
|
|
|
|
It would not have been your header but something in your response content.
simpledeveloper wrote: anyways, I felt like alienated man, I felt it bad buddy. I am feeling like somebody is pointing at me my friend.
Don't be such a pussy, how can a business rule possibly be personal.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Oh really I'm pu**y are you human? Be a human first before becoming anything, I guess you're born to human parents at least.
Is no one seeing this? Why are your hands tied up to flag this message?
modified 23-Jan-19 23:29pm.
|
|
|
|
|
Quote: Thanks Rick, it has been resolved my friend.
This was the message I replied to Richard, what is there in this message that can catch me as spammer? I am not able to understand?
|
|
|
|
|
Go to the Bug&Suggestions forum and ask the admins, if you want.
For me, this topic is ended.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
In a vb.net 2010 web form application that uses web form controls, there is a 'process' button where the user can click on the button lots of times.
This causes problems in the application for every time the button is clicked on, that many records are created in the sql server 2016 database.
I would like a solution on how to prevent the user from clicking on the button more than one time. I have a 'click button' code to catch when the button is clixked right away.
But I would like to know what I can do so the user knows they cannot click the button more than once:
1. I could make the button invisible.
2. However I would either like to have a popup message and/or somewhere on the webpage saying they can click on the process button only one time.
Thus can you show me the code on preferable setting up a popup menu? If not, can you show me the code on how to display the message on the web form page?
|
|
|
|
|
|
give me better suggetions
|
|
|
|
|
Make a .CS file with name of ImportExcel.CS
:----
public class FileExt : ValidationAttribute
{
public string Allow;
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
if (value != null)
{
string extension = ((System.Web.HttpPostedFileBase)value).FileName.Split('.')[1];
if (Allow.Contains(extension))
return ValidationResult.Success;
else
return new ValidationResult(ErrorMessage);
}
else
return ValidationResult.Success;
}
}
public class ImportExcel
{
[Required(ErrorMessage = "Please select file")]
[FileExt(Allow = ".xls,.xlsx", ErrorMessage = "Only excel file")]
public HttpPostedFileBase file { get; set; }
}
And Add this code to your controller
:-----
public ActionResult ImportExcel()
{
return View();
}
[HttpPost]
public ActionResult importexcel(ImportExcel importExcel)
{
if (ModelState.IsValid)
{
string path = Server.MapPath("~/library/ExcelFile/" + importExcel.file.FileName);
importExcel.file.SaveAs(path);
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source='" + path + "';Extended Properties='Excel 12.0;'";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
excelConnection.Open();
string tableName = excelConnection.GetSchema("Tables").Rows[0]["TABLE_NAME"].ToString();
excelConnection.Close();
OleDbCommand cmd = new OleDbCommand("Select * from [" + tableName + "]", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
SqlBulkCopy sqlBulk = new SqlBulkCopy(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
sqlBulk.DestinationTableName = "ExcelFile";
sqlBulk.ColumnMappings.Add("Userid", "Userid");
sqlBulk.ColumnMappings.Add("Name", "Name");
sqlBulk.ColumnMappings.Add("TelephoneNo", "TelephoneNo");
sqlBulk.ColumnMappings.Add("Address", "Address");
sqlBulk.ColumnMappings.Add("EmailAddress", "EmailAddress");
sqlBulk.WriteToServer(dReader);
excelConnection.Close();
ViewBag.Result = "Successfully Imported";
}
return View();
}
And create view page of ImportExcel method with name of ImportExcel.cshtml and add this code
:-----
@model Models.GeneralModel.ImportExcel
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>ImportExcel</title>
</head>
<body>
<div style="float:right">
<h4>@ViewBag.Result</h4>
@using (Html.BeginForm("ImportExcel", "NewCustomer", FormMethod.Post, new { enctype = "multipart/form-data" }))
{
@Html.TextBoxFor(m => m.file, new { type = "file" })
<button id="submitButton" type="submit">Submit</button>
@Html.ValidationMessageFor(model => model.file)
}
</div>
</body>
</html>
|
|
|
|
|
You do realise we can all see you talking to yourself, don't you? 
Quote:
string extension = ((System.Web.HttpPostedFileBase)value).FileName.Split('.')[1];
Lots of problems with that line. For example, what if the uploaded file doesn't contain an extension? What if it contains multiple "." characters? What if the extension is .lsx? Etc.
Try:
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
var file = value as System.Web.HttpPostedFileBase;
if (file != null)
{
string extension = System.IO.Path.GetExtension(file.FileName);
string[] allowedExtensions = Allow.Split(',');
if (!Array.Exists(allowedExtensions, ext => string.Equals(ext, extension, StringComparison.OrdinalIgnoreCase)))
{
return new ValidationResult(ErrorMessage);
}
}
return ValidationResult.Success;
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
