Connection string has been done using below code, Now please help me out to save data from SQL to SharePoint List:
public static String GetDatafromSQL()
{
string serverIp = "172.30.71.80";
string username = "SP1234";
string password = "SP@1234";
string databaseName = "userInfo1";
string PortNumber = "3306";
string dbConnectionString = string.Format("server={0};uid={1};pwd={2};database={3};port={4};", serverIp, username, password, databaseName, PortNumber);
string query = "SELECT * FROM user";
var conn = new MySql.Data.MySqlClient.MySqlConnection(dbConnectionString);
conn.Open();
var cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var someValue = reader["contact"];
// Do something with someValue
}
string Status = "Yes";
return Status;
}
Shiv Sharma
