Unable to save file into Download folder of a window machine using c# .net

See also questions close to this topic

• C# - Adding condition to func results in stack overflow exception

  I have a func as part of specification class which sorts the given iqueryable

  Func<IQueryable<T>, IOrderedQueryable<T>>? Sort { get; set; }
  

  When i add more than one condition to the func like below , it results in stack overflow exception.

  spec.OrderBy(sc => sc.Case.EndTime).OrderBy(sc => sc.Case.StartTime);
  

  The OrderBy method is implemented like this

  public ISpecification<T> OrderBy<TProperty>(Expression<Func<T, TProperty>> property)
      {
          _ = Sort == null ? Sort = items => items.OrderBy(property) : Sort = items => Sort(items).ThenBy(property);
          return this;
      }
  

  Chaining or using separate lines doesn't make a difference.

  This problem gets resolved if I assign a new instance of the specification and set it's func, but i don't want to be assigning to a new instance everytime. Please suggest what am i missing here and how to reuse the same instance (if possible).
• How to projection fields for a dictionary (C#, MongdoDB)

  I am trying my luck here, I have a model which is like the following

  public class RowData : BaseBsonDefinition
  {
  .
    [BsonExtraElements]
    [BsonDictionaryOptions(DictionaryRepresentation.ArrayOfDocuments)]
    public Dictionary<string, object> Rows { get; set; } = new(StringComparer.OrdinalIgnoreCase);
  .
  }
  
  

  In result, the schema in the MongoDB looks like

  {
  "_id": {
      "$binary": {
        "base64": "HiuI1sgyT0OZmcgGUit2dw==",
        "subType": "03"
      }
    },
    "c1": "AAA",
    "c8": "Fully Vac",
    "c10": "",
  }
  

  Those c1, c8 and c10 fields are keys from the dictionary, my question is how to dynamic project those fields?

  I tried

  Builders<RowData>.Projection.Exclude(p => "c1")
  

  It seems the MongoDB driver can not handle a value directly.

  Anyone could point me in the correct direction?

  Thanks,
• How do I add new DataSource to an already Databinded CheckBoxList

  i'm building a web form that show Database's item(Tables, Rows, FK,...)

  I have a CheckBoxList of Tables (chkListTable) which will show a new CheckBoxList of Rows (chkListRow) everytime I SelectedIndexChanged from chkListTable. The problem is i can show the items from chkListTable with 1 selected item. But i don't know how to show chkListRow if multiple item from chkListTable are selected.

  Here are my codes:

  aspx:

  <div>
               <asp:Label ID="Label2" runat="server" Text="Table: "></asp:Label>
               <asp:CheckBoxList ID="chkListTable" runat="server"
                   DataTextField="name"
                   DataValueFeild="name"
                   AutoPostBack="true"
                   OnSelectedIndexChanged="chkListTable_SelectedIndexChanged">
               </asp:CheckBoxList>
          </div>
          <div>
               <asp:CheckBoxList ID="chkListRow" runat="server"
               DataTextField="COLUMN_NAME"
               DataValueField="COLUMN_NAME"
               RepeatDirection="Horizontal">
               </asp:CheckBoxList>
          </div>
  

  aspx.cs:

  protected void chkListTable_SelectedIndexChanged(object sender, EventArgs e)
      {
          tableName.Clear();
          
          foreach (ListItem item in chkListTable.Items)
          {
              if(item.Selected)
              {
                  tableName.Add(item.Text.Trim());
              }    
          }
  
          for(int i = 0; i < tableName.Count; i++)
          {
              String query = "USE " + dbname +
                  " SELECT * FROM information_schema.columns" +
                  " WHERE table_name = '" + tableName[i] + "'" +
                  " AND COLUMN_NAME != 'rowguid'";
              chkListRow.DataSource = Program.ExecSqlDataReader(query);
              chkListRow.DataBind(); 
              Program.conn.Close();
          }
      }
  

  Program.cs:

  public static bool Connect()
      {
          if (Program.conn != null && Program.conn.State == ConnectionState.Open)
              Program.conn.Close();
          try
          {
              Program.conn.ConnectionString = Program.constr;
  
              Program.conn.Open();
  
              return true;
          }
  
          catch (Exception e)
          {
              return false;
          }
      }
  
      public static SqlDataReader ExecSqlDataReader(String query)
      {
          SqlDataReader myreader;
          SqlCommand sqlcmd = new SqlCommand(query, Program.conn);
          sqlcmd.CommandType = CommandType.Text;
          if (Program.conn.State == ConnectionState.Closed) Program.conn.Open();
          try
          {
              myreader = sqlcmd.ExecuteReader();
              return myreader;
              myreader.Close();
          }
          catch (SqlException ex)
          {
              Program.conn.Close();
              return null;
          }
      }
  

  I want my display to be like this:

  [x]Table1 [x]Table2 [ ]Table3
  [ ]Row1(Table1) [ ]Row2(Table1) [ ]Row3(Table1)
  [ ]Row1(Table2) [ ]Row2(Table2)
  
• site only opens in CefSharp

  zaakr.net is a site can be opened only in zaakr.exe application or through android(.apk), when opened in browser u been redirected to https://browser.zaakr.net so u download there application, (.exe) file is using cefsharp as a browser so it can access website, from 2 month i could open it from chromium as cefsharp uses chromium, now i can't access website through chromium for some reason idk, i even made a cefsharp browser myself using visual studio nothing worked all the time i been redirected to browser.zaakr.com, i want to access through any browser that have devtools available for a project, note that application zaakr.exe is still using cefsharp even the older version still can access site. i would appreciate any help, sry for any spelling mistakes, thanks.
• C# MariaDB Update Function working in DataStore but not updating in .NET Application

  My initial issue is that my database does not update when I call on this specific code. I am not sure if it is C# itself or the update query that I am calling.

  string _connectionString = "validConnectionstring";
  
  using (MySqlConnection _mySqlConnection = new MySqlConnection(_connectionString)
  {
  _mySqlConnection.Open();
  using (MySqlCommand command = new MySqlCommand("UpdateProfileStatus", _mySqlConnection))
  {
      command.Transaction = _mySqlConnection.BeginTransaction();
      command.CommandTimeout = TimeSpan.FromSeconds(60).Seconds;
      command.CommandType = CommandType.StoredProcedure;
      command.Parameters.AddWithValue("@_username", "test");
      command.Parameters.AddWithValue("@_status", true);
      command.ExecuteNonQuery();
      
  }
  _mySqlConnection.Close();
  }
  
  

  I get no updates in my database but my console logs that the query is executed returning the value of 1 but there is no update that actually happens in my DB. Is there something in my code to reason why it is failing?

  Here is the stored procedure that I have for the update command

  CREATE PROCEDURE UpdateProfileStatus(_username VARCHAR(25), _status BOOL)
  UPDATE Profile SET status = _status WHERE username = _username;
  
  
  

  I know the Stored Procedure works but am not sure why my .NET application is not responding to my procedure call. Is it something to do with my implementation of the parameters or is it my procedure itself?

  Image of DataStore Setting within MariaDB
• How to add a new Model visually in Mac OS visual Studio

  I do not see any choice to create a model in Mac visual studio? I In the windows version the Class created with its imports

  • using Linq

    using Threading.Tasks

    using Collection.Generic
• WebView2 JS injection returns empty json string

  With WebView2 for targeting Windows, I am trying to setup my own context menu. Either by selected text or by underlying element pointed by mouse click.

  However, I can't get DOM element by mouse operation or even by byId. I think my JavaScript injection or WebView property setting is something wrong, but not too sure. Can anyone suggest me the resolution?

  The version info.

  • OS : Windows 10 Pro 21H2 19044.1682
  • Visual Studio : Community 2022 17.1.6
  • WebView2 : 1.0.1185.39
  • Project Property: Target framework=.NET 6.0; Target OS version=10.0.19041.0

  Here's the testing code

  using Microsoft.Web.WebView2.Core;
  namespace WinFormsApp1
  {
      public partial class Form1 : Form
      {
          public Form1()
          {
              InitializeComponent();
              HTML(@"C:\temp\test.html");
          }
          public void HTML(string url)
          {
              webView21.CoreWebView2InitializationCompleted += WebView2Control_CoreWebView2InitializationCompleted;
              webView21.Source = new Uri(url);
          }
          private void WebView2Control_CoreWebView2InitializationCompleted(object? sender, CoreWebView2InitializationCompletedEventArgs e)
          {
              if (!e.IsSuccess)
              {
                  MessageBox.Show($"WebView2 creation failed, with exception : {e.InitializationException}");
                  return;
              }
              // subscribe to events we are interested in
              webView21.CoreWebView2.ContextMenuRequested += CoreWebView2_ContextMenuRequested;       // user clicked right mouse to show context menu
          }
          private async void CoreWebView2_ContextMenuRequested(object? sender, Microsoft.Web.WebView2.Core.CoreWebView2ContextMenuRequestedEventArgs e)
          {
              IList<CoreWebView2ContextMenuItem> menuItemList = e.MenuItems;
              menuItemList.Clear();  // clear default menu items, like prev, next, property
  
              //GETTING SELECTED TEXT
              string text = e.ContextMenuTarget.HasSelection ? e.ContextMenuTarget.SelectionText : ""; // it works
  
              if (string.IsNullOrEmpty(text))  // no text selection, then examine DOM
              {
              //GET AN UNDERLYING ELEMENT FROM MOUSE POINT
                  var result = await webView21.CoreWebView2.ExecuteScriptAsync($"document.elementFromPoint({e.Location.X},{e.Location.Y})");   //it doesn't work, just returns an empty JSON text (not null)
                  //var result = await webView21.CoreWebView2.ExecuteScriptAsync("function foo(){return 'foo() gets called';}; foo();");  //for testing purpose, it works
                  //var result = await webView21.CoreWebView2.ExecuteScriptAsync("function foo(){return document.getElementById('table-content'};foo();)");   //it returns an empty result
              }
              // TO DO
              // setup menuItem tree based on the result we got
              //......
              //......
              e.Handled = true;
          }
      }
  }
  
• Subprocess $Env:Path python: The filename, directory name, or volume label syntax is incorrect

  I am trying to change the windows environment variables, but I am having trouble doing so.

  Before I tried to use os.environ() I tried out using powershell commands and adding a string to $Env:Path which worked, but removing it with:

  $env:Path = ($env:Path.Split(';') | Where-Object -FilterScript {$_ -ne $Remove}) -join ';'
  

  however didn't seem to remove it being my path I want to add ("FFmpeg:C:\Users\user\AppData\") and adding it with += C:/Users/etc.. didn't see, the way to go.

  Another way I tried to add vars through the Powershell commands was using SetEnviormentVariable and it seemed to work fine but once I restarted my PC the entry I made with it was gone.

  Sadly though all in the end all my powershell commands didn't work with subprocess. Whatever command it was I was using here I got:

  PS C:\Users\Me123> python
  >>> import subprocess
  >>> subprocess.run("$Env:Path", shell=True)
  The filename, directory name, or volume label syntax is incorrect.
  
  CompletedProcess(args='$Env:Path', returncode=1)
  
• Why X,Y-coordinates (returned by iText) differ for the same text sitting in the same spot on different pdf pages?

  Good morning, everyone! I've encountered an issue with iText that might be a bug and am posting it here as suggested by the iText guidelines.

  If we look at this file - South Africa Tariff - we'll see its pages have the landscape orientation (Rotation=90) and show the same text (Date: 2022-04-29) in the same spot (top-left corner of the page). For our test, p.1,2,3 would suffice.

  Now, if we implement our own TextExtractionStrategy and inspect X,Y-coordinates of the character "D" (from the above-mentioned text), we'll see they differ from page to page:

  • p.1 (X=32.07, Y=36.0),
  • p.2 (X=559.0, Y=32.07),
  • p.3 (X=562.93,Y=559.0), where:

  X is retrieved from getDescentLine().getStartPoint().get(0),
  Y is retrieved from getDescentLine().getStartPoint().get(1).

  All 3 pages have the same CropBox [0,0,595,842].

  I would expect to see the same X,Y across all pages. Other products - xpdf, PdfBox and iTextSharp - do show consistent coordinates for "D" on all pages.

  Does this look like a bug in iText to your eyes? If anyone from the iText Team picks it up & needs more info, I'd be happy to help.

  Kind regards, Sit Anko.
• PDF from HTML with only alphabetic (Latin) using itextpdf

  I believe that the answer to my question is very easy for those who have had experience with this, and I thank you in advance.

  Namely, I managed to export a PDF file from TextView bodyText and titleText, but my problem is that only alphabetic (Latin) letters can be seen in that PDF file, I can't see an example in Arabic, Cyrillic, Indian or Hebrew, etc. Can anyone help me, thanks !!!!!!!!

  In Gradle I use: implementation 'com.itextpdf.tool:xmlworker:5.5.3'

  OutputStream file = new FileOutputStream(new File("MyPath"));
                              
  Document document = new Document (PageSize.A4);
  
  PdfWriter.getInstance(document, file);
                              
  document.open();
                              
  Paragraph title = new Paragraph();
  title.add(titleText.getText().toString());
  title.setSpacingAfter(12.0f);
  title.setAlignment(Element.ALIGN_CENTER);
  document.add(title);
  document.add(new Paragraph("\n"));
  HTMLWorker htmlWorker = new HTMLWorker(document);
  htmlWorker.parse(new StringReader(Html.toHtml((Spanned) bodyText.getText())));
      
  document.close();
  file.close();
  
• Open Browser with a specific url on sending request on API (.Net core MVC)

  Working on .Net Core MVC and IText7, I'm filling a Pdf form (empty form PDF is already saved on server). What I want is, Whenever I send request to the link (can be a API endpoint), it should forces my browser to open the pdf on it. Opening the Pdf is already achieved by the writing the header of the response with pdf file and also the write content-disposition to the header but the main problem is: How I can force my browser to be opened on sending a request to the .Net Core Application or .Net Core API?
• Upload code to Firebase Hosting from iPad

  Hi everyone and thanks in advance for your help, does any of you uploaded code to Firebase Hosting from an iPad? is there any console app that can be use to do so?

  Thanks a lot!
• Hosting a Strapi 4 + Gatsby 4 website in the same NodeJs server

  I am working on a business site with Events and Blog page that can be updated. For this I have chosen Gatsby 4 and Strapi 4. But in most of the tutorials, they have hosted these two separately like Heroku and Netlify/Digital Ocean. I am hoping for a cost effective NodeJs server from a local hosting service. How can I use the same NodeJS server to deploy a Gatsby 4 + Strapi 4 website?
• Web hosting - nodeJS

  I made a backend web application and frontend, there is no JS application, I run them "npm run start: dev" and "yarn start", that hosting then I have available on localhost: 4000. ... how to now import that hosting to web hosting / domain, can you give me advice on where to buy that web hosting, one that is not very expensive