text resize in my web page - C# Discussion Boards

Re: How do I pass a wildcard to a data source query

Eddy Vluggen9-Jan-09 8:43

9-Jan-09 8:43

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 Smile | :)

Re: How do I pass a wildcard to a data source query

Dan Neely9-Jan-09 10:41

Dan Neely

9-Jan-09 10:41

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

Re: How do I pass a wildcard to a data source query

Eddy Vluggen9-Jan-09 11:00

Eddy Vluggen

9-Jan-09 11:00

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 Smile | :)

Re: How do I pass a wildcard to a data source query

Dan Neely9-Jan-09 11:12

Dan Neely

9-Jan-09 11:12

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

Re: How do I pass a wildcard to a data source query

Eddy Vluggen9-Jan-09 11:45

Eddy Vluggen

9-Jan-09 11:45

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 Smile | :)

Accessing array in struct from other class

Blubbo9-Jan-09 4:52

Blubbo

9-Jan-09 4:52

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();
}

Re: Accessing array in struct from other class

Ben Fair9-Jan-09 5:30

Ben Fair

9-Jan-09 5:30

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)

text resize in my web page

bhatted9-Jan-09 4:51

bhatted

9-Jan-09 4:51

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''); " />

Re: text resize in my web page [modified]

EliottA9-Jan-09 5:18

EliottA

9-Jan-09 5:18

This is the C# forum. Not the ~~javascript~~web development forum.

modified on Friday, January 9, 2009 11:29 AM

Re: text resize in my web page

bhatted9-Jan-09 6:05

bhatted

9-Jan-09 6:05

IN c# i am accessing javascript.Do you have any idea .Please let me know.

Thnaks

Re: text resize in my web page

EliottA9-Jan-09 6:08

EliottA

9-Jan-09 6:08

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.

Re: text resize in my web page

Eddy Vluggen9-Jan-09 8:45

Eddy Vluggen

9-Jan-09 8:45

mkalantri wrote:
Let me know how to avoid resize of the image.

Why, are we married, all of a sudden?

I are troll Smile | :)

Localization and Combo Boxes

belzer9-Jan-09 4:42

belzer

9-Jan-09 4:42

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

Re: Localization and Combo Boxes

Colin Angus Mackay9-Jan-09 7:49

Colin Angus Mackay

9-Jan-09 7:49

Set the DisplayMember to the thing you want displayed, Set the ValueMember to the thing you want stored in the database.

You will probably have to store all the translations in the database too and provide a lookup table (with the value you want to store [the English word], the language, the localised value [the French/German/Spanish/etc. word]) and join that lookup table to the query you are currently using with the additional filter of the language you want to display.

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

toolbox of buttons

abu rakan9-Jan-09 3:58

abu rakan

9-Jan-09 3:58

hi is it poosible to make toolbox of buutons
if yes how can i make control for it

Re: toolbox of buttons

User 66589-Jan-09 4:42

User 6658

9-Jan-09 4:42

What about the ToolStrip control[^]? (Assuming you use Winforms)

modified 12-Sep-18 21:01pm.

Crystal reports, Dynamic parameter values not showing up , Static works fine

c0ax_lx9-Jan-09 3:37

c0ax_lx

9-Jan-09 3:37

Hi. i have a problem which i just cannot solve. i have created a crystal report
with dynamic parameters , values are fetched from the database. it works fine when i run the report inside crystal reports 2008.

but when i run the report in my software, visual studio 2005, C# (with crystal reports 2008 offcourse)

i cannot get the list of values. if i add a static list of values it shows up just fine.

so this:
foreach ( ParameterField pf in m_ReportDocument.ParameterFields)
{
MessageBox.Show(pf.DefaultValues.Count.ToString());
}

shows "5" if i add five static values, but "0" if i add dynamic values.
Any suggestions?

m_reportdocument is a crystal report document. the rtp is loaded and datasources are set.

I've tried googling and searching business objects forums. i have seen the question but no replies.

Cheers // Tomas

If it' stuck, DO NOT pull harder!

Help Required in Schedular Class Design

Aman Bhullar9-Jan-09 2:11

Aman Bhullar

9-Jan-09 2:11

I am designing a scheduler, for one module i need a little assistance

My class is as

public class CHandset
    {
        public int HandsetId
        {
            get
            {
                throw new System.NotImplementedException();
            }
            set
            {
            }
        }

        public int LocationId
        {
            get
            {
                throw new System.NotImplementedException();
            }
            set
            {
            }
        }

        public Queue<t> Queue
        {
            get
            {
                throw new System.NotImplementedException();
            }
            set
            {
            }
        }

        public int ObjState
        {
            get
            {
                throw new System.NotImplementedException();
            }
            set
            {
            }
        }

        public int ObjDBLogging
        {
            get
            {
                throw new System.NotImplementedException();
            }
            set
            {
            }
        }

        public int RequeueTime
        {
            get
            {
                throw new System.NotImplementedException();
            }
            set
            {
            }
        }

        public void Execute()
        {
            throw new System.NotImplementedException();
        }
    }
</t>

The above is a class for a handset.
There may be 20 handsets over the entire network. Every handset object will have its queue.
1. Objects of this class will be made on fly
2. Queue will contain the jobs that the handset needs to fire.
3. Every instance of the handset object will fire itself in thread.

I want to know that how can i write a code that can access the Queue of object.

I have thought in mind that if i use MSMQ, will it solve my problem.

Re: Help Required in Schedular Class Design

J4amieC9-Jan-09 2:57

J4amieC

9-Jan-09 2:57

Here's a novel idea, have a crack at your own homework, and when you hit a specific problem then ask a question, including the code you've implemented, and im sure someone will help you out.

Re: Help Required in Schedular Class Design

Luc Pattyn9-Jan-09 3:31