c# - To Insert Data in Textboxes using Store Procedure

SqlConnection sqlconn = new SqlConnection("Data Source=localhost; 
          User Id=sa; Password=; Initial Catalog=database");
        sqlconn.Open();
        SqlDataReader dr;
        SqlCommand cmd = new SqlCommand("storeprocedure_name", sqlconn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new SqlParameter("@col_id", System.Data.SqlDbType.NVarChar, 5));
        cmd.Parameters["@col_id"].Value = Session["data1"].ToString();
        cmd.Parameters.Add(new SqlParameter("@col_name", System.Data.SqlDbType.NVarChar, 30));
        cmd.Parameters["@col_name"].Value = Session["data2"].ToString();


        dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            txttextbox1.Text = dr["0"].ToString();
            txttextbox2.Text = dr["1"].ToString();
            txttextbox3.Text = dr["2"].ToString(); ;
            txttextbox4.Text = dr["3"].ToString();
            txttextbox5.Text = dr["4"].ToString();
            txttextbox6.Text = dr["5"].ToString();
        } 

Filter post by categorie id in Wordpress

<h2><?php echo get_cat_name(1);?></h2> <!-- get_cat_name(1) in which 1 is cat id -->
<?php $oddentry = 'class="gray" '; ?>
<?php query_posts('cat=1&showposts=1'); ?>
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
    <div <?php echo $oddentry; ?>>
         <div>
<div align="center"><img src="<?php viva('botNewspro','5'); ?> " alt="<?php the_title(); ?>" width="128px" height="122px" border="0" /></div>
<a href="<?php the_permalink() ?>" rel="bookmark"><h8 class="otherNews"><b><?php the_title(); ?></b></h8></a>
<div align="right"><div style="padding-top:5px;">Posted on <?php the_time('M j, Y'); ?></div></div>
</div>
         </div>
<?php /* Changes every other post to a different class */ $oddentry = ( empty( $oddentry ) ) ? 'class="gray" ' : ''; ?>
<!-- End of Loop for middle column -->
<?php endwhile; else : ?>
<?php endif; ?>
<?php wp_reset_query(); ?>

Inserting a dropdownlist value from a database - PHP

<?php

$db_name="yourdatabasename";// Database name
$conn=mysql_connect("localhost","databaseroot","password") or die("Error");
$db=mysql_select_db($db_name,$conn) or die("Unable to connect");
$databasetable="databasetablename"; // Table name

mysql_select_db("wphm", $conn);
$resultcity = mysql_query ("SELECT DISTINCT city FROM $databasetable ORDER BY city asc");

if (mysql_num_rows ($resultcity)) {
echo "<label>City:</label>\n";
echo "<SELECT name=\"ddcity\" id=\"ddcity\" onchange=\"this.form.submit();\">\n";
echo "<OPTION value=\"\">--choose city--</OPTION>\n";
while ($s1 = mysql_fetch_array ($resultcity, MYSQL_ASSOC)) {
foreach($s1 as $i1){
if($i1 == $_POST['ddcity']){$sel1 = " SELECTED";}
else{$sel1 = "";}
/*echo "<option value='" . $i1 . "'" . $sel1 . ">";
for ($i1 = 1; $i1 <= $_POST['ddcity']; $i1++) echo "&nbsp;&nbsp;";
echo "$s1[city]</option>\n";*/
echo "<option value='" . $i1 . "'" . $sel1 . ">" . $i1 . "</option>";
}
}
echo "</SELECT>\n";
}
?>