< configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
< connectionstrings><add name="DataSource" connectionstring="Database=Wiki;Server=PATRIC;User ID=wiki;Password=wiki;" providername="System.Data.SqlClient">
< add name="DataSource" connectionstring="Data Source=.\sqlexpress;Initial Catalog=Wiki;Persist Security Info=True;User ID=wiki;Password=wiki" providername="System.Data.SqlClient">
Web.config
< configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
< connectionstrings>
< add name="DataSource" connectionstring="Database=Wiki;Server=PATRIC;User ID=wiki;Password=wiki;" providername="System.Data.SqlClient"> //2000
< add name="DataSource" connectionstring="Data Source=.\sqlexpress;Initial Catalog=Wiki;Persist Security Info=True;User ID=wiki;Password=wiki" providername="System.Data.SqlClient"> //2005
< /add>
< system.web>
< compilation debug="true">
< /compilation>
< appsettings> </appsettings>
< /system.web>
< /add></connectionstrings>
< /configuration>
Koneksi in ASP.Net
using System.Data.SqlClient;
public class DBCon
{
SqlConnection conn;
string connStr;
public DBCon()
{
conn = null;
connStr = string.Empty;
}
public SqlConnection connect()
{
connStr=WebConfigurationManager.ConnectionStrings["DataSource"].ConnectionString;
conn = new SqlConnection(connStr);
return conn;
}
}
Validasi Loginpublic string validasiLogin(DataUser du)
{
string acc=string.Empty,pass=string.Empty;
try
{
conn.Open();
string sql = "select nama_user,account_user, password, role from data_user where account_user = @acc and password = @pass and status='Active' ";
command = new SqlCommand(sql, conn);
command.Parameters.AddWithValue("@acc", du.Account_user);
command.Parameters.AddWithValue("@pass", du.Password);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
du.Nama_user = reader.GetValue(0).ToString().Trim();
acc = reader.GetValue(1).ToString().Trim();
pass = reader.GetValue(2).ToString().Trim();
du.Role = reader.GetValue(3).ToString().Trim();
}
if ( acc.Equals(du.Account_user) && pass.Equals(du.Password))
{
return du.Role;
}
else
{
du.Role = "Invalid";
}
}
else
{
du.Role = "Invalid";
}
}
catch (SqlException sqe)
{
du.Role = "Invalid";
}
catch(Exception)
{
du.Role = "Invalid";
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
return du.Role;
}
Building xml+xsl
using System.IO;
using System.Xml;
using System.Xml.Xsl;
using System.Text;
using System.Xml.Schema;
protected void btnPreview_Click(object sender, EventArgs e)
{
Literal1.Text = "";
MemoryStream strm = new MemoryStream();
try
{
//MemoryStream strm = new MemoryStream();
XmlWriter writer = XmlWriter.Create(strm);
XmlDocument myXmlDoc = new XmlDocument();
myXmlDoc.LoadXml("
" + txtEdit.Value.Trim() + "");
myXmlDoc.WriteTo(writer);
writer.Flush();
writer.Close();
myXmlDoc = cekXML(strm);
//TextBox1.Text = myXmlDoc.OuterXml;
if (lblPesan.Text.Trim().Equals(""))
{
String strXslFile = Server.MapPath("XSLfile.xsl");
XslCompiledTransform myXslDoc = new XslCompiledTransform();
myXslDoc.Load(strXslFile);
StringBuilder myStringBuilder = new StringBuilder();
StringWriter myStringWriter = new StringWriter(myStringBuilder);
myXslDoc.Transform(myXmlDoc, null, myStringWriter);
//Label1.Visible = true;
//Label1.Text = myStringBuilder.ToString();
Literal1.Text = myStringBuilder.ToString();
}
}
catch (Exception ex)
{
//throw new ApplicationException(ex.Message);
lblPesan.Visible = true;
lblPesan.Text = ex.Message;
}
finally
{
strm.Close();
}}
Using memory stream,transaction&commit and command parameter
using System.IO;
public bool saveIsiBuku(string text, string id,string acc)
{
try
{
MemoryStream strm = new MemoryStream();
XmlWriter writer = XmlWriter.Create(strm);
XmlDocument xdoc = new XmlDocument();
xdoc.LoadXml("
" + text + "");
xdoc.WriteTo(writer);
writer.Flush();
writer.Close();
long idUsr = idUSer(acc);
command = new SqlCommand();
command.Connection = conn;
conn.Open();
trans = conn.BeginTransaction();
command.CommandType = CommandType.Text;
//conn.Open();
sql = "insert into versi(id_sub_bab,isiversi,id_user) values (@id,@isi,@idU)";
//command = new SqlCommand(sql, conn);
command.CommandText = sql;
command.Transaction = trans;
command.Parameters.AddWithValue("@isi", strm.GetBuffer());
command.Parameters.AddWithValue("@id", id);
command.Parameters.AddWithValue("@idU", idUsr);
command.ExecuteNonQuery();
long idV = idVersi();
sql = "update sub_bab_buku set idversi=@idv where id_sub_bab=@id2";
//command = new SqlCommand(sql, conn);
command.CommandText = sql;
command.Transaction = trans;
command.Parameters.AddWithValue("@idv", idV);
command.Parameters.AddWithValue("@id2", id);
command.ExecuteNonQuery();
long stp = step(id);
sql = "insert into history(idversi,id_sub_bab,step) values (@idv2,@id3,@ste)";
//command = new SqlCommand(sql, conn);
command.CommandText = sql;
command.Transaction = trans;
command.Parameters.AddWithValue("@idv2", idV);
command.Parameters.AddWithValue("@id3", id);
command.Parameters.AddWithValue("@ste", stp);
command.ExecuteNonQuery();
trans.Commit();
status = true;
strm.Close();
}
catch (SqlException sqe)
{
trans.Rollback();
status = false;
}
catch (Exception ez)
{
trans.Rollback();
status = false;
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
return status;
}
Send email
using System.Data.SqlClient;
using System.Net.Mail;
public bool Request(string account)
{
try
{
conn.Open();
sql = "select email_user,account_user,password,status from data_user where account_user = @acc ";
command = new SqlCommand(sql, conn);
command.Parameters.AddWithValue("@acc", account);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
to = reader.GetValue(0).ToString().Trim();
if (reader.GetValue(3).ToString().Trim().Equals("Active"))
body = "Account Anda : " + reader.GetValue(1).ToString().Trim() + "\n Password Anda : " + reader.GetValue(2).ToString().Trim() + "\n\n\t find, read and create book http://localhost/WikiSakura/Administrator/LoginUI.aspx";
else
body = "Account Anda diblok, silahkan hubungi Admin untuk dapat mengaktifkan Account Anda. \n\n\t find, read and create books http://localhost/WikiSakura/Administrator/LoginUI.aspx";
}
status = true;
}
if (status)
{
status = false;
MailMessage mm = new MailMessage(from, to, subject, body);
mm.Priority = MailPriority.High;
SmtpClient sc = new SmtpClient("127.0.0.1");
//SmtpMail.SmtpServer = "127.0.0.1";
sc.Send(mm);
status = true;
}
}
catch (HttpException he)
{
status = false;
}
catch (Exception ex)
{
status = false;
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
return status;
}
