ASP.NET

Maxdd 7 wrote:

StreamReader sr = File.OpenText("E:\\fich.txt");

string MystringLine;
string[] MystringArray;
char[] charArray = new char[] { ',' };

FileStream MyFileStrema = new FileStream("E:\\fich1.txt", FileMode.Open);
StreamReader MyStreamReader = new StreamReader(MyFileStrema);

MystringLine = MyStreamReader.ReadLine();
MystringArray = MystringLine.Split(charArray);

int tamanho;
tamanho = MystringArray.Length;

//for (int i = 0; i <= MystringArray.GetUpperBound(0); i++)
for (int i = 0; i < tamanho; i++)
{
    //            Response.Write(MystringArray[0]);
    string query;

     query = "INSERT INTO Filmes(Name, Genre, Year)";
    query += " VALUES ('" + MystringArray[0] + "','" + MystringArray[1] + "','" + MystringArray[2] + "')";

    SqlCommand com = new SqlCommand(query, Conn);
    SqlDataReader datareader = com.ExecuteReader();
    datareader.Close();

}

string[] datum = File.ReadAllLines("E:\\fich1.txt");

foreach(string data in datum)
{
   string [] MystringArray = data.Split(new char[] {','} );

   // rest of your SQL code will work from here, although I'd use a paramaterised query, or at a minumum do MyStringArray[0].Replace("'", "''") to double quote the strings so the SQL does not blow up


} 

TextBox tb1 = e.item.FindControl("textbox1") as TextBox;
TextBox tb2 = e.item.FindControl("textbox2") as TextBox;
TextBox tb3 = e.item.FindControl("textbox3") as TextBox;

tb1.Attributes.Add("onblur", "javascript:return refreshValue('" + tb2.ClientId + "','" + tb3.ClientId + "');");
tb2.Attributes.Add("onblur", "javascript:return refreshValue('" + tb1.ClientId + "','" + tb3.ClientId + "');");

function refreshValue(operand, target){
  try {
   var value1 = parseInt(this.value);
   var value1 = parseInt(document.getElementById(operand).value);
   document.getElementById(target).value = (value1 + value2);
  }
  catch(err) {
    alert(err.description);
    return false;
  }
return true;
}

ItemTemplate 

ItemDataBound 

<asp:Datalist....OnItemDataBound="Item_Bound" >
<itemtemplate>
<asp:textbox runat="server" id="tb1" />
</itemtemplate>

void Item_Bound(Object sender, DataListItemEventArgs e)
{
   if (e.Item.ItemType == ListItemType.Item || 
             e.Item.ItemType == ListItemType.AlternatingItem)
   {

       TextBox tb1 = e.Item.FindControl("tb1") as TextBox; //same as the control inside Itemtemplate
  }

}