1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| this.oracleSelectCommand3.CommandText = "SELECT DEVISECTT FROM TITRES WHERE (SICOVAM = :PARAM2)";
this.oracleSelectCommand3.Connection = this.oracleConnection1;
this.oracleSelectCommand3.Parameters.Add(new System.Data.OracleClient.OracleParameter(":PARAM2", System.Data.OracleClient.OracleType.Number,1, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "SICOVAM", System.Data.DataRowVersion.Current, null));
this.Load += new System.EventHandler(this.Page_Load);
this.Init += new System.EventHandler(this.WebForm1_Init);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
private void LinkButton1_Click(object sender, System.EventArgs e)
{
string str;
this.GridGroupingControl1.CreateControlHierarchy();
foreach(TableRow row in this.GridGroupingControl1.TopLevelTable.Rows)
{
if(row is GridRow)
{
GridRow gridRow = row as GridRow;
// Skip all non record rows.
if(gridRow.Record != null)
{
foreach (GridCell grc in gridRow.Cells)
{
if(grc.ColumnDescriptor.Name == "SICOVAM"){
str=grc.StyleInfo.FormattedText;
Response.Write(str+ "##########");
filldata(str,10);
Console.WriteLine("");}
}
}
}
}
}
public void filldata (string str,int size)
{
Response.Write("Not implemented yet");
System.Data.OracleClient.OracleParameter obj=new System.Data.OracleClient.OracleParameter();
obj.Value=str;
oracleSelectCommand3.Parameters[":PARAM2"].Size=100;
oracleSelectCommand3.Parameters[":PARAM2"]=obj;
Response.Write(str);
oracleDataAdapter2.Fill(dataSet21,"TITRES");
/*string st=dataSet21.TITRES[0][0].ToString();
if(st !=null) Response.Write(st);****/
}
}
} |
Partager