|
Hello,
I want to create a table, grant previlegs, create a stored procedure and finally use this stored procedure.
And I want to use all of them with 'exec'.
A good explication to use exec within an sqlstament ist here,
https://stackoverflow.com/questions/3523989/how-to-use-sqlcommand-to-create-database-with-parameterized-db-name
But no matter what I'm doing I cant run finally the stored-procedure.
It says allways, it couldnt find the store procedure.
Or, if I try it without exec, than it says it has to much arguments.
It works only if I use all the other staments without exec.
This is how it looks, for grant and create stp as well
public void CreateTable(string strtblName)
{
strSQL = "EXEC ('CREATE TABLE ' + @tblName + ([EmployeeID] [int] NOT NULL PRIMARY KEY CLUSTERED," +
"[VorName] [nvarchar](50) NULL, [NachName] [nvarchar](50) NULL," +
" [Titel] [nvarchar](30) NULL," + " [City] [nvarchar](50) NULL," +
" [BirthDate] [date] NULL) ON [PRIMARY]')";
try
{
myCnn.Open();
myCmd.Connection = myCnn;
myCmd.CommandType = CommandType.Text;
myCmd.CommandText = strSQL;
myCmd.Parameters.Clear();
myCmd.Parameters.Add("@tblName", SqlDbType.Text);
myCmd.Parameters["@tblName"].Value = strtblName;
myCmd.ExecuteNonQuery();
myCnn.Close();
}
catch (Exception ex)
{
myCnn.Close();
throw new Exception(ex.Message);
}
}
|
|
|
|
|
pschulz wrote:
strSQL = EXEC ('CREATE TABLE ' + @tblName ([EmployeeID] [int] NOT NULL PRIMARY KEY CLUSTERED," +
"[VorName] [nvarchar](50) NULL, [NachName] [nvarchar](50) NULL," +
" [Titel] [nvarchar](30) NULL, [City] [nvarchar](50) NULL," +
" [BirthDate] [date] NULL) ON [PRIMARY]')"; The problem with the table creation is that you try to use parameters, don't use them.
Instead try the following:
strSQL = @"CREATE TABLE " + strtblName + @" (
[EmployeeID] [int] NOT NULL PRIMARY KEY CLUSTERED,
[VorName] [nvarchar](50) NULL,
[NachName] [nvarchar](50) NULL,
[Titel] [nvarchar](30) NULL,
[City] [nvarchar](50) NULL,
[BirthDate] [date] NULL) ON [PRIMARY])";
pschulz wrote: This is how it looks, for grant and create stp as well
You need to post relevant code parts. If the problem is with the stored procedure, edit the post and paste the code for creating and using the procedure.
Also if you get any error messages, please include those in original format.
modified 26-Aug-15 0:46am.
|
|
|
|
|
Mika Wendelius wrote: The problem with the table creation is that you try to use parameters, don't use them.
You might want to clarify that your advice only applies to this specific situation. 99.999% of SQL code should use parameters.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Good point
|
|
|
|
|
pschulz wrote:
strSQL = "EXEC ('CREATE TABLE ' + @tblName + ([EmployeeID] [int] NOT NULL PRIMARY KEY CLUSTERED," +
"[VorName] [nvarchar](50) NULL, [NachName] [nvarchar](50) NULL," +
" [Titel] [nvarchar](30) NULL," + " [City] [nvarchar](50) NULL," +
" [BirthDate] [date] NULL) ON [PRIMARY]')";
You're missing a single quote after the table name:
strSQL = "EXEC ('CREATE TABLE ' + @tblName + '([EmployeeID] [int] NOT NULL PRIMARY KEY CLUSTERED," +
"[VorName] [nvarchar](50) NULL, [NachName] [nvarchar](50) NULL," +
" [Titel] [nvarchar](30) NULL," + " [City] [nvarchar](50) NULL," +
" [BirthDate] [date] NULL) ON [PRIMARY]')";
I'd also suggest using the QUOTENAME function[^] around the @tblName parameter, if you haven't already done so:
strSQL = "EXEC ('CREATE TABLE ' + QUOTENAME(@tblName) + '...
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have something like a solution, but ist not the answer.
take this two ado objects
SqlConnection
SqlCommand
make them ready
create the database (exec within the statement)
create the table (exec within the statement)
grant previligs for the table (exec within the statement)
create a stp (exec within the statement)
Now, to fill the table with datas, using the stp,but keep exec out of the statment
|
|
|
|
|
It seems to me pretty simple.
The MsSQlserver is made to reject a call like that, with intention.
There is no reason to call a existing stp with a constructet name, from a application(maybe just about the risc to cause errors.)
And finally, there is no way to call a stp with the keyword ‘EXEC’, with or without paramters within the stp name.
That’s probably the answer. I write here probably cause, people who with deeper knowledge of the sever construction, may have a better or finally other explication.
|
|
|
|
|
Similar sharpdevelop or Visual Studio effects, the use of certain namespace A Window designer in his own program, how to do, or hope to provide demo source code, or design ideas, relevant examples, especially thank you ~!
|
|
|
|
|
Download the SharpDevelop source and study it.
|
|
|
|
|
Questions
1> when use ApiController Then not use TempData,Session,ViewBag,ViewData.
2> when Use ApiController Then How To Strongly Connected To the view.
3> Is Possible To ApiController ActionMethod Return Json,Xml And View Per Request
4> I have Already Connection To DataBase then Why Use Get/Set Method And convert Data
From json and Display It in our view using client side language like Jquery,Angular JS
5> ApiController ActionMethods Not Return View Then How To Routing Our View in View Folder beacuse First Action Get Controller And Controller Return Vew But Api Controller Not Return View.
|
|
|
|
|
You seem to have some serious misconceptions about what an ApiController is compared to a normal Controller.
ApiControllers handle data only. They return data only. There is no View in a ApiController.
1) Yeah, since there is no View when using an ApiController, there is no TempData, no ViewBag and no ViewData.
2) ApiControllers don't return views, they return data.
3) A method can only return ONE type of object. What that is depends on your requirements. If you want to return data in different formats you'll have to write different methods to call to support each format type.
4) Your question doesn't make sense.
5) Again, ApiControllers have nothing to do with Views, so this question is moot.
|
|
|
|
|
Hi,
I've created the functionality I want, with a lot of controls on a form and now would like to use this whole construct in another form on a tab. I think I have heard that "form in form" doesn't work. Also UserControls can be made but are only available in the same project as far as I found out.
So how can I transfer my form without re-doing everything into another project in another form ?
Thanks very much in advance,
mat
|
|
|
|
|
"Form in a form" can be done - but it's a bit of a cludge.
UserControls are just that Controls - and can be used in any code which References the assembly, you are not restricted to within the same project, unless you declare them as Internal. As long as they are public, it's not a problem. I do it all the time.
Personally, I'd use a UserControl, and embed it in your Forms instead of messing with form in form. It's a lot cleaner from a design POV.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
ok, thank you. then I'll reference the assembly, what I tried was adding the UserControl to the toolbox but I didn't manage to add it permanently, it was only available in the same project then.
|
|
|
|
|
Yes! Controls (and all other classes) are only available if they are referenced in the project (or part of the project) - if they aren't referenced, the system doesn't know where to look for them when your application runs, so you can't use them in your design!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I thought there maybe was some "smart" and new mechanism to export some new controls and add them to the toolbox in VS - not impossible I'd say. It should then store and reference it by itself.
|
|
|
|
|
The problem with that is: what happens if two different solutions (or even projects) declare user controls with the same name? Which does it add to the toolbox?
What if the "Other Solution" control is nothing to do with your project and references classes which are not in your assembly or it's assembly, but one it references?
That gets nasty, pretty quickly!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
What if you've got 1,000 solutions and projects running around? How long would it take Visual Studio to scan all of those for updated controls?
No, not impossible, but completely impractical.
|
|
|
|
|
I can check this though signtool.exe and it results in the text output though below command.
signtool.exe verify /v /pa "C:\test\ftdiport.cat"
And this result the output in verbose mode in command prompt or we can redirect it to a text file as below.
Verifying: C:\test\ftdiport.cat<br />
<br />
Signing Certificate Chain:<br />
Issued to: Class 3 Public Primary Certification Authority<br />
<br />
Issued by: Class 3 Public Primary Certification Authority<br />
<br />
Expires: 8/2/2028 5:29:59 AM<br />
<br />
SHA1 hash: 742C3192E607E424EB4549542BE1BBC53E6174E2<br />
<br />
<br />
Issued to: VeriSign Class 3 Code Signing 2004 CA<br />
<br />
Issued by: Class 3 Public Primary Certification Authority<br />
<br />
Expires: 7/16/2014 5:29:59 AM<br />
<br />
SHA1 hash: 197A4AEBDB25F0170079BB8C73CB2D655E0018A4<br />
<br />
<br />
Issued to: Future Technology Devices International Ltd<br />
<br />
Issued by: VeriSign Class 3 Code Signing 2004 CA<br />
<br />
Expires: 9/30/2010 5:29:59 AM<br />
<br />
SHA1 hash: 029E8FF6146EE9AEDA68092AB030057165B73A20<br />
<br />
<br />
The signature is timestamped: 3/31/2010 6:10:55 PM<br />
<br />
Timestamp Verified by:<br />
Issued to: Thawte Timestamping CA<br />
<br />
Issued by: Thawte Timestamping CA<br />
<br />
Expires: 1/1/2021 5:29:59 AM<br />
<br />
SHA1 hash: BE36A4562FB2EE05DBB3D32323ADF445084ED656<br />
<br />
<br />
Issued to: VeriSign Time Stamping Services CA<br />
<br />
Issued by: Thawte Timestamping CA<br />
<br />
Expires: 12/4/2013 5:29:59 AM<br />
<br />
SHA1 hash: F46AC0C6EFBB8C6A14F55F09E2D37DF4C0DE012D<br />
<br />
<br />
Issued to: VeriSign Time Stamping Services Signer - G2<br />
<br />
Issued by: VeriSign Time Stamping Services CA<br />
<br />
Expires: 6/15/2012 5:29:59 AM<br />
<br />
SHA1 hash: ADA8AAA643FF7DC38DD40FA4C97AD559FF4846DE<br />
<br />
<br />
Successfully verified: C:\Users\ur00361883\Desktop\ftdiport.cat<br />
<br />
<br />
Number of files successfully Verified: 1<br />
<br />
Number of warnings: 0<br />
<br />
Number of errors: 0
One option is to parse this file and I need to get below details.
Catalog file is Signed/Unsigned and Certificate issued for it and its expiry date.
Is there any option like some libraries instead of parsing this text file whether in c#,vbscript,autoit or powershell or any platform.
If no option, please guide me on how to parse this output.
|
|
|
|
|
|
can anyone help me to let me know how to design a teamviewer like appication
|
|
|
|
|
I'd recommend using RDP (Remote Desktop Protocol); it will be understood by other applications, and since it is a common protocol there might already be a .NET library for it.
TeamViewer is a "bit" more complicated; Joel[^] has an interesting article on exactly that topic.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have created a setup project for a windows forms application with VS Community 2015. I have set the prerequisites (.NET Framework 4.0 with Windows Installer 4.5) and I have downloaded all required files but when I try to run the install file on Windows XP, I receive this message:
This installation package is not supported by this processor type. Contact the package vendor.
I understand that the error is because the system is running on x86 and it doesn't find the windows installer files for x86 and I can't figure it out why. Files that are included in Windows Installer 4.5 are these:
Windows6.0-KB958655-v2-x64.msu
Windows6.0-KB958655-v2-x86.msu
WindowsServer2003.WindowsXP-KB958655-v2-x64-ENU.exe
WindowsServer2003-KB942288-v4-x64.exe
WindowsServer2003-KB942288-v4-x86.exe
WindowsServer2003-KB958655-v2-x86-ENU.exe
WindowsXP-KB942288-v3-x86.exe
WindowsXP-KB958655-v2-x86-ENU.exe
Can anybody tell me if the files are wrong and what files should I include instead of these?
modified 24-Aug-15 3:49am.
|
|
|
|
|
What is the value of the Template Summary field on the General tab of your installer?
|
|
|
|
|
.NET 4.5 doesn't run on Windows XP. I am sure we told you this already.
|
|
|
|