Hi!
thanx for ur reply , no errors in design checker .
code what i have written is :
SqlConnection conn = null;
try
{
XPathNavigator navigator = this.MainDataSource.CreateNavigator();
string Title = navigator.SelectSingleNode("//my:title", this.NamespaceManager).Value;string Address = navigator.SelectSingleNode("//my:address", this.NamespaceManager).Value;
string City = navigator.SelectSingleNode("//my:city", this.NamespaceManager).Value;string State = navigator.SelectSingleNode("//my:state", this.NamespaceManager).Value;
string Zipcode = navigator.SelectSingleNode("//my:zipcode", this.NamespaceManager).Value;double Latitude = Convert.ToDouble(navigator.SelectSingleNode("//my:latitude", this.NamespaceManager).Value);
double Longitude = Convert.ToDouble(navigator.SelectSingleNode("//my:longitude", this.NamespaceManager).Value);conn = new SqlConnection();conn.ConnectionString = "server=KFLS3;database=FCS;Trusted_Connection=yes";
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText =
"INSERT INTO FCS_DEMO VALUES ('" + Title + "','" + Address + "','" + City + "','" + State +"','" + Zipcode + "','" + Latitude + "','" + Longitude + "')";
command.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
i am new to infopath coding can u please elaborate about UDC in infopath .. or what i have did wrong in my coding...
Regards,
kshitij