C# Discussion Boards - CodeProject

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

Joe Rozario

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

Joe Rozario

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

Joe Rozario

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