|
Except no-where on that page does it tell me how to integrate a C# application with skype. I don't want to create a bot, accept payments, conduct interviews or add call links to my web app.
I want to detect incoming calls on skype, and flash up additional data on the users screen.
And to clarify, I'm talking *desktop* application, not mobile.
modified 11-Apr-18 9:21am.
|
|
|
|
|
Sonetimes I think the better question is: How to turn Skype off ... cameras, mikes, status monitors, background zombies.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
I created an excel user defined function using excel dna Add-In, My function should return a two dimentional array but when i call it from a cell (=mainView(2018-04-10) ) it displays only the first column name (FundName), below is my code:
<pre> public static object[,] mainView(DateTime dt)
{
int rows = 0;
int columns = 0;
const int columnsArrayIndex = 0;
DataTable dt = new DataTable();
object[,] allRecords = new object[0,0];
try
{
SqlConnection cnx = new SqlConnection("data source=...;initial catalog=...;integrated security=True");
cnx.Open();
string query = @"select FundName,...";
SqlCommand cmd = new SqlCommand(query, cnx);
using (SqlDataAdapter a = new SqlDataAdapter(cmd))
{
a.Fill(dt);
rows = dt.Rows.Count;
columns = dt.Columns.Count;
if (columns > 0 && rows > 0)
{
allRecords = new object[rows + 1, columns];
for (int i = 0; i <= columns - 1; i++)
{
allRecords[columnsArrayIndex, i] = dt.Columns[i].ColumnName;
}
for (int j = 0; j <= rows - 1; j++)
{
var rowItem = dt.Rows[j].ItemArray;
for (int k = 0; k <= rowItem.Length - 1; k++)
{
allRecords[j + 1, k] = rowItem[k];
}
}
}
}
}
catch
{
}
return allRecords;
}I would like to get all the rows of the select query result displayed in the excel, the result of the select query is dynamic, it changes when the date changes. What is missing in my code please so that i can get the result i want ? how can i display all the rows and columns of my query in the excel ?
|
|
|
|
|
I would suggest getting rid of the empty Catch block. There could be exceptions occurring, but you have no idea what they are because you're ignoring them.
Once you know what exceptions are occurring, you can solve them.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Hi,
I've never done such things, however I don't expect the content of a 2D array can be accepted by a single cell. You probably need to select a range of the correct size, then assign your UDF to the first cell of that range.
BTW: your code is very confusing as it seems to be using too many variable names to achieve what you want. And please never have an empty catch block, it will waste your and our time by NOT showing a lot of things that may be going wrong. Always catch an Exception and show the its entire ToString() result to the developer (and possibly later to the user).
|
|
|
|
|
Thank you, i found an example that returns the result in a range but when i did the same as the example i got an exception
"Exception de HRESULT : 0x800A03EC"
in this line
range.Value2 = result;
this is my code :
public static void LoadData(object[] args)
{
int rowPosition = Convert.ToInt32(args[0]);
int columnPosition = Convert.ToInt32(args[1]);
string sheetName = (string)args[2];
var application = (Microsoft.Office.Interop.Excel.Application)ExcelDnaUtil.Application;
var sheet = application.Sheets[Regex.Replace(sheetName, @"\[[^]]*\]", string.Empty)];
object[,] result = LoadFromDbData();
var startcell = sheet.Cells[rowPosition + 1, columnPosition + 1];
int rowCount = result.GetUpperBound(0)-result.GetLowerBound(0)+1;
int colCount = result.GetUpperBound(1)-result.GetLowerBound(1)+1;
var endcell = sheet.Cells[rowPosition+ rowCount, columnPosition+colCount];
try
{
Range range = (Range)sheet.Range(startcell, endcell);
range.Value2 = result;
}
catch (COMException e)
{
MessageBox.Show(e.Message);
}
}
|
|
|
|
|
Hi,
I have no idea what is going wrong, however this guy[^] probably knows.
And maybe looking at Exception.ToString() rather than Exception.Message would have helped too, as I told you before.
|
|
|
|
|
Hello,
I am new in MVC. I have one product table which has ProductID, ProductName and ProductRate. I have one dropdown list which has all the ProductName. Now I am trying to select the productname and upon this select, it should fill my textbox with ProductRate. Code is as below but it is not doing anything and no errors. Please help.
<script type="text/javascript">
function GetPrice(_this) {
var x = document.getElementById("productID"), selectedValue = x.value;
alert("_this" + _this.SelectedValue);
var pid = selectedValue;
alert(pid);
var url = '@Url.Action("GetPrice","Sales")';
alert(url);
$.ajax({
type:"POST",
url: 'Sales/GetPrice',
contentType: "application/json; charset=utf-8",
data: {ProductId: pid },
cache:false,
dataType: json,
async: true,
processData:false,
success: function (data)
{
alert("yay1");
},
failure: function (response) {
alert("Fail");
}
});
};
</script>
@using (Html.BeginForm())
{
@Html.ValidationSummary(true)
<fieldset>
<div class="editor-field">
<div class="editor-label">
@Html.LabelFor(model => model.ProductId)
</div>
@Html.DropDownListFor(model => model.ProductId, new SelectList(ViewBag.ProductList, "ProductId", "ProductName" ), "Select Product", new { id = "productID", onchange="GetPrice(this);"})
@Html.ValidationMessageFor(model => model.ProductId, "", new { @class = "text-danger" })
<span class="glyphicon glyphicon-asterisk"></span>
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Rate)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Rate, new { id = "idRate"})
@Html.ValidationMessageFor(model => model.Rate)
</div>\
</fieldset>
}
Here is my Controller "SalesController.cs" code:
[HttpPost]
public JsonResult GetPrice(int ProductId)
{
return Json("");
}
Dhyanga
modified 9-Apr-18 11:49am.
|
|
|
|
|
I am able to fix it.
Please disregard this post.
Dhyanga
|
|
|
|
|
Hi guys, I have some code here written in C++ which creates 3x3 matrixes. I believe that it's using EmguCV Matrix. However, I planned to convert this into C# language but I've failed to do so. To the best of my knowledge, most online solutions guide me to use an array. Therefore, I wish to know is anyone expert in C# that may help me explain how can I convert this code to C#? I wish to know the syntax of it in C#. Thank you
<pre>Mat eulerAnglesToRotationMatrix(Vec3f &theta)
{
Mat R_x = (Mat_<double>(3,3) <<
1, 0, 0,
0, cos(theta[0]), -sin(theta[0]),
0, sin(theta[0]), cos(theta[0])
);
Mat R_y = (Mat_<double>(3,3) <<
cos(theta[1]), 0, sin(theta[1]),
0, 1, 0,
-sin(theta[1]), 0, cos(theta[1])
);
Mat R_z = (Mat_<double>(3,3) <<
cos(theta[2]), -sin(theta[2]), 0,
sin(theta[2]), cos(theta[2]), 0,
0, 0, 1);
Mat R = R_z * R_y * R_x;
return R;
}
|
|
|
|
|
The "EmuguCV Matrix" sample you are showing is using a "Mat" class; why do you think that arbitrarily using an "array" instead (because the "internet" says so) makes sense?
Mind you, I know nothing about C++ other than I dislike it because of MFC, etc. ...
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
EmuguCV is jsut a .NET wrapper around OpenCV.
That C++ code is just creating 3 Matrix instances and initializing them with all the values are each matrix position. The underlying code implements this as arrays.
Keep in mind that I haven't touched C++ in a really long time and have never used EmuguCV or OpenCV. But, in C#, I think the equivalent would be something like
Matrix R_x = new Matrix<double>(3, 3) {
1, 0, 0,
0, Math.Cos(theta[0]), -Math.Sin(theta[0]),
0, Math.Sin(theta[0]), Math.Cos(theta[0])
}
|
|
|
|
|
fyi: a literal translation of the first matrix to C#:
double[] theta = new double[]{0.4444};
Double[,] MatR_X = new double[3, 3]
{
{ 1.0, 0.0, 0.0 },
{ 0.0, Math.Cos(theta[0]), -Math.Sin(theta[0])},
{ 0.0, Math.Sin(theta[0]), Math.Sin(theta[0])}
};However, you'll probably want to use the built-in Matrix3D Structure facilities in System.Windows.Media.Media3D: [^].
«... thank the gods that they have made you superior to those events which they have not placed within your own control, rendered you accountable for that only which is within you own control For what, then, have they made you responsible? For that which is alone in your own power—a right use of things as they appear.» Discourses of Epictetus Book I:12
|
|
|
|
|
I have a Polynomial class, which has integer coefficients and an integer field called Characteristic. When positive, the Characteristic value denotes that the coefficients represent elements of the integers mod Characteristic. What I would like is for type checking to consider Polynomials with different Characteristic values to be different types - it shouldn't be possible to do operations between Polynomials with unlike characteristics, and it would be nice if the characteristic were very visible rather than buried inside the object state, for example. I would use a syntax like Polynomial<3> to declare a Polynomial of characteristic 3, but barring that possibility, what else could I try? I can't explicitly declare classes for each characteristic I need, because I don't know which ones I'll need until runtime.
|
|
|
|
|
About the best I can suggest is C# 7.0 is constant type checking: is (C# Reference) | Microsoft Docs[^]
if (o is Polynomial p && p.Characteristic == 3)
{
...Messy, but ...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I happened across a way I might theoretically make the modulus value part of the type, but it's messier than your suggestion by a very wide margin: give Polynomial a type parameter that takes an Enum, generate an Enum at runtime whose number of elements is equal to the desired modulus using EnumBuilder, pass that to Polynomial, and use GetValues().Length or something to extract the modulus value. Definitely not worth it, haha.
Really, the important thing is that now I have a vote of confidence that there isn't an obvious "correct" way to handle it that I've missed.
|
|
|
|
|
Occam's Razor says: "Nope!" 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
My first thought was of using an Enum, keeping in mind that an Enum can have values that are not explicitly named: i.e.:
public enum PolyCharacteristicValue : Int32
{
NoCharacteristic = -1
}
public class Poly
{
public Poly(Int32 characteristic)
{
Characteristic = (PolyCharacteristicValue) characteristic;
}
public Poly(PolyCharacteristicValue characteristic)
{
Characteristic = characteristic;
}
public PolyCharacteristicValue Characteristic { set; get; }
}
Poly polyNoChar = new Poly(-1);
Poly polyT0 = new Poly(0);
Poly polyT99 = new Poly(99);Sketch: Then in some extension method:
public static class PolyExtensions
{
public static Poly PolyAdd(this Poly p1, Poly p2)
{
if (p1.Characteristic != p2.Characteristic)
{
throw new InvalidEnumArgumentException();
}
Poly newPoly = new Poly(p1.Characteristic);
if (p1.Characteristic == PolyCharacteristicValue.NoCharacteristic)
{
return newPoly;
}
return newPoly;
}
}The second idea would be to use a nullable Int in much the same way.
Would having the ability to compare two Polys, and do something if one of them's Enum value was greater, or lesser, than the other's be of any use ?
I am unclear if there's a relationship between the possible number of integer terms in the Polynomial and what is shown here as an Enum.
«... thank the gods that they have made you superior to those events which they have not placed within your own control, rendered you accountable for that only which is within you own control For what, then, have they made you responsible? For that which is alone in your own power—a right use of things as they appear.» Discourses of Epictetus Book I:12
modified 8-Apr-18 11:07am.
|
|
|
|
|
Why can't you use an enum as the characteristic. At that point, it's the enum parameter reflects the value.
public enum PolyCharType { Type1=1,Type2,Type3=3};
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Do you envision having Polynomial be a generic type, to which the enum gets passed as the parameter? I could do that. The wrinkle is that the desired characteristic values aren't statically known, so I'd have to generate the enums at runtime. I gather that it is possible to do this.
|
|
|
|
|
You weren't clear on when this "type checking" should occur: compile time or run time.
Big difference.
Run time code can be very intelligent with a very small interface.
A (dynamic) "property bag" can imply type via the existence (or absence) of a given property; with "methods" added on the fly.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
I was thinking compile time - my IDE underlining it in red if I tried to add two polynomials of unlike characteristic. Unless I'm missing something, runtime checks would only need to involve a field for the characteristic in the Polynomial class, and comparing the values in it at the top of each method that takes multiple Polynomials.
The place where I really started to wish compile time type checking reflected the characteristic was not to constrain what a caller can do, but to check myself while writing a very complicated method that generates many Polynomials of different characteristics internally in service of the calculation it needs to do.
|
|
|
|
|
Null and "something" is always null.
I would use the same philosophy here.
It's up to the "client" to make valid calls; the "server" just needs to keep from crashing.
Otherwise, use "type info" in the class. There is no "wrong" answer; only more or less coding.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
Alexander Kindel wrote: The place where I really started to wish compile time type checking reflected the characteristic was not to constrain what a caller can do, but to check myself
If you use over-ridden arithmetic operators, as shown in my first response to you, the parameter types of the arguments, and the specified return type, will effectively act as constraints.
«... thank the gods that they have made you superior to those events which they have not placed within your own control, rendered you accountable for that only which is within you own control For what, then, have they made you responsible? For that which is alone in your own power—a right use of things as they appear.» Discourses of Epictetus Book I:12
|
|
|
|
|
First time posting so please forgive me if I'm doing something wrong. I've read through the guidelines and have attempted many times to research this issue.
I'm attempting to use a C# script in SSIS to consume a JSON feed from a website. I found an amazing tutorial/blog which shows exactly what needs to be done. I've attempted to follow it step-by-step but the program keeps failing when it attempts to deserialize the JSON object. It fails with the below error message. Despite my best attempts, I can't figure out what I'm doing wrong, or if the JSON string has extra "stuff" that's messing with the deserialization. Any ideas?
Exception thrown: 'System.ArgumentException' in System.Web.Extensions.dll
JSON and SSIS Tutorial: Dennis and Jim's SSIS and BI Blog: Using a JSON Feed as a Data Source in SSIS[^]
Website JSON documentation: Card Objects · API Documentation · Scryfall Magic Card Search[^]
JSON Address: "https://api.scryfall.com/cards?"
JSON Class Generator: json2csharp - generate c# classes from json[^]
Code:
private Card[] GetWebServiceResult(string wUrl)
{
HttpWebRequest httpWReq = (HttpWebRequest)WebRequest.Create(wUrl);
HttpWebResponse httpWResp = (HttpWebResponse)httpWReq.GetResponse();
Card[] jsonResponse = null;
try
{
if (httpWResp.StatusCode == HttpStatusCode.OK)
{
Stream responseStream = httpWResp.GetResponseStream();
string jsonString = null;
using (StreamReader reader = new StreamReader(responseStream))
{
jsonString = reader.ReadToEnd().Replace("\\", "");
reader.Close();
}
JavaScriptSerializer sr = new JavaScriptSerializer();
jsonResponse = sr.Deserialize<Card[]>(jsonString);
}
else
{
FailComponent(httpWResp.StatusCode.ToString());
}
}
catch (Exception e)
{
FailComponent(e.ToString());
}
return jsonResponse;
}
private void FailComponent(string errorMsg)
{
bool fail = false;
IDTSComponentMetaData100 compMetadata = this.ComponentMetaData;
compMetadata.FireError(1, "Error Getting Data From Webservice!", errorMsg, "", 0, out fail);
}
}
#endregion
#region JSON Class
public class ImageUris
{
public string small { get; set; }
public string normal { get; set; }
public string large { get; set; }
public string png { get; set; }
public string art_crop { get; set; }
public string border_crop { get; set; }
}
public class Legalities
{
public string standard { get; set; }
public string future { get; set; }
public string frontier { get; set; }
public string modern { get; set; }
public string legacy { get; set; }
public string pauper { get; set; }
public string vintage { get; set; }
public string penny { get; set; }
public string commander { get; set; }
public string __invalid_name__1v1 { get; set; }
public string duel { get; set; }
public string brawl { get; set; }
}
public class RelatedUris
{
public string tcgplayer_decks { get; set; }
public string edhrec { get; set; }
public string mtgtop8 { get; set; }
}
public class PurchaseUris
{
public string amazon { get; set; }
public string ebay { get; set; }
public string tcgplayer { get; set; }
public string magiccardmarket { get; set; }
public string cardhoarder { get; set; }
public string card_kingdom { get; set; }
public string mtgo_traders { get; set; }
public string coolstuffinc { get; set; }
}
public class AllPart
{
public string @object { get; set; }
public string id { get; set; }
public string name { get; set; }
public string uri { get; set; }
}
public class Datum
{
public string @object { get; set; }
public string id { get; set; }
public string oracle_id { get; set; }
public List<object> multiverse_ids { get; set; }
[JsonProperty("name")]
public string Name { get; set; }
[JsonProperty("uri")]
public string Uri { get; set; }
public string scryfall_uri { get; set; }
public string layout { get; set; }
public bool highres_image { get; set; }
public ImageUris image_uris { get; set; }
public double cmc { get; set; }
public string type_line { get; set; }
public string oracle_text { get; set; }
public string mana_cost { get; set; }
public string loyalty { get; set; }
public List<object> colors { get; set; }
public List<object> color_identity { get; set; }
public Legalities legalities { get; set; }
public bool reserved { get; set; }
public bool reprint { get; set; }
public string set { get; set; }
public string set_name { get; set; }
public string set_uri { get; set; }
public string set_search_uri { get; set; }
public string scryfall_set_uri { get; set; }
public string rulings_uri { get; set; }
public string prints_search_uri { get; set; }
public string collector_number { get; set; }
public bool digital { get; set; }
public string rarity { get; set; }
public string illustration_id { get; set; }
public string artist { get; set; }
public string frame { get; set; }
public bool full_art { get; set; }
public string border_color { get; set; }
public bool timeshifted { get; set; }
public bool colorshifted { get; set; }
public bool futureshifted { get; set; }
public int edhrec_rank { get; set; }
public RelatedUris related_uris { get; set; }
public PurchaseUris purchase_uris { get; set; }
public string flavor_text { get; set; }
public string usd { get; set; }
public int? story_spotlight_number { get; set; }
public string power { get; set; }
public string toughness { get; set; }
public List<AllPart> all_parts { get; set; }
public string eur { get; set; }
public string watermark { get; set; }
}
public class Card
{
public string @object { get; set; }
public int total_cards { get; set; }
public bool has_more { get; set; }
public string next_page { get; set; }
public List<Datum> data { get; set; }
}
#endregion
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
