|
sir actually problem is this that i do not want to save image in folder before display in image control.
Means first i want to browse image using fileupload control then on open click of subwindow i want to show image in image control for confirmation that selected image is correct and after that i want to save it in folder or database...
Hope u will got my question
|
|
|
|
|
Hi.
I try to connect sql server 2005 through OBDC connection bt i face a error please give me some solution, i face this error
ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
my Coding is
OdbcConnection conn = new OdbcConnection("Driver={SQL Server};Server=test;UID=sa;PWD=java;");// test is my ODBC connection name
string query = "INSERT INTO test VALUES ('" + textBox1.Text + "','" + textBox2.Text + "')";
OdbcCommand cmd = new OdbcCommand(query, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Inserted.");
}
finally
{
conn.Close();
}
|
|
|
|
|
Are you sure your user name and password are correct?
The database name appears to be missing as well.
|
|
|
|
|
thanks for reply.
yes username and password is correct. where i put database name???
|
|
|
|
|
OdbcConnection conn = new OdbcConnection("Driver={SQL Server};Server=test;DataBase=DataBaseName;UID=sa;PWD=java;");
|
|
|
|
|
|
mjawadkhatri wrote: OdbcConnection conn = new OdbcConnection("Driver={SQL Server};Server=test;UID=sa;PWD=java;");
try this:
<br />
OdbcConnection conn = new OdbcConnection("DSN=test;UID=sa;PWD=java;");<br />
this is assuming that you have created a DSN entry with name test.
|
|
|
|
|
Try this to include your database nam:
OdbcConnection cn= new OdbcConnection("Driver={SQL Server};Server=mySQLServer;UID=sa;
PWD=myPassword;Database=Northwind;");
Also make sure that your Sql Server 2005 allows remote connections because by default it doesn't!
|
|
|
|
|
hi,
i have got 1000 records in access table and i want to read alternate data.
ie 500 records out of 1000.
how to advance the reader to next record?
|
|
|
|
|
You need to implement your own logic in a loop.
Your logic could simply be something like
While reader.Read(){<br />
intCounter++;<br />
if (intCounter % 2 == 0){<br />
Console.WriteLine(reader(0).ToString())<br />
}<br />
}<br />
End While
|
|
|
|
|
One of the method is missed in the call stack when code is compiled in release mode. Here is the sample code:
static void Main(string[] args)
{
MyFunc();
Console.ReadKey(false);
}
public static void MyFunc()
{
Console.WriteLine(Program.GetCallStack());
}
public static string GetCallStack()
{
System.Diagnostics.StackTrace callStack = new
System.Diagnostics.StackTrace();
string s = "";
int index = 0;
while (true)
{
System.Diagnostics.StackFrame frame =
callStack.GetFrame(index);
if (frame == null) break;
System.Reflection.MethodBase method = frame.GetMethod();
if (index 0) s = " --" + s;
s = method.DeclaringType.Name + "." + method.Name + "()" + s;
index++;
}
return (s);
}
Why is it so?
Gurpreet
|
|
|
|
|
Make sure that you're created PDB's when compiling in Release configuration.
In VS2008, you can set the property using the project properties -> Build -> Advanced... -> Debug Info.
|
|
|
|
|
My setting is Debug Info=pdb only
but it does not work
Gurpreet
|
|
|
|
|
Hmm, I take it that the PDB's are in the same folder as the dll?
What specifically isn't working?
When I run your code I get the following output (I inserted a Environment.Newline):
Debug:
ThreadHelper.ThreadStart()
ExecutionContext.Run()
HostProc.RunUsersAssembly()
AppDomain._nExecuteAssembly()
Program.Main()
Program.MyFunc()
Program.GetCallStack()
Release (with PDB)
ThreadHelper.ThreadStart()
ExecutionContext.Run()
HostProc.RunUsersAssembly()
AppDomain._nExecuteAssembly()
Program.Main()
Program.MyFunc()
Program.GetCallStack()
|
|
|
|
|
Here is my output (RUN IT VIA COMMAND PROMPT AND NOT F5 in Visual Studio)
C:\Applications\poc\ConsoleApplication1\ConsoleApplication1\bin\Release>consolea
pplication1
Program.Main()Program.GetCallStack() --
C:\Applications\poc\ConsoleApplication1\ConsoleApplication1\bin\Release>cd..\deb
ug
C:\Applications\poc\ConsoleApplication1\ConsoleApplication1\bin\Debug>consoleapp
lication1
Program.Main()Program.MyFunc()Program.GetCallStack() --
NOTE : - Program.MyFunc() is missing in release mode.
Gurpreet
|
|
|
|
|
Anyone has any information on this? Its bit urgent!!
Gurpreet
|
|
|
|
|
I've run the code from command prompt and you're right. I believe that this is a compiler optimisation as MyFunc is so simple. If you run the following code:
static void Main(string[] args)
{
MyFunc();
Console.ReadKey(false);
}
public static void MyFunc()
{
Console.WriteLine("Begin");
Console.WriteLine(Program.GetCallStack());
Console.WriteLine("End");
}
public static string GetCallStack()
{
System.Diagnostics.StackTrace callStack = new
System.Diagnostics.StackTrace();
string s = "";
int index = 0;
while (true)
{
System.Diagnostics.StackFrame frame =
callStack.GetFrame(index);
if (frame == null) break;
System.Reflection.MethodBase method = frame.GetMethod();
if (index == 0) s = " --" + s;
s = method.DeclaringType.Name + "." + method.Name + "()" + Environment.NewLine + s;
index++;
}
return (s);
}
You should get the following output:
Debug:
Begin
Program.Main()
Program.MyFunc()
Program.GetCallStack()
--
End
Release (with PDB):
Begin
Program.Main()
Program.MyFunc()
Program.GetCallStack()
--
End
|
|
|
|
|
Thanks this works!!
Gurpreet
|
|
|
|
|
You can try:
[MethodImpl(MethodImplOptions.NoInlining)]
In the method that is disappearing.
|
|
|
|
|
Hi
Is there a way to convert .flv to .WMV file using C#? Please advise.
Thanks
Jawad Khatri
|
|
|
|
|
|
Hi everyone,
Today I am highly unpleased about a matter and that is "Test Driven Development". I just want to share my idea with you and want to hear back from you if what I am thinking is right or wrong. Also would like to hear about your idea.
Last few days, I am highly studying about Test Driven Development and to me, it sounds like, there is a magical framework which will allow me to run automated Unit Tests on methods I write. OWE, that can be awesome. I can only just dream about it. But when I wanted to practice, I realized that, it is not applicable to any of the project I have developed so far. What a weired. The articles and books tells me lots of benefits about Test Driven Development, like, 'You will get confidence when you write code...etc...blah blah blah..' But I dont think it is now unknown to any developer. To my thinking, almost all developers develop some kind of test project to test the application he/she is developing. So, what is really irritating me is, I have following Projects:
1. WinForm Custom Control.
2. ASP.NET WebForm Custom Control.
3. ASP.NET Web Application.
4. Windows Form Application.
5. Some Class Libraries in C#.
Ok, Now, I started to apply TDD to WinForm Custom Control and ASP.NET Custom Control which is purely UI oriented. Now, I found that, TDD is not good for UI. It is really not possible to automate the test on my control for some weired activities done by my user. I need to manually do something using Mouse/Keyboard to generate a problem and then, write solution to that problem. Yeah, I read there are some very very complex frameworks for testing UI, but I believe those are all commercial advertisement, not a developer friendly framework.
Then, I tried to apply VS integrated Unit Test feature to test my ASP.NET Web Application, Alas, it is sooo rigid that, I can test only if the user clicked a button or not. I wanted to test to simulate Login, But I found I cannot provide password to the Login Control and then, I gave up. Also many many limitations are there, I cannot test what I really worry about.
Then, I tried on Windows Form Application, again, same problem. Windows Form is highly UI oriented. Some of the experts are telling me that, I should not test UI. Rather, I should separate the UI from Business logic and test only Business Logic. Well, I thought, ok, lets try to test the Business Logics, when I separated my UI from Business Logic, I did not find really much code there. Because, Business logics are somehow related to UI. Anyway, of course it is my OOP practice that my Business logic code which is not used outside of the scope, I create them as private methods. So, I found that, TDD cannot test Private Methods. Hell!! then, what I gonna test ? I searched the google and found some article where someone is telling that, 'Private methods are AntiPattern' HUH!!! ? Just because TDD cannot be used, so now I will have to forget about OOP principles of encapsulation and think that, private methods are AntiPattern !! Now, I will have to make all my methods public which gonna clash with names ...one with another... ? I really got irritated to read that. The writer in that article wrote that, " I can bet, most of your private methods can be written as public "!! I was really angry to read that . Yeah, well, if I just change all the methods from private to public then, yes, my application wont break, but then ? is that the way I can maintian my project ?
Finally I found it useful, only if I develop an algorithm like 'Search', 'Sort' etc which does not have anything to do with UI and Website, Session etc, then, yes, I can use TDD. I dont know, unless I create an enterprize application, I wont find any really big algorithm development project. So, I am asking your opinion. What do you think about it ?
Thanks for your time reading this post.
Regards.
|
|
|
|