|
LOL, no worries - I didn't check the user name(s).
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Your post here[^]
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
How can I play flash on C# form? Can you help me about that please?
Thanks in advance.
|
|
|
|
|
Link 1[^]
Link 2[^]
Both do exactly what you should have done before posting and you might have been finished this project (or the part that you asked about) by now instead of waiting for another to do a simple search you could have done yourself.
|
|
|
|
|
The problem is that you answered in just about 12 minutes. You're never going to teach him by giving him such good service.
Scott
|
|
|
|
|
Maybe he will say thats 12 minutes I could have saved by typing in googles URL
|
|
|
|
|
Maybe...but don't hold your breath.
|
|
|
|
|
|
|
What I want to do is something like this, which fails because NumericID is an int type.
ds_Search.SelectParameters.Add("NumericID", "%");
The only relevant hit I was able to find was from the dubious quality website expert exchange (first result, very bottom of the page)[^]which said I either needed to change the DB to have a string field (not possible) or write seperate queries for the wildcards (impractical because there're dozens that would need duplicated).
Are those really my only options?
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
A numeric is not a string, but you can convert the NumericId to a string in a query. Only then can it be compared with a string.
Jean-Christophe Grégoire
|
|
|
|
|
Do you mean a query that would take a string parameter and convert it into a number before looking at the table? If so, could you give an example?
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
What records are you selecting with that? Every record that has an int-value of "%"?
I don't understand what you are trying to do here. What is the SQL-variant of the query you wanna run?
I are troll
|
|
|
|
|
Hopefully this'll still make sense after being (heavily) cut down and generalized, the real query has more stuff in all 3 sections of sql statement.
SELECT table1.table1ID AS ID, table2.OrgTypeID
FROM (table1 INNER JOIN table2 ON table1.table2ID = table2.table2ID)
WHERE (table2.table4ID = ?)
table2.table4ID is selected from a listbox that contains all the values in table4 (each giving a table4ID value) or "all" in which case I want to pass a wildcard in.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
dan neely wrote: or "all" in which case I want to pass a wildcard in.
How about removing the
WHERE (table2.table4ID = ?)
If you omit the WHERE-clause altogether, wouldn't that effectively give you all the records that a wildcard would select?
I are troll
|
|
|
|
|
See my original post. Sometimes I need a wildcard, sometimes I have a specific value. I'd prefer not having to duplicate a dozenish queries if I don't have to in order to implement the wildcard because of the increased maintainability difficulty.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
As far as I know, ANSI-SQL supports wildcards only for filtering on text-based columns, through the LIKE-operator. This option gives you two separate queries;
SELECT table1.table1ID AS ID, table2.OrgTypeID
FROM (table1 INNER JOIN table2 ON table1.table2ID = table2.table2ID)
WHERE (table2.table4ID = 10) (10 being an example of a specific value)
SELECT table1.table1ID AS ID, table2.OrgTypeID
FROM (table1 INNER JOIN table2 ON table1.table2ID = table2.table2ID)
WHERE (CAST(table2.table4ID AS NVARCHAR) LIKE ('%'))
The second version will convert all values in the table4ID-column to the NVARCHAR datatype.
I are troll
|
|
|
|
|
An engineer was trying to set this up to access the Usage string array in struct from main.cs class. see code snippets below. The problem is that the object variable uArray can't see the Usage array from the struct. Can anyone help me to get the string array of Usage in main.cs?
<Code snippet>
// InfoTable.cs
using System;
using System.Collections.Generic;
using System.Text;
namespace infoTable
{
public class InfoTable
{
private struct InfoStruct
{
public string[] Usage;
public string[,] Line;
}
int DLLVer = 1000;
ACMEStruct ACME = new ACMEStruct();
public ACME_Info()
{
ACME.UsageCodes = new string[255];
ACME.UsageCodes[0] = "lab 0";
ACME.UsageCodes[4] = "lab 4";
ACME.UsageCodes[5] = "lab 5";
}
public object GetACMEValues()
{
return ACME;
}
}
}
// main.cs
private void readUsageArray()
{
InfoTable iTable = new InfoTable();
object uArray = iTable.GetACMEValues();
}
|
|
|
|
|
I take it that you are converting the returned object to the correct type (ACMEStruct , I believe); like this:
ACMEStruct acme = (ACMEStruct)uArray;
If not, then you need to do this in order to access the ACMEStruct members of the Object by unboxing it into the appropriate type. If you are already doing this please include the relevant portions of the ACMEStruct definition.
Keep It Simple Stupid! (KISS)
|
|
|
|
|
Hi,
I have code in javascript but it resize the text it also resize the image in my page.Let me know how to avoid resize of the image.
function resizeText(multiplier) {
if (document.body.style.fontSize == "")
{
document.body.style.fontSize = "12px";
document.body.style.lineHeight = "14px";
}
var fontSize = parseInt(document.body.style.fontSize) + (multiplier * 1);
if (fontSize <= 17 && fontSize >= 12) {
document.body.style.fontSize = parseInt(document.body.style.fontSize) + (multiplier * 1) + "px";
document.body.style.lineHeight = parseInt(document.body.style.lineHeight) + (multiplier * 1) + "px";
var p = document.getElementsByTagName('p');
for (i = 0; i < p.length; i++) {
p[i].style.fontSize = (parseInt(document.body.style.fontSize) + "px");
p[i].style.lineHeight = (parseInt(document.body.style.lineHeight) + "px");
}}}
<area shape="rect" coords="7,2,60,16" href="javascript:void(0);" onclick="resizeText(-1) ; javascript:pageTracker._trackPageview(''/coumadin/link/header_decrease_fontsize''); " /><area shape="rect" coords="60,2,103,16" href="javascript:void(0);" onclick="resizeText(1) ; javascript:pageTracker._trackPageview(''/coumadin/link/header_increase_fontsize''); " />
|
|
|
|
|
This is the C# forum. Not the javascriptweb development forum.
modified on Friday, January 9, 2009 11:29 AM
|
|
|
|
|
IN c# i am accessing javascript.Do you have any idea .Please let me know.
Thnaks
|
|
|
|
|
But your error doesn't lie in the C# coding, it lies in the javascript. You won't find much help here for a problem like that.
|
|
|
|
|
mkalantri wrote: Let me know how to avoid resize of the image.
Why, are we married, all of a sudden?
I are troll
|
|
|
|
|
Hello Forum
I wonder if what I can do this.
I have an application in C# that should be able to work in multiple languages, this is ok, but I have issue with combo boxes, I will try to explain.
I have a combo box bound to a database the column name is Color, based on the color the user choose the program will do something else i.e. if the user choose Black method A will be executed if the user choose Yellow method B will be executed.
So I am setting the comboBox1.DataSource, comboBox1.DisplayMember and comboBox1.ValueMember,
But when I am using another language I need the combo box options displayed to the user should be ‘Noir’ (for black) and ‘Jaune’ (for yellow) however the value save to the database should always be the English word.
Can it be done? And if yes, how?
Please Help.
Thank you very much
|
|
|
|