|
You really shouldn't build your SQL like that. If I were you, I would consider using parameterized queries so that you can avoid SQL Injection attacks.
|
|
|
|
|
Private Sub cmdUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpdate.Click
Dim strconnection As String = "Data Source=ELIANE-VAIO\SQLEXPRESS;Initial Catalog=DatabaseConnection;Integrated Security=True;"
Dim _cn As SqlConnection = New SqlConnection(strconnection)
Dim cmd As New SqlCommand
_cn.Open()
cmd.CommandText = "update tblcustomer set ([ID],[Name],[Email], [Address], [DeptID]) VALUES (<a href="/Members/id">@ID</a>, <a href="/Members/Name">@Name</a>, <a href="/Members/email">@Email</a>, <a href="/Members/address">@Address</a>, @DeptID)"
cmd.Connection = _cn
cmd.Parameters.AddWithValue("<a href="/Members/id">@ID</a>", Me.txtID.Text)
cmd.Parameters.AddWithValue("<a href="/Members/Name">@Name</a>", Me.txtName.Text)
cmd.Parameters.AddWithValue("<a href="/Members/email">@Email</a>", Me.txtEmail.Text)
cmd.Parameters.AddWithValue("<a href="/Members/address">@Address</a>", Me.txtAddress.Text)
cmd.Parameters.AddWithValue("@DeptID", Me.cbDept.SelectedValue)
txtserial.Text = cmd.ExecuteScalar()
End Sub
I wrote this one now. But it's giving me error on the executescalar. syntax error near )
Am i missing something?
And if i commented this line of code:
txtserial.Text = cmd.ExecuteScalar()
when i edit the textboxes , everything looks normal. i go next-previous-move last-move first. everything is fine. but not the database.
the edited record stays as it was before editing.
Any idea why?
Thank you 
|
|
|
|
|
You shouldn't be executing a scalar - that's expecting a value back. Use ExecuteNonQuery instead.
|
|
|
|
|
I tried.
Incorrect syntax near )
but i need the executescalar because i need the first columns value to be in txtserial
|
|
|
|
|
The problem that you have here is that you are performing an update. If you execute the command that you have there, you will update EVERY record because you have no where clause. What are you trying to do here?
|
|
|
|
|
You're mixing the syntax for the INSERT[^] and UPDATE[^] statements.
If you want to insert a new record, the query should be:
INSERT INTO tblcustomer
(
[ID],
[Name],
[Email],
[Address],
[DeptID]
)
VALUES
(
@ID,
@Name,
@Email,
@Address,
@DeptID
)
If you want to update an existing record, the query should be:
UPDATE
tblcustomer
SET
ID = @ID,
Name = @Name,
Email = @Email,
Address = @Address,
DeptID = @DeptID
WHERE
Serial = @Serial
(You would also need to add the @Serial parameter to the command.)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yes you are right Richard Deeming.
It worked. the databse is updating . and that's the important thing.
Thanks a lot guys.
But once i put this line of code:
txtserial.Text = cmd.ExecuteScalar.ToString()
an eror pops up:
Object reference not set to an instance of an object.
And i need the first columns value to be in the txtserial texbox.
Any advice?
|
|
|
|
|
You're getting a NullReferenceException because you aren't returning anything. You're either passing in the serial number for an update statement (in which case you don't need to get it out), or you should be trying to SELECT SCOPE_IDENTITY after doing your insert to get the value of the record you inserted.
|
|
|
|
|
Pete O'Hanlon wrote: SELECT IDENTITY_SCOPE()
Or SCOPE_IDENTITY() as it's known! 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
That's only in those ol' versions of SQL Server. I'm running SQL Server 2432.
|
|
|
|
|
|
You will also get problems with this syntax if one of the text values includes an apostrophe, e.g. a name like "O'Connor" or "D'artagnan"
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Chris Quinn
No. I just tried it. It's working
|
|
|
|
|
Hello,
I'm using VS2010 with .Net 4.0 for a solution with numbers of ClassLibrary projects. One projet needs 4.5 functionnality so I've compiled it in VS2012 targetting .Net 4.5.
In my VS2010 solution, I can add references to the MyLibrary4.5.dll, but I can't use it (namespace unknown)
Can't we do that ?
|
|
|
|
|
Not in VS2010, no. That version of Visual Studio was released with .NET 4.
|
|
|
|
|
No. You cannot add a new dll to an older version of the framework.
|
|
|
|
|
I am using Google Auth api Calendar in .net. i am facing the same error in every Google apis code. And i donot know know ho to remove it. please HELP
My Error is: "Could not load type 'Google.Apis.Requests.IErrorResponseHandler' from assembly 'Google.Apis, Version=1.6.0.16897, Culture=neutral, PublicKeyToken=null'"
public ActionResult EmailSettings(string jsonData, string tokenAuthenticate, string clientID, string APIkey, string ClientSecret)
{
HttpContext.Application["EmailAdmin"] = jsonData;
HttpContext.Application["EmailAccessOken"] = tokenAuthenticate;
this.clientID = clientID;
this.APIkey = APIkey;
this.ClientSecret = ClientSecret;
CreateService(tokenAuthenticate);
return View();
}
private CalendarService CreateService(string token)
{
var provider = new NativeApplicationClient(GoogleAuthenticationServer.Description, this.clientID, this.ClientSecret);
var auth = new Google.Apis.Authentication.OAuth2.OAuth2Authenticator<NativeApplicationClient>(provider, (p) => GetAuthorization(provider, token));
CalendarService service = new CalendarService(new BaseClientService.Initializer()
{
Authenticator = auth,
ApiKey = ConfigurationManager.AppSettings[this.APIkey].ToString(),
GZipEnabled = false
});
return service;
}
private static IAuthorizationState GetAuthorization(NativeApplicationClient arg, String Refreshtoken)
{
IAuthorizationState state = new AuthorizationState(new[] { CalendarService.Scopes.Calendar.GetStringValue() });
state.Callback = new Uri(NativeApplicationClient.OutOfBandCallbackUrl);
state.RefreshToken = Refreshtoken;
return state;
}
modified 12-Dec-13 10:44am.
|
|
|
|
|
Please don't attempt to take people from this site to StackOverflow. That's not a very courteous thing to do.
|
|
|
|
|
Agree with Pete. If you want answer, mention all details clearly in your question. Besides some websites blocked on some workplaces(very rare thing). So update your question with complete details clearly.
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
|
Member 10457223 wrote: What should i put here: //PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt//
what path??
 Your report Path(Where you have report files). For example, if you have your report files in some folder on D Drive, then code should be like below.
cryRpt.Load(@"D:\Somefolder\CrystalReport1.rpt")
But don't use hard code path, use Relative path. C# get project path[^]
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
I need to simulate keyboard and mouse actions in a simple C# Visual Studio Windows Application. Some years back, it was relatively simple to do this, as I recall. (Microsoft once even had a whole programming environment called MSTest built around this functionality.) Now, the only way that I see to do it within Visual Studio is with a Hyper-V WMI class. I do not see what library those classes are in, and I wonder if there is a simpler way anyway.
W. Johnson
|
|
|
|
|
What you are looking for is something called Automation Peers. You can find some information on this technology here[^], and using it in WPF here[^].
|
|
|
|
|
I wrote a C++ mixed-mode (native and CLI) DLL. Call this assembly C1. It has a project reference to another assembly called R1.
Then, I wrote another mixed-mode DLL called assembly C2. It also has a project reference to R1.
These mixed-mode DLL's are loaded by a native Windows application. The assemblies are unsigned.
Current versions of the mixed-mode DLL's work with the original version of the native application if all assemblies are updated. However, I have a requirement to be able to update C1 without updating C2. Unfortunately, C1 and C2 both share R1 as a common dependency, and different versions of R1 are incompatible. This defines the root problem.
In an effort to resolve this, I updated C1 to create a new application domain whose private path (for probing) is a sub-directory of the application directory. The new R1 is located in the sub-directory. The new C1 is located in the application directory. The old C2 and R1 are also located in the application directory. The new versions of C1 and R1 are signed. Denote the old assemblies as C1A, C2A, and R1A. Denote the new assemblies as C1B and R1B. I am logging assembly loads in a handler to the separate app domain's AssemblyLoad event.
When the application runs, I see that C1B is loaded. Then, R1B is loaded into the separate app domain. Unexpectedly, R1A is loaded into the separate app domain. When a type from R1 is instantiated, the runtime is using R1A instead of R1B. Due to the aforementioned incompatibility of R1 versions, all sorts of exceptions ensue.
I then ran ildasm.exe against R1A. Next, I ran ilasm.exe against the resultant .IL file, specifying the key I used when building R1B. This generated a signed version of R1A. Denote the unsigned R1A as R1A1 and the signed version as R1A2. Finally, I copied R1A2 into the application directory. Now, the runtime skips R1A2 and only loads R1B in the separate application domain.
To me, the behavior of R1A1 violates the entire purpose of generating strongly named assemblies. What am I missing?
|
|
|
|
|
I've created two windows 8 applications. One of them was a very useful app. Lot of users gave me good feedback. And they wish i could improve it. Some site web has choosen this app as a very suggested app.
But because of my work, almost one year i didn't touch it. Now, i want to send my app to someone else who can take care of it.
Here is the link of my app http:
Another here is: http:
I don't care of money earning in the future from your part. But i really want my idea could help more peoples.
If someone has interested in it, please contact me with my gmail: comiscience@gmail.com I'm Bo. Please write me the mail with English, French or Chinese please.
And i also want to know where can i find you who want to continue my idea
Thanks
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
