|
Hi,
thanks for your suggestion. I will try it.
|
|
|
|
|
|
Hello,
How to create stored procedure dynamically in c#.net. Because
some of my requirements needs such a situation. Please help with some example code.
Thanks and Regards
|
|
|
|
|
Just execute the statements as you did for normal query. But why you need to create a SP run time? That doesn't make any sense.
|
|
|
|
|
Hi Navaneeth,
Because of requirement, I need to create tables and stored procedures at runtime. This is created at runtime because it is managed on clients system or database server during installation of application.
Thanks for reply.
|
|
|
|
|
Well, Try the following code
string query = @"CREATE PROCEDURE SampleProcedure
AS
BEGIN
SELECT 'From Sample Procedure'
END";
using (SqlConnection connection = new SqlConnection(@"YourConnectionString"))
using (SqlCommand command = new SqlCommand(query,connection))
{
connection.Open();
command.ExecuteNonQuery();
}If you have many SQL statements to be executed, I'd put it in a file and read from there to execute.
|
|
|
|
|
Could you please explain? What is the problem in this create procedure QueryString.
"CREATE PROCEDURE test.dbo.Operator @MasterField varchar(300) AS SELECT SubOperatorField FROM SubOperatorInfo WHERE MasterField=@MasterField AND departField IS NOT NULL AND SubOperatorField=somevalue";
this querystring fires an exception i.e.:-
'CREATE PROCEDURE' does not allow specifying the database name as a prefix to the object name. Must declare the variable '@MasterField'.
|
|
|
|
|
try taking the database name out of the name of the procedure
You should be already in the context of the database, e.g the SqlConnection is already connected to "test".
James
James Simpson
Web Developer
imebgo@hotmail.com
P S - This is what part of the alphabet would look like if Q and R were eliminated
Mitch Hedberg
|
|
|
|
|
Thank you very much.
This works.
|
|
|
|
|
N a v a n e e t h wrote: But why you need to create a SP run time? That doesn't make any sense.
He might be coding and OR mapper 
|
|
|
|
|
Then, what i do?
Can i take backup of that and the giving it for restore.
|
|
|
|
|
I put my function in a DLL(named HookDll.dll) , declare like this:
EXTERN_C __declspec(dllexport)
LRESULT CALLBACK LLMouseEventHandler(int nCode, WPARAM wParam, LPARAM lParam)
Now in a Win32 project, I call LoadLibrary("path to HookDll.dll") and it return NULL with error code is 126 (ERROR_MOD_NOT_FOUND)
I use Dependency Walker to check if there is any missing DLL that my DLL depend on , and it warn MSVCR90D.DLL is missing.
Then , I try to use P/Invoke to call LoadLibrary in a C# project
[DllImport("Kernel32.dll", EntryPoint = "LoadLibrary")]
static extern IntPtr LoadLibrary(string fileName);
And how strange , my HookDll.dll loaded successfully , so what about the missing MSVCR90D.DLL and why it can't be loaded when I call it in native way
One more thing , I found in Dependency Walker that my function was named _LLMouseEventHandler@12 , so when I call GetProcAddress , I have to use this new name , not the one I declared above. This maybe related to C++ naming convention, but I don't understand clearly
|
|
|
|
|
Hi I got this problem. It seems that when I am setting properties in wia nothing happens. The code is as follows.
foreach (WIA.Item item in d.Items)
{
foreach (WIA.Property prop in item.Properties)
{
Object obj = (Object)dpi_hor;
if (prop.PropertyID == 6147)
{
prop.set_Value(ref obj);
}
obj = (Object)dpi_ver;
if (prop.PropertyID == 6148)
{
prop.set_Value(ref obj);
}
obj = (Object)2;
if (prop.PropertyID == 6146)
{
prop.set_Value(ref obj);
}
}
}
Can someone tell me why nothing is happening specificaly with the grayscale setting. Thanks in advance
Stephen
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
This code seem weird to me. What are you expecting it to do ? Have you stepped through the debugger with it ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Yes I have. All values are set but it doesn't make a differance to the scanning. The code is right though I did a loop through the properties and looked at the names, the right properties are being set.
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
Got it figured out. Thanks anyway
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
How did you figure it out? I`m trying to set the properties in exactly the same way, but I get a "ACCESS DENIED" error 
|
|
|
|
|
hello everyone,
i have problem in replaceing some content to another one..
here is my code:-
i want to replace this one to..
should be
plz help me???
|
|
|
|
|
here is correct code:
replace your code with this one..
|
|
|
|
|
I suspect you forgot to check 'ignore HTML tags'
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
i want to dir video in my application & save it in specific folder how i do that in .net 2
thanks 4 any help
md_refay
|
|
|
|
|
You'll need to write some code 
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
What does 'dir' mean ?
Either way, there's tons of CP articles on video in C#.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
I am writing a small project in C#.net. Now there is a need for me to use vb.net class in my project. However when I add vb.net class to my c#.net project, the project can not recognize the vb.net class and I can not instantiate an object of vb.net class.
Can somebody advise me how to create an object of vb.net class in c#.net and use its methods/members etc..
Thanks
|
|
|
|
|
The only way you can do this, is to put the VB.NET class in a dll, and then import that dll into your project ( so you'll have to distribute the dll with the project, too )
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
