Re: database connection problem - C# Discussion Boards

6-Dec-09 21:48

hi all
i am just beginner in c# and i want to make a PhoneBook project by using ADO.Net.. and i use SQL Server 2005 Express Edition for my database
but i have a problem while connecting database..in the error it says:
"Cannot database "Kisiler" requested by the login.The login failed.The login failed for user 'Computer\SQLEXPRESS'"
my connection string is like that :
SqlConnection con = new SqlConnection("Data source=COMPUTER\\SQLEXPRESS;initial catalog=Kisiler;integrated security=True");
i checked services after that error..everything looks running when i looked at SQL Server Configuration manager
what should i do now ?

lalit146-Dec-09 22:21

lalit14

6-Dec-09 22:21

SqlConnection con = new SqlConnection("Data source=COMPUTER\\SQLEXPRESS;initial catalog=Kisiler;integrated security=True; User id=sa; Password=123456");

Use this. but do remember to type ur userid and password

Regards
Lalit Manik

Erdinc276-Dec-09 22:42

6-Dec-09 22:42

thanks for the reply friend
i tried the string u wrote but still i get same error
and i didnt use any password while i was creating my table...i mean i use 'Windows Authentication' mode
u have any else suggesstion ?

puri keemti6-Dec-09 22:27

puri keemti

6-Dec-09 22:27

Problem is with connection string.
User name and password credentials are missing there....

MNantu6-Dec-09 22:43

6-Dec-09 22:43

When connecting to a database with Integrated Security set to true, I don't think you need to specify User ID and Password. Smile | :)

MNantu6-Dec-09 22:36

6-Dec-09 22:36

Try changing the Data Source to

Data Source=.\\SQLEXPRESS (Assuming you're using the default instance.)

You can also check out connectionstrings.com[^]

Hope this helps =)

Erdinc276-Dec-09 23:15

6-Dec-09 23:15

hi
i checked the site
but as i see my connection string is the same in the site
i give permission that user to use the database but still i have error
Frown | :(

MNantu6-Dec-09 23:20

6-Dec-09 23:20

Which OS do you use by the way

Erdinc276-Dec-09 23:43

6-Dec-09 23:43

i use windows XP

lalit147-Dec-09 0:01

lalit14

7-Dec-09 0:01

Try "Integrated Security=false" and the above code i have given...

i Hope it will work

Regards

Lalit Manik

lalit147-Dec-09 0:10

lalit14

7-Dec-09 0:10

Temme 1 thing, the account from which u logged in to Ur computer have rights to access the SQl?

Erdinc277-Dec-09 0:14

7-Dec-09 0:14

yeah i have given permission to that user
but still it says it doesnt have to reach the db

MNantu7-Dec-09 0:40

7-Dec-09 0:40

Is database server running on your local machine ?

Erdinc277-Dec-09 1:19

Converting BitArray to string

7-Dec-09 1:19

yeah it works man
do you think it happens becuase of installation or some another options ??

Joe Rozario6-Dec-09 21:37

6-Dec-09 21:37

Dear Friends,

i have small problem

can U please tell where do i make mistake?

i am converting string value "0000000000000001" to byte array

then again i am converting back byte array to string

the out put is like these "0000000010000000"

private void button14_Click(object sender, EventArgs e)
{
//i am converting string value "0000000000000001" to byte array
string sVall = "0000000000000001";
byte[] bVal =convertBinaryToByte(sVall, 8);

//then again i am converting back byte array to string

BitArray objBitA = new BitArray(bVal);
MessageBox.Show(converBitArrayTostring(objBitA));

}

private string converBitArrayTostring(BitArray objBit)
{
try
{
string sReturnValue = "";
for (int i = 0; i < objBit.Length; i++)
{
sReturnValue += (objBit[i]) ? "1" : "0";
}
return sReturnValue;
}
catch
{
return "";
}
}

private byte[] convertBinaryToByte(string binary, int bitsPerByte)
{
try
{
List<byte> list = new List<byte>();
for (int i = 0; i < binary.Length; i += bitsPerByte)
{
string t = binary.Substring(i, bitsPerByte);

//list.Add(Convert.ToByte(t, 2));
list.Add(Convert.ToByte(t));
}
return list.ToArray();
}
catch
{
return new byte[0];
}
}

please point out my mistake..

is there any othere better method to do this?

help me

by

joe

dan!sh 6-Dec-09 21:45

dan!sh

6-Dec-09 21:45

To convert a byte array into string, you can make use of GetString method of the various encoding classes available. But be sure that you don't have character which cannot be displayed correct in the encoding you select. Here is an example:

System.Text.UTF8Encoding encoding = new UTF8Encoding();
string str = enc.GetString(byteArray);

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Joe Rozario6-Dec-09 21:55

6-Dec-09 21:55

Dear friend thanks for your replay..

what i want is ...

i have string length is 16 , this string will have only 0 and 1,
now i want to convet it as two byts...

then From two bytes to (original) String.

if i Use encoding It gives me minmum 16 byte array (i do not want that)

Thank U.

shiplu_20506-Dec-09 22:27

shiplu_2050

6-Dec-09 22:27

Hi Joe
You can do this like

string str = "0000000000000001";
byte[] bb = System.Text.ASCIIEncoding.ASCII.GetBytes(str);

string str2 = System.Text.ASCIIEncoding.ASCII.GetString(bb);
MessageBox.Show(str + "\r\n" + str2 );

Regards
Mamun

Joe Rozario6-Dec-09 22:32

6-Dec-09 22:32

Dear friend thanks for replay....

that's good idea but You see

shiplu_2050 wrote:
System.Text.ASCIIEncoding.ASCII.GetBytes(str);

will return byte array size of 16 ...

i want to make to as 2 bytes ... and form 2 bytes to string.

thank you

OriginalGriff6-Dec-09 23:17

OriginalGriff

6-Dec-09 23:17

If I read your messages correctly, you want to take in a string of 16 '0' or '1' characters, and convert them to two bytes, then convert the two bytes back to s string?
If so, then the first thing you need to look at is the "<<" operator. This shifts bits a number of places to the left within a byte, int or whatever.
So you would:

For each character in string, convert it to a byte (0 or 1) depending on whether it was '0' or '1'.
Shift that bit into a byte until the byte is full. Save the byte, and move on for the next.

Re-assembling the string from your bytes is the reverse of this, and is probably best done with a method to convert a byte to an 8 character string, used twice.

Honestly, it is quicker to write the code, than to describe it!

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"

Luc Pattyn7-Dec-09 0:36

Luc Pattyn

7-Dec-09 0:36

Hi,

this is not related to character set encodings at all, it is either simple arithmetic, or using the appropriate conversion operations.

if you're sure the string is limited to 16 (or 32 or 64) binary digits, you can use code similar to this:

ushort sh=Convert.ToUInt16(binaryString, 2);
byte hi=(byte)(sh>>8);
byte lo=(byte)sh;

The inverse operation would be:

ushort sh=(ushort)((hi<<8) + lo);
binaryString=Convert.ToString(sh, 2);  // won't have leading zeroes
binaryString=binaryString.PadLeft(16, '0');

BTW: you would need a try-catch block to defend against invalid string input.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Joe Rozario7-Dec-09 7:27