Data Connections

Re: Urgent Help : help with the code

bogdantc — Wed, 28 Jan 2009 07:26:11 GMT

Hello,

This is a very fast code creation and there could be some data types minor mistakes. If there are please accept my apologies. You can create a "Hello world!" web service in C# and then you have to create another method SetEmployeesDetails (see below) which will call a stored procedure to do the actual insert.

using System.Data.SqlClient;
using System.Data;

[WebMethod(Description = "Sets employees details")]
    public int SetEmployeesDetails(string sEmployeeName, int nEmployeeId, DateTime dtDate )
    {
        int inRowsAffected;
        SqlConnection sqlConnSetEmployeesDetails;

        sqlConnSetEmployeesDetails = new SqlConnection("Data Source=myServerName;Initial Catalog=myDataBase;User ID=myUser;Password=myPass;");

        using (sqlConnSetEmployeesDetails)
        {
            SqlCommand sqlCmdSetEmployeesDetails = new SqlCommand("myTableIns", sqlConnSetEmployeesDetails);
            sqlCmdSetEmployeesDetails.

CommandType = CommandType.StoredProcedure;
            sqlCmdSetEmployeesDetails.Parameters.Add(new SqlParameter("@myEmployeeName", SqlDbType.NVarChar, 50));
            sqlCmdSetEmployeesDetails.Parameters[0].Value = sEmployeeName;
            sqlCmdSetEmployeesDetails.Parameters.Add(new SqlParameter("@myId", SqlDbType.Int));
            sqlCmdSetEmployeesDetails.Parameters[1].Value = nEmployeeId;
            sqlCmdSetEmployeesDetails.Parameters.Add(new SqlParameter("@myDate", SqlDbType.Datetime));
            sqlCmdSetEmployeesDetails.Parameters[2].Value = dtDate;


            sqlConnSetEmployeesDetails.Open();
            inRowsAffected = sqlCmdSetEmployeesDetails.ExecuteNonQuery();
        }

        return inRowsAffected;
    }

I really hope you will manage to make this code work. Please let me know of your final result.

Have fun,
Bogdan

Re: Urgent Help : help with the code

rekha — Tue, 27 Jan 2009 14:25:01 GMT

Hi ,

my bad i have followed that example . i have tried implementing in dummy forms but i have a problem storing the date field from date picker.

code for only date

using System;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using System.Data.SqlClient;

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class Service : System.Web.Services.WebService

{

public struct google

{

public string date;

}

[WebMethod]public int cool(google e)

{

int rowsAffected = 0;

using (SqlConnection conn = new SqlConnection("Data Source=MMSTIER2;Initial Catalog=Efforts;Integrated Security = SSPI;"))

{

SqlCommand cmd = new SqlCommand("INSERT INTO dummy(date) VALUES (@date)", conn);

cmd.Parameters.AddWithValue("@date",e.date);

conn.Open();

rowsAffected = cmd.ExecuteNonQuery();

}

return rowsAffected;

}

sql server column is

date datetime

when i execute and run it stores the blank value like

1900-01-01 00:00:00.000

date is from the datepicker format is 1/27/2009

can you please help me with date .so that i can combine everything for final form and submit.

i fear i may spoil the main form reason i am trying in dummy forms.

Thanks,

Rekha

Re: Urgent Help : help with the code

madhuri — Tue, 27 Jan 2009 13:47:33 GMT

Hello Rekha,

Look at this links,

http://www.bizsupportonline.net/infopath2007/how-to-submit-data-from-infopath-to-mysql-database-web-service.htm

http://blogs.msdn.com/jannemattila/archive/2007/10/25/from-infopath-to-database-via-web-service.aspx

Urgent Help : help with the code

rekha — Tue, 27 Jan 2009 13:27:40 GMT

Hi gurus,

I am learner in infopath and coding field. one of my HR infopath 2007 form need an data submission . The fields in the form for data submission are

Empname

Emp id

date from date picker which is in the form

i want to submit the details to database.I heard it can be done by some webservice.can you please help me with full code how to do that.

Sorry as i am very new to this field reason i am asking for full code in (c#) .

Need to complete the stuff by tomorrow.

Thanks in advance

Regards,

Rekha reddy