DaveRook
Last Activity: Nov 29 '11, 09:52 AM
Joined: Jul 12 '07
Location:
-
the input type button doesnt have to display as a button though? You can easily use some CSS to make it appear as normal text. would that work? -
Sorry, I Don't think soLeave a comment:
-
You may have to use the LEFT function as well to skip the REQ word to bring back numbers only
DaveLeave a comment:
-
Hi
It looks like you're after the latest ticket. Can you not order by and select top 1?
DaveLeave a comment:
-
Why don't you use the lower case function LCASE() to both strings?Leave a comment:
-
Using Reg Ex
Hi
I've done this is MsSql, but this won't work in Oracle.
In MsSql, a simple
WHERE ColumnName LIKE '[L][1-9]%'
will return L1, L2, L3, L4 etc
How do I do this with Oracle
Thank you
Dave -
Let's not complicate things :)
Actually, thankfully, I work in a small company - so I can ensure that it's PC only and only for W7, Vista and XP
Thanks allLeave a comment:
-
Ha ha, I didn't realise it was under specialfolders. I had used this method for a different project and didn't think about it! D'oh.
Thank you, that has answered itLeave a comment:
-
local paths of users computer (XP vs W7)
Hi
My WPF (C#) application creates a new folder in the users documents folder.
There are many differences in folder structures between XP and W7. This is from the MSDN website
XP/Server 2003
ApplicationData : C:\Documents and Settings\<user name>\Applicati on Data
CommonApplicati onData: C:\Documents and Settings\All Users\Applicati on Data
CommonProgramFi les: C:\Program Files\Common Files... -
I did that originally, same error. I only added the Convert.ToStrin g due to the cannot convert type char to string error message.
Any other ideas?Leave a comment:
-
C# - split method - cannot convert char to string
Hi
I've had a few error messages with this I don't understand why. It works fine in a Windows Form, but now moving it to a website, it's not working. I don't have the option to count the lines as I did with Windows Forms so I assume the best way is to use the split method. However, the split method only returns Character Arrays, and I want a string, so am calling the split from the Text.RegularExp ression namespace.
I am... -
This is insane. It's now working. I think there must be a bug on my system, I have literally been doing this (on and off) over the past 12 hours.
The code works perfectly. I changed the routine from protected to public, ran it and it worked. I then changed it back to protected, and it still works...
Sorry if any one spent any time on this, it is clearly a bug with my setup/installation etc.
Thanks
...Leave a comment:
-
How to reference usercontrol from a loop
I have a usercontrol which is just 1 drop down list. It is registered on an aspx page, but I can't get the SelectedValue, SelectedIndex, Text propery.
My code
...Code:protected void getValue() { string s = string.Empty; foreach (Control cont in pnlTemplateMatch.Controls) { if (cont is UserControl) { DropDownList ddl = new -
Hi
Had another look.
It appears when you build a recordset or dataadapter, the where clause ignores what columns appear in your select command and looks at the columns available on the actual view on SQL.
I've managed to replicate this now with my C# code and it is fine.
Thank youLeave a comment:
-
Hello
His code works perectly.
The view and my view are pretty much the same (different data) but the actual set up is identical.Leave a comment:
-
SQL query with datareader or dataadapter
Hello
One of my colleagues has done this in vbscript. His code within the recordset is
How can he be calling the column ProfileHeight when it is not declared?Code:"SELECT DISTINCT (ProductNumber), NoOfContacts, Height, Style, Type FROM view WHERE ProfileHeight between 3.0 and 3.9"
I am trying to do this in C#, and I can't - if it goes to the dataapater it fails because it wants the... -
Hi Frinny
Thank you (again) for your help. As disapointing as it is to have to continue this way as sometimes the logic is more complicated than simple if else statements, it is quite re-assuring to know this is a 'normal' programming dilema and there is not a simple solution. At least I'm on the right path and using the language effectively!
I am using T-SQL and C# so I guess it's case statements for me!!
Thank...Leave a comment:
-
How to apply conditions to databound objects
I use a repeater on my website.
My code for this example is
Now, depending on the result of the dataitem will depend on what I want to display. For example, The databitem may show a true or false value, and depending on which one I want to show a different result on my page....Code:<ItemTemplate> Item: <%#DataBinder.Eval(Container.DataItem, "Col")%><br> </ItemTemplate>
-
DaveRook replied to Login failed for user. The user is not associated with a trusted SQL Server connectioin .NETFixed.
Data Source=10.10.10 .10,1433;Networ k Library=DBMSSOC N;User ID=abc; Password=xxx; Initial Catalog = " + cbDBNo.Text + ";"
Is this safe (secure)? Surely I'm sending out the password over un-encrypted networks. Or is this just the way it is?Leave a comment:
-
DaveRook started a topic Login failed for user. The user is not associated with a trusted SQL Server connectioin .NETLogin failed for user. The user is not associated with a trusted SQL Server connectio
I have written a windows form which connects to SQL. It works! I'm now trying to running it 'remotely' from another country. It fails!!
When I connect from the remote location, I get the SQL error : "Login failed for user. The user is not associated with a trusted SQL Server connection. "
I have logged onto the server, right click on the name, properties, security and it shows mixed mode.
My connection...
No activity results to display
Leave a comment: