Re: How to connect ASP.Net With SQL Server - C# Discussion Boards

Re: HINSTANCE of a module

17-Aug-05 10:12

For example
NetServerEnum[^]
Network computer picker control
[^]

MCAD

HINSTANCE of a module

Anonymous16-Aug-05 20:42

Anonymous

16-Aug-05 20:42

I am trying to use a C# DLL assembly from in-memory. This DLL uses a Win32 Native function which requires HINSTANCE of the module in DLL. So, I try to use the Marshal.GetHINSTANCE Method. It works fine if I use the DLL from physical drive. However, the moment I try to run the DLL from in-memory, I get an error. After some research in MSDN, I found the following remark in the help on Marshal.GetHINSTANCE Method:

"When dynamic or in-memory, modules do not have an HINSTANCE."

Now, my problem is that when DLL is run from in-memory, its modules do not have HINSTANCE as per MSDN documentation. However, the Win32 Native function requires HINSTNCE as one of the parameters. I tried to use null or (IntPtr) 0, etc., but they do not work.

Is there any solution to this problem?

Thanks in advance.

Dave Kreskowiak17-Aug-05 4:16

Dave Kreskowiak

17-Aug-05 4:16

When the .DLL is in memory the HINSTANCE is your application, not the DLL.

What's the Win32 Native function your trying to call and what are you doing with it?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

How to connect ASP.Net With SQL Server

dwark10616-Aug-05 19:30

dwark106

16-Aug-05 19:30

I am new of ASP.Net and facing a problem that whenever I do connection ASP.Net with Sql Server it gives me error

"Login failed for user 'ComputerName\ASPNET'.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'ComputerName\ASPNET'.

Line 78: thisAdapter.Fill(thisDataSet,"Customers");

I am doing like this "

string myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;server=ComputerName\\MY2000";

thisConnection = new SqlConnection(myConnectionString);
and so on. It is working fine in windows form.

Thanks

Re: How to connect ASP.Net With SQL Server

Christian Graus16-Aug-05 19:34

Christian Graus

16-Aug-05 19:34

When you're using ASP.NET, you're working as the ASPNET user. That user needs to have the right to log in to SQL Server. The easiest way around is to log in with username/password instead of using Windows authentication.

Christian Graus - Microsoft MVP - C++

Re: How to connect ASP.Net With SQL Server

dwark10616-Aug-05 19:45

dwark106

16-Aug-05 19:45

Thanks for your mail.

I am doing like this

string myConnectionString = "Initial Catalog=MyDB;Data Source=localhost;Integrated Security=SSPI;server=ComputerName\\MY2000;user id=sa; Password=";

My password is blank.
I am not using windows authentication.

It is working without using ASP.NET.

Re: How to connect ASP.Net With SQL Server

dwark10616-Aug-05 20:13

dwark106

16-Aug-05 20:13

If I remove this "Integrated Security=SSPI;" from connecting string then It is working fine.

Thanks a lot for your kind help.

Reading Text Files

boomer194616-Aug-05 18:17

boomer1946

16-Aug-05 18:17

Hi All,

I'm a newbie. I am trying to find out how
to store string data read from a file into
a table or another string.

I keep getting the error, cannot implicitly
assign a string to string?!

Help! Cry | :((

Christian Graus16-Aug-05 18:23

Christian Graus

16-Aug-05 18:23

boomer1946 wrote:
I keep getting the error, cannot implicitly
assign a string to string?!

Perhaps if you posted your code, we could see what's going on ?

There's no reason why you can't build a string from the value of another string. What do you mean by table ? How do you want the string to move into it ?

Christian Graus - Microsoft MVP - C++

boomer194617-Aug-05 16:35

boomer1946

17-Aug-05 16:35

Hi Christain,

I solved the problem. It was my error
using improper syntax.

Thanks for your reply.

Isaac Smile | :)

sean_mufc17-Aug-05 0:38

sean_mufc

17-Aug-05 0:38

Sounds as if you have a simple problem, but cannot be sure as you haven't posyed your code.

Try using the ToString() method, contained within most classes in the .NET Framework

Speech Recognition without using MSAGENT

boomer194617-Aug-05 16:38

boomer1946

17-Aug-05 16:38

Yes, it was a simple problem solved by using
the proper syntax. I guess you would call it
a newbie error. I keep building on acquired
knowledge. I'm getting there.

Thanks for your prompt Smile | :)

reply.

Isaac

michaelreian16-Aug-05 15:38

michaelreian

16-Aug-05 15:38

Hello,
Is there a way to do speech recognition in C# without using MSAGENT?

Regards,
Michael

Re: Speech Recognition without using MSAGENT

Scott Serl16-Aug-05 16:24

Scott Serl

16-Aug-05 16:24

I haven't used it, but there is a Microsoft speech api.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/SAPI51sr/html/Welcome.asp[^]

Timer Object

binglin16-Aug-05 15:34

binglin

16-Aug-05 15:34

I have a foreach loop which checks on a ArrayList

I would like to include the Timer object to go through the foreach loop at a 1 second interval.

How can I do this?

Thanks,
BingLin

Mohamad Al Husseiny16-Aug-05 15:43

16-Aug-05 15:43

1-Add Timer
2-Set Enable Property To true
3-Set Interval Property to 1000
4-Subscribe to Tick event
5-Add the for loop in Tick event handler

MCAD

binglin16-Aug-05 22:47

binglin

16-Aug-05 22:47

i've created the object:

System.Timers.Timer myTimer = new System.Timers.Timer(1000);

I have this:

public void start_click(object sender, System.EventArgs e)
{
//initialise connection to my hardware thru com1

ArrayList frames = this.gCont.GetResponseFrames();

foreach(byte[] frame in frames)
{
//do my stuffs
}
}

how should i use the timer to check through the foreach loop after the creation of connection and arraylist?

Mohamad Al Husseiny17-Aug-05 5:03

17-Aug-05 5:03

I told you in the previous post
You need to write this code in Timer Tick event handler
Not in Command Click event after you set the properties

private void timer1_Tick(object sender, System.EventArgs e)
{
//initialise connection to my hardware thru com1

ArrayList frames = this.gCont.GetResponseFrames();

foreach(byte[] frame in frames)
{
//do my stuffs
}
}

		
}

MCAD

sean_mufc17-Aug-05 0:52

sean_mufc

17-Aug-05 0:52

I am assuming you are writing a Windows App.
Basically you click on the timer in the Toolbox panel (in design view) and drag it to the form. Go to timer properties an set Enabled to True and Interval to 1000ms (1s). Double click on the timer icon in design view, This will then switch to your code and it will have added the following:

private void timer1_Tick(object sender, System.EventArgs e)
{
// forech loop and associated code to go here
}

Put your code inside the method and it will run ever second

Program with no UI

monrobot1316-Aug-05 12:53

monrobot13

16-Aug-05 12:53

I'd like to write a program that has no UI at the current time, but I might like to add one in later. What would be the best type of project to use for this? Should I start a console app, a windows forms app (and just remove the form), should I start a class library app or just an empty one and add as I see fit?

Thanks for the help

- Aaron

Re: Program with no UI

therealmccoy16-Aug-05 13:01

therealmccoy

16-Aug-05 13:01

I would start with a Class Library.

www.lovethosetrains.com

Re: Program with no UI

Mohamad Al Husseiny16-Aug-05 14:54