|
Did you add a reference to System.ServiceModel?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
I am trying to return Count(*), cast to a String and assign the value to Label1.Text. I am a bit stuck on the C# syntax because I am new to C#. This is what my research has produced thus far:
protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(ConnString))
{
//String newTagName = txtParm.Text;
int DOWcount = 0;
SqlCommand cmd = new SqlCommand("SELECT count(*)FROM RealTime WHERE DATEPART (d,CallStartTime) = DATEPART(d,getdate())", conn);
cmd.Parameters.Count;
conn.Open();
DOWcount = cmd.ExecuteNonQuery();
Label1.Text = DOWCount.ToString();
I know that I am not using the "cmd" correctly. Can anyone of the experts out there steer me in the right direction?
|
|
|
|
|
mreynol5 wrote: Can anyone of the experts out there steer me in the right direction?
No. No one knows how to do that. And if anyone did it certainly would not be Microsoft and they certainly would not document it.[^]
And you certainly would not be able to find the documentation using Google[^]
mreynol5 wrote: I am a bit stuck on the C# syntax because I am new to C#.
Ok, good luck
led mike
|
|
|
|
|
Change this:
DOWcount = cmd.ExecuteNonQuery();
to this:
DOWcount = (int)cmd.ExecuteScalar();
Hope that helps 
|
|
|
|
|
Hi,
In part of my undo/redo system (for property value changing on certain component types which must be recreated) it would be very useful to create a copy instance. Now I have achieved this using the designated 'CreateInstance' method as provided by the type converter. My problem is understanding exactly how to get the propertyValues 'IDictionary' type object.
I have created the following method which works, but I wanted to know if anybody has any suggestions to improve this or perhaps if there is an easier way. I am worried that this approach may cause issues, would property descriptor attributes need to influence this process in some way?
protected object CreateInstanceCopy(PropertyDescriptor descriptor, object component)
{
PropertyDescriptorCollection propertyValues = descriptor.Converter.GetProperties(component);
Dictionary<propertydescriptor, object=""> values = new Dictionary<propertydescriptor, object="">();
foreach (PropertyDescriptor desc in propertyValues)
values.Add(desc, desc.GetValue(component));
...
return descriptor.Converter.CreateInstance(values);
}</propertydescriptor,></propertydescriptor,>Thanks,
Lea Hayes
|
|
|
|
|
hi...
i'm using crystal reports with C#. I'm using an ODBC connection for the report.
when trying to open the report from test machine it gives this window.
.........................................
Databse login .
.........................................
server name: .
DataBase: .
LoginID: .
password: .
.
integrated security (checkbox) .
.........................................
how can a reomve this window
|
|
|
|
|
shabonaa wrote: how can a reomve this window
Click the red 'X' in the upper right corner
led mike
|
|
|
|
|
Hey Shabonaa,
What you need to do is programatically set that in the page load or report load event using code behinds.
The only way I found to easily remove the window is to load the crytsal report in the code behind page and NOT in the .aspx
Does this make sense?
You should google "crystal reports c# programmatically" and sift around for something close to what you are doing.
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
i'm using a windows application. not asp
|
|
|
|
|
hmmm. should still be doing it programmatically then.
you should still be loading up the report and passing logon credentials through the C# code. if not in a code behind, then in a class file. but you will have to do it that way.
You should google "crystal reports c# programmatically" and sift around for something close to what you are doing.
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
modified on Tuesday, May 20, 2008 6:16 PM
|
|
|
|
|
You have to provide the login information (programmatically), even though you have done that in the Crystal Report designer.
|
|
|
|
|
hi again
i got a tableLayoutPanel in my form that contains Checkbox in each cell. now i want now the Cell(Row,Column) if user checked one box.
i know that tableLayoutPanel add a Cell property to it's chid and i can see that in Properties Window but the problem is i can't use this in code.
thanks for help
|
|
|
|
|
I have five ToolStrip within a ToolStripContainer.
when I on/off visibility of these toolbar from, These toolstrip seems appear in random order.
ToolStrip grips are enabled.
How can fix the order of appearance of these toolstrips within toolstripcontainer. Some Toolstrip should apprear in the same row and some toolstrip should appear before of after any other Toolstrip when in the same row.
Any idea will be appreciated.
Thank you.
|
|
|
|
|
Might sound like a silly question, but jeez it's really not obvious to make those toolstrips behave.
I'm really really interested in the solution too !
|
|
|
|
|
Hi,
I am working on an application that is able to read data from a keyboard wedged barcode scanner.
I want the barcode that is scanned to be displayed in a picture box in my form.
I use the code discribed in http://www.codeproject.com/KB/macros/BarcodeLibrary.aspx
to draw the barcode. Therefore I need 2 things :
1) the data to be encoded.
2) the type of the encoding (Code39, Code128, UPC A, UPC E, EAN13 etc..)
Since most barcode scanners are able to read several barcode types, is it possible to determine the type of the encoding the barcode reader uses to generate the data from a barcode image?
TIA
|
|
|
|
|
|
1. I created my own DLL in C++ (MyMathDll.dll), wrote a client program in c#. The program works on x86 system (32bit) but when i run it on x64 (64bit vista), I get the error, BadImageFormatException. It is simple function which adds two numbers as follows
int _cdecl Add(int x, int y)
{
return (x+y);
}
2. I have another problem with x86 windows. It is not able to load or even locate a particular dll. The dll was made with nmake utility? Could there be something wrong with the DLL. It locates other dlls fine. I verified this DLL in dumpbin and it looks good. Why it is not loadig?
|
|
|
|
|
I am making a project which contain several forms.
I want to access member id which r used in login, I want to use member id through mdi form on every form of project.
Please suggest me code if possible
Signature preview salil_k_singh
|
|
|
|
|
|
|
Hi there,
I'm having trouble understanding the usage of the merge function from DataSet objects.
Well, first I thought that it would only Add and Update existing rows from the target DataSet based on the new rows and modified rows in the source DataSet.
But for some reason my Merge function is actually deleting rows from the target wich are not in the source DataSet (this is EXACTLY what I want, I want it to DELETE rows too!)
My problem is that for some reason it is not deleting other rows, it just deletes a specific level.
Let me detail the context:
My dataset is composed by 3 levels (Clients -> Accounts -> Products).
When I merge DataSet1 with DataSet2 ( DataSet1.Merge(DataSet2, false) ) I want it to:
Add/Update Clients, Accounts and Products in DataSet1
AND
Delete Clients,Accounts and Products wich are not in DataSet2.
This DO happen in Products level, but NOT in Clients and Accounts level.
Any ideas on how to solve this problem?
For more information, please do ask.
Thanks
Oscar
|
|
|
|
|
Maybe you have to make some changes on my code, but i wrote a merge myself.
static class DataSetMerging
{
public static bool ExtendedMerge(System.Data.DataSet Current, System.Data.DataSet Incoming, bool DeleteAbscent)
{
bool result = false;
if(Incoming != null)
{
foreach(System.Data.DataTable Table in Current.Tables)
{
System.Data.DataTable IncomingTable = Incoming.Tables[Table.TableName];
if(IncomingTable != null && Table.Columns.Count == IncomingTable.Columns.Count && Table.PrimaryKey.Length != 0)
{
int ctr = Table.Rows.Count-1;
while(ctr>-1)
{
System.Data.DataRow Row = Table.Rows[ctr];
object[] KeyValues = new object[Table.PrimaryKey.Length];
System.Data.DataColumn[] PrimaryKeys = new System.Data.DataColumn[Table.PrimaryKey.Length];
int ctr2 = 0;
while(ctr2<Table.PrimaryKey.Length)
{
KeyValues[ctr2] = Row[Table.PrimaryKey[ctr2]];
PrimaryKeys[ctr2] = IncomingTable.Columns[Table.PrimaryKey[ctr2].ColumnName];
ctr2++;
}
IncomingTable.PrimaryKey = PrimaryKeys;
System.Data.DataRow IncomingRow = IncomingTable.Rows.Find(KeyValues);
if(DeleteAbscent && IncomingRow == null)
{
Table.Rows.Remove(Row);
}
else if(IncomingRow != null)
{
bool UpdateRow = false;
int ctr3= 0;
while(ctr3<Table.Columns.Count)
{
if(Row[Table.Columns[ctr3].ColumnName].ToString() != IncomingRow[Table.Columns[ctr3].ColumnName].ToString())
{
UpdateRow = true;
Row[Table.Columns[ctr3].ColumnName] = IncomingRow[Table.Columns[ctr3].ColumnName];
}
ctr3++;
}
if(UpdateRow)
{
Row.AcceptChanges();
}
IncomingTable.Rows.Remove(IncomingRow);
}
ctr--;
}
if(IncomingTable.Rows.Count > 0)
Table.Merge(IncomingTable);
}
}
}
else
{
result = true;
}
return result;
}
}
Greetz
Kurt C.
|
|
|
|
|
Thanks a lot for your help Kurt!
Your code was successfully adapted to my application just by adding a check before updating rows
if (!dtbTabela.Columns[iContador3].ReadOnly)
{
UpdateRow = true;
Row[Table.Columns[ctr3].ColumnName] = IncomingRow[Table.Columns[ctr3].ColumnName];
}
I needed to do that because we have ReadOnly columns that are calculated based on the childs, this way by changing the childs it will automatically modify the parent.
What's pitty is that merging the datasets didn't improve the performance as we thought it would... but hey, sh*t happends.
I learned a lot from your code.
Thanks again!
Oscar
|
|
|
|
|
Feel up for a challenge?
This isn't homework (Don't worry :p)
Was doing some coding optimisations, when I thought up the following challenge:
Code:
static void Main(string[] args)
{
Stopwatch sw1 = new Stopwatch();
sw1.Start();
string shortString = "1234567890";
string largeString = "";
for (int j = 0; j < 50000; j++)
{
largeString += shortString;
}
if (largeString.Length == 500000)
{
Console.WriteLine("Pass 1");
}
else
{
Console.WriteLine("Fail 1");
}
if (sw1.ElapsedMilliseconds < 10000)
{
Console.WriteLine("Pass 2");
}
else
{
Console.WriteLine("Fail 2 - " + sw1.ElapsedMilliseconds);
}
Console.ReadLine();
}
Challenge:
Change ANY 2 lines of code ABOVE the
code line to display ONLY the following output
Pass 1
Pass 2
As it stands, this code snippet displays (On my PC):
Pass 1
Fail 2 - 38614
Hint: The speed of your computer (Should Be) Irrelevant...
Optimised, it took 211ms on my PC (Which is ALOT less than 10000)
Good Luck
-= Reelix =-
|
|
|
|
|
Any two lines above "// Touch Nothing Below Here"?
Easy ... only need to change one :P Move "sw1.Start();" to below the for loop 
EDIT: And oh btw, your not calling stop on the stopwatch?
modified on Tuesday, May 20, 2008 11:44 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
