Posts by sandeepparekh9

.SelectCommand.CommandText = "SELECT Reference_Number, Year, Title, Surname," + _
"FirstName, Date_of_Birth, Origin, Phone, State_Deployed, Facility_Deployed FROM HEALTHWORKERS" + _
"WHERE DESIGNATION = BASIC MIDWIVES"

a silly mistake.. you forgot a space between "FROM HEALTHWORKERS" AND "WHERE"

JUST change your query to :

.SelectCommand.CommandText = "SELECT Reference_Number, Year, Title, Surname," + _
                "FirstName, Date_of_Birth, Origin, Phone, State_Deployed, Facility_Deployed FROM HEALTHWORKERS " + _
                " WHERE DESIGNATION = 'BASIC MIDWIVES'"

i think you are trying to connect to sqlexress instance of sql 2008 server.

do u have sql 2008 installed???

A Function To Concat String Array Values By Specified Delimiter

Let 's Say I have Following Array:

string[] st = new string[5];
st[0] = "Animation";
st[1] = "Action";
st[2] = "Romance";
st[3] = "Drame";
st[4] = "Comedy";

Now I want to Merge all of it with ',' Delimiter Like Below:

Output : Animation,Action,Romance,Drame,Comedy

We will Call it Like This:
string str = GetAllStringsFromArrary( st,",");

Check here for better understanding: [snipped]

hi..

You will need Taglib - Sharp Library for this purpose .

For Complete understanding and project Download Go to: [snipped]

use below library
http://itextpdf.com/

use this:

decimal moneyvalue = 1921.39m;
            string html = String.Format("Order Total: {0:C}", moneyvalue);
            textBox1.Text = html;

did you use inbuilt visual studio deployment option..?

view this:

http://www.functionx.com/vbnet/oledb/Lesson02.htm

hi...

suppose your dataset is DS

check this kind of condition..

if DS.Tables(0).Rows.Count >0 then

"load your report"

else

MessageBox.Show("Nothing to Print")

End IF