General

Re: problem in Submitting data from infopath form to sql server via programming

Kshitij bishnoi24 — Tue, 15 Sep 2009 09:35:16 GMT

yes .. how to make it browser compatible code...

Re: problem in Submitting data from infopath form to sql server via programming

Hilary Stoupa — Tue, 15 Sep 2009 00:16:30 GMT

Your code works in the client? Just not on the browser?

Re: problem in Submitting data from infopath form to sql server via programming

Kshitij bishnoi24 — Mon, 14 Sep 2009 09:45:50 GMT

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

Re: problem in Submitting data from infopath form to sql server via programming

Hilary Stoupa — Sun, 13 Sep 2009 13:55:37 GMT

Do you have any errors in the design checker? What is your code like? I'm wondering if it is a security issue -- you might be better off creating a UDC for the data connection, then modifying the connection's command in code to an insert command. I think this will keep you from having to make your form full trust, as well.

problem in Submitting data from infopath form to sql server via programming

kshitij bishnoi1984 — Fri, 11 Sep 2009 16:36:51 GMT

Hi!

i have make one form and write code for submitting the data to sql server ,by given full trust it is submitting the data to sql but once i published this form and activate this form as a feature in sharepoint site and open the form in browser it is not showing any error and not submitting anything to sql server ....

Can anybody help me ,its urgent...

thanks,

kshitij