Comments by mtoha (Top 39 by date)

what is get total function?

https://learn.microsoft.com/en-us/windows/win32/api/mfreadwrite/nf-mfreadwrite-imfsinkwriter-finalize If this method succeeds, it returns S_OK. Otherwise, it returns an HRESULT error code.
that finalize should give return error. try to catch return message from finalize method .

https://stackoverflow.com/questions/33767688/video-recording-hangs-on-imfsinkwriter-finalize/33878513#33878513 try to check this thread,..

When you succeed to reset password is this message appeared? "Password reset successfully." What is the data containing when success? If that message is already appeared on success, try this :
// console.log($('#forgot-password').serialize());
$.ajax({
url: "forgot-password.php",
type: "POST",
data: formData,
success: function(data){
if(data == "success"){
alert("Password reset successfully.");
$('#forgot-password')[0].reset();
window.location.href = "dashboard.php";
}else if(data == "error"){
alert("Invalid email or OTP code.");
}else if(data == "password_mismatch"){
alert("New password and confirm password do not match.");
}else{
alert("Something went wrong. Please try again later.");
}
}
});


Note: Should you not import jQuery twice. When I try your existing code, $("#forgot-password").submit(function(event){
that method is not called. I change it to : $("#forgot-password .btn-primary").click(function(event){
and this is fired.

I would recommend you change report type to RDLC format. Instead of RDL
This code is painful. RDLC has report designer, you can use report viewer too.
This case is like when I am forgotten to install Font, and the characters being ???????.
Or when I use RDLC to show barcode, if I forgotten to install font, the barcode is not showing.

Is this happened to client or at server? If this is happened to all Computers, maybe bugs.

If you see the designer, try to check the Font. Like my picture at answer. The Font Type is SimSun. Previously, the default is Arial

can you add picture and codes how you make components on your report?

Are you using RDL or RDLC?
If you use RDL, I read from this site, it is can add component and use Style block to modify FontStyle.
https://www.grapecity.com/blogs/how-to-create-rdl-report-net-c-sharp-code#Creating_an_RDL_report

Like this:
customerFooter[0].ReportItems.Add(new GrapeCity.ActiveReports.PageReportModel.TextBox()
{
Name = "Company Name",
Value = "=\"Total Customer Count: \" & CountRows()",
Style = {
VerticalAlign ="Middle",
PaddingLeft="3pt",
TextAlign = "Left",
FontWeight = "Bold" }
});

If you giving up about this case, consider to move to RDLC format. it is easier to modify from UI designer set the FontStyle by UI. Like my program shown

have you succeed to save chinese characters on database? Sometimes, if SQL Server and some databases failed to detect encoding, the characters saved it to unreaded characters. if you debug it, when characters loaded from SQL server, is it on correct chinese format?

As far as I know, Your custom fonts should be installed on Operating System (eg : Windows),
Have you install SimSun font?

to get list of data.list[i].SubType.Name, you can use LinQ. var allSubtypeName = data.List.SelectMany(b => b.SubType).Distinct(); from this you can select again using LinQ and get list of Subtype.Name

I am using PDFsharp and this lib generates error. For free library, as far as I know, there are few library for PDF you can search at nugget. For free library, usually for GPU lisence, not for business or propietary application.

is this javascript? Or you want to collect data using Backend? can you draw to the excel, how is the data shown at excel?

in short, what is your talking about? Where is the images and codes?

try to use
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
You use SqlException at this case.
Try to move your code from SqlCommand into try block like this:
try
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("Name_First", txtbox_first_name.Text);
cmd.Parameters.AddWithValue("Name_Last", txtbox_last_name.Text);


And what is the value of connectionString if you debug it?

You should check the form sent twice or not. on the request. you can use js loader to prevent user click form twice

where is html form code?
Is it using ajax post or using Form?

I am agree with above comment. never store file in the database. I store my file to hdd/ssd disk space or file store firebase or something like that. You can also using FTP if needed.

I would recommend, you use temporary file to save original excel. Then doing modification using excel library, and then save modified excel.

console.log("data is" + data);
what is the response?
have you succeed to get branch data based on country?

What kind of project? asp.net mvc? asp.net webform? What is the version of .NET?

Gerry giving correct direction. you should close the access connection after finish querying

I usually using get method. i.e. you want to get picture, so the web api read files from server, and return base64 string.
and client (xamarin) decode from base64 to image.
for read file using get method, there is no file size restriction as I know.

what is client in this line? var response = await client.PostAsync(url,content);
Are you want to upload file more than 16384? What is correct size? in byte or Kb? WEB API built with .net core or .net? what version of .net (core)

this is great direction. thank you
https://learn.microsoft.com/en-us/ef/core/testing/testing-with-the-database

I am glad to hear you can solve the problem.
At my case, I try both of my functions, that is working.
I use JWT header also while testing that methods. and using Post sending some params.
That alternatives is working too for me

second function using restSharp, and some methods is deprecated. You can also try this
public async Task<m> ConnectRestClient<r, m="">(string apiUrl, R reqModel)
{
M model = default(M);

RestClient restClient = new RestClient(apiUrl);
RestRequest restRequest = new RestRequest(apiUrl, RestSharp.Method.Post);
restRequest.AddParameter(
"application/json",
JsonConvert.SerializeObject(reqModel),
ParameterType.RequestBody);
RestResponse restResponse = await restClient.ExecuteAsync(restRequest);
if (restResponse.IsSuccessful)
{
string response = restResponse.Content;
model = JsonConvert.DeserializeObject<m>(response);
}
return model;
}

that request have no header, you should add it by custom above method.
And I want to see what is the response of the request and how you try it? What you passed at function.

are you sure post parameters sent is api_key and email?
are you sure with your url?

Alright. great.. You are welcome

is your report loading big size of data? You are just browse one report or browse directory in browse path?

This script shoould replaced : ScriptManager.RegisterStartupScript(this, this.GetType(), "HidePopup", "$('#MyDispach').modal('show')", true);
to :
ScriptManager.RegisterStartupScript(this, this.GetType(), "HidePopup"+Guid.NewGuid().ToString(), "$('#MyDispach').modal('hide')", true);

Use developer mode, and run at console,
$('#MyDispach').modal("hide");
is the modal closed?

if your key isn't changed this script will only execute once

actually, when I am having that error, I am just skip that error. SQL DB Project sometimes buggy, and no problem with another .NET Project.

I hope code project provide feature to do this. Upload image file and text file to the forum discussion, etc.

That is will be great..