Hi... I want to know the diffrence between SQL Express and SQL mangment studio. On my PC which is standalone ,SQL server 2008 Insrtalled but I unable to see any database or anything.I can see only Configration manager. So On my pc SQL express installed or Only Managment studio installed ? Which application I have to install so I can create the database ?

I want to write code in VB.NET in which,I want to send XML data to following link. Here is link : http://someWebService.abcCompany.com/smspost.asp ex. I want to send following XML data(not file) to above URL. <xml version="1.0"?> <packet> <Number>9856554877</Number> </Packet> What is syntaxt to send any data to any URL in VB.NET ? What are commands used in VB.NET to send any info to URL ? Which Library or refrences I have to use ?

I have written a code in VB.NET to send the mail... Try Dim ClientPC As New SmtpClient(ServerName, ServerPortNumber) Dim Authentication As New Net.NetworkCredential(ServerLoginName, Password) ClientPC.Credentials = Authentication Dim mSender As New MailAddress(ServerLoginName) Dim mReceiver As New MailAddress("myyahoomail@yahoo.com") Dim sMail As New MailMessage(mSender, mReceiver) sMail.Subject = SubjectOfMail sMail.Body = MailBody ClientPC.Send(sMail) Catch ex As SmtpException Throw ex Catch ex As Exception Throw ex End Try Mail goes perfectly .... Now I want to add CC too in above code where can I add CC code into this ?

Hi Buddies... I use clickOnce for publishig my application ... But when It publish Ex. I am publishing Version 1.0.0.2 then after publish it ask for "Whether To Install new version or not ?" If user click on skip button It wont get the latest version and it still uses older version,untillI dont publish next version ... Is there any facility in VS that each time it ask for latest version When user runs that application and if he is using older version.

How can I do this ? Can youi give me steps or msdn link related to that topic ?

I publish my application evry week with latest updated version, via internet...using CLICK ONCE.... I have take care of autheentication of the publishig person It publishes fine... Now Whenever I publish it, after publish,It ask for download latest version or not? So I cant make the compultion to user to take the latest version... Is there any option in click once that I can set, So next time I publish user comapsary has to be get the update version or It directly loads a new version application without asking user ?

How to read atrribute Name and type ?

I want to read the following xml schema file and I want to take/pickup only elements name like ID,Trademark and model I have this code Try Dim reader As New Xml.XmlTextReader("C:\xml\XMLFile2.xml") Dim s As String = "" While readee.Read If reader.AttributeCount < 2 Then s = reader.LocalName <---------------Returns element End If End If End While Catch ex As Exception End Try In above code the line reaturns the 'element' keywod but I want 'ID','tradeMark','Model' insted of element keyword... How can I do this ?

I want to read the following xml schema file and I want to take/pickup only elements name like ID,Trademark and model I have this code Try Dim reader As New Xml.XmlTextReader("C:\xml\XMLFile2.xml") Dim s As String = "" While readee.Read If reader.AttributeCount < 2 Then s = reader.LocalName <---------------Returns element End If End If End While Catch ex As Exception End Try In above code the line reaturns the 'element' keywod but I want 'ID','tradeMark','Model' insted of element keyword... How can I do this ?

I have the code of readin gxml file Dim reader As New Xml.XmlTextReader("C:\XMLFile2.xml") Dim s As String = "" While reader.Read() s = s + reader.Name End While Now from above code,the reader reads every single word of the schema.. But I want to read only Nodes and its child node of the schema and store it into s.. How can I read only the element and its child nodes ?

I am devloping an application in which I wan to bind gridview using xml data which comes from database .. How can I bind the gridview using SqlAdapter and dataset objects ? I have following code but it doesnt make column as per xml data in grid view It shows all data into single column .. I dont know whether I am make some mistake in inserting or retrving the data... Whether I have to store the xml as document type or as storage type ? I have following code which I use to bind the grid view ... Dim sqlString As String = "Data Source=ADSERVER\..........." Dim sqlConnection As New SqlConnection(sqlString) Dim xr As Xml.XmlReader Dim ds2 As New DataSet Dim dt As DataTable sqlConnection.Open() Dim cmd As New SqlCommand("Select data from xmlTest where PKID=63", sqlConnection) xr = cmd.ExecuteXmlReader() ds2.ReadXml(xr, XmlReadMode.InferSchema) dt = ds2.Tables(0) VGridControl1.DataSource = dt Which displays the in the single column as it is in database...

I want to read the xml data from the sql server 2005 by using vb.net I have xmltest table in datatbase and the data column which has the xml datatype but I have a code of reading the xml data as follows conn.Open(); SqlCommand command = conn.CreateCommand(); System.Text.StringBuilder builder = new System.Text.StringBuilder(); command.CommandText = "SELECT XmlDesc FROM XmlTest WHERE ID = " + ID.ToString(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { 1)how to use in vb.net ? -----> SqlXml sqlXmlValue = reader.GetSqlXml(0); XmlReader xmlReader = sqlXmlValue.CreateReader(); while (xmlReader.Read()) { 2) How to use in vb.NET ---> builder.Append(xmlReader.ReadString()); builder.Append(" "); } txtXmlDesc.Text = builder.ToString(); } else txtXmlDesc.Text = "No Value"; now I want to convert this code in to vb.NET what shoud I use at 1 and 2 ? insted of SQLXml which is in c# what should I use in vb.net ?

As i am new in the XMl world I want to discuss the following steps 1) I wan to read the xml file 2) after reading I have to bind that file to propoertyGridControl box 3) Afetr filling the data by user into that property grid contol I have to Store that data into database(SQL server 2005)in single column ( XML dtat Type) 4) after storing the data Next time when user loads that Propoerty grid cotrol I have to bind that data to property grid Now I want to know that 1)from above senario I have to use XML as document format or like storage type ( As I want to store and again bind to grid) 2) What is the struuctrue I have to follow to save in database so I can read agin that xml from database and bind to grid ? Ex. Is ABC 33 Valid ? to store in database as it is ? 3) Which query I have to fire to get exact same structure to get from DB ? 4) How can I read the XML using Dataset(in VB.NET) and bind to grid ? 5) How can I use the SQLCommand objext to read xml data and bind to grid ? Is there Typecasting reaquire ?

Hi... I have try it I have store the data into databse in following format... (orignal data in file) aaa 21 I store the following data using this code dim xmldata = _ aaa21 SqlConnection.Open() Dim cmd As New SqlCommand("insert into xmlTest Values(62,'" & xmldata & "')", SqlConnection) cmd.ExecuteNonQuery() MessageBox.Show("Record Saved Succsessfully") SqlConnection.Close() it stores sucsessfully but after executing the following query I get the this data... Select * from xmlTest for xml auto I get this data after firing the query on that row of SQL server <-------------------------------table name and PKID <-------------------------------Column Name of Table aaa 11 befor going to ask about retriving the data first tell me whether I am storing the data in right format or not ?

Hi... I have try it I have store the data into databse in following format... (orignal data in file) aaa 21 I store the following data using this code dim xmldata = aaa_ 21 SqlConnection.Open() Dim cmd As New SqlCommand("insert into xmlTest Values(62,'" & xmldata & "')", SqlConnection) cmd.ExecuteNonQuery() MessageBox.Show("Record Saved Succsessfully") SqlConnection.Close() it stores sucsessfully but after executing the following query I get the this data... Select * from xmlTest for xml auto I get this data after firing the query on that row of SQL server aaa 11 befor going to ask about retriving the data first tell me whether I am storing the data in right format or not ?

Thanx buddy, but i have still some issue.. I have created the table call XMLTest into database in which I have two fields PKID-Integer datatype Data-XML datatype While storing the xml data into database whether I have to put the line at start of the data or not ?

Hi , I am new in .NET technology... I have a XML file containing following data... <?xml version="1.0" encoding="utf-8"> <MyData> <EmployeeName>aaa</EmployeeName> <age>25</age> </MyData> Now,I want to simply store this into databse(SQL server 2005)using VB.NET and I want to retrive same data and bind to grid... How can I do this ?

Hi , I am new in .NET technology... I have a XML file containing following data... aaa 25 Now,I want to simply store this into databse(SQL server 2005) and I want to retrive same data and bind to grid... How can I do this ?

I have code like Dim subject As String = "Test EmbeddedImage" Dim contentId As String = "image1" Dim body As String = "Here is a picture of CRM: Dim av1 As AlternateView = AlternateView.CreateAlternateViewFromString(body, Nothing, "Text/Html") Dim linkedResource1 As LinkedResource = New LinkedResource(ms,?????) linkedResource1.ContentId = contentId av1.LinkedResources.Add(linkedResource1) . . other code for sending mail . . What should I write at ???? for sending mail with image ?

please read carefully ... I have a Picture box on the form ... and I want to send that image with mail which appears in pictute box Now I have a code that takes the image from folder structure like c:\temp\aaa.jpg It sends image with mail PERFECTLY.... but now I have to send mail which is store in memory stream . not in file... I have code like How can I send the image wich stored in memory stream ??? I have code like Public sub senmail(ByVal image1 as Image) Dim subject As String = "Test EmbeddedImage" Dim contentId As String = "image1" Dim body As String = "Here is a picture of CRM: Dim ClientPC As New SmtpClient("ddd.com", 25) Dim Authentication As New Net.NetworkCredential("nmy@myserver.com", "password") ClientPC.Credentials = Authentication Dim mSender As New MailAddress("nmy@myserver.com") Dim mReceiver As New MailAddress("nmy@myserver.com") Dim sMail As New MailMessage(mSender, mReceiver) sMail.Subject = "Testing embedded image 25 july 3.41 PM" Dim av1 As AlternateView = AlternateView.CreateAlternateViewFromString(body, Nothing, MediaTypeNames.Text.Html) Dim ct, ct1 As New ContentType Dim ct2 As New ContentType("image") ct.MediaType = MediaTypeNames.Image.Jpeg Dim linkedResource1 As LinkedResource = New LinkedResource(ms, ct.MediaType) <----- gives error here linkedResource1.ContentId = contentId av1.LinkedResources.Add(linkedResource1) sMail.AlternateViews.Add(av1) sMail.IsBodyHtml = True ClientPC.Send(sMail) end sub