Wednesday, November 27, 2013

Problem with Bitmap

There is a class called System.Drawing.Bitmap Is that what you want?




Paul Linton


SQL Server Compact (UPDATING) records

I don't under stand this. It errors out every time I try and run my program. I get the error of.


There was an error parsing the query. { Token line number = 1,Token line offset = 59,Token in error =>]


and here's my method that I use to update the entry.



public void UpDatedEmail(SqlCeConnection cn, string uName, string uEmail)
{

cn.Open();

SqlCeCommand cm = new SqlCeCommand("UPDATE users SET email = @email WHERE username = @username)", cn);
cm.Parameters.AddWithValue("@username", uName);
cm.Parameters.AddWithValue("@email", uEmail);

try
{
cm.ExecuteNonQuery();

Door.WriteLn("Email Updated successfuly!");
Thread.Sleep(1000);
}
catch (Exception ee)
{
Door.WriteLn("Error : " + ee.Message);
Thread.Sleep(1000);
Door.WriteLn("Press Enter");
Door.ReadKey();
}
cn.Close();
}





Pro-Forums

Delta Force Barracks

On the Frontlines


Problem with Bitmap

have you lookup the api reference/doc?


there's no Bitmap class under that namespace.


looks like you referencing the wrong namespace


or is it suppose to be BitmapImage ?


How to Union while using Function?

I Have List of Company ,i need to union to display all Company as select all how can i achieve this i have code below:

(SELECT CompanyID FROM dbo.HRMEmployeeMaster WHERE dbo.FunctionGetCustomFieldValuebyJobIDFieldNameandDatatype(Job.ID,'EmployeeName','StringValue')
= ((CONVERT(Varchar(MAX),EmployeeId)+'-'+Name))) = @CompanyID




How to Union while using Function?

Can you post your table structure, the code of your UDF, some input data and desired result based on the input?


For every expert, there is an equal and opposite expert. - Becker's Law





My blog




My TechNet articles


How to Union while using Function?

How to Union while using Function?

What are you joining together? Union works in two ways. It unions two select statements based on all rows with "UNION ALL" or it displays all distinct rows with "UNION". So surely it should not matter what you're using to create your select statement? Please post an example of how you're attempting to do this.