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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BRAHMA_DASHBOARD_UNIVERSTableAdapter" GeneratorDataComponentClassName="BRAHMA_DASHBOARD_UNIVERSTableAdapter" Name="BRAHMA_DASHBOARD_UNIVERS" UserDataComponentName="BRAHMA_DASHBOARD_UNIVERSTableAdapter">
<MainSource>
<DbSource ConnectionRef="BrahmaSqliteConnection (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>DELETE FROM BRAHMA_DASHBOARD_UNIVERS WHERE (( nomDashBoard = ?) AND ( nomUnivers = ?) AND ( nomUtilisateur = ?))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param1" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param2" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param3" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>INSERT INTO BRAHMA_DASHBOARD_UNIVERS ( nomDashBoard , nomUnivers , nomUtilisateur ) VALUES (?, ?, ?)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="nomDashBoard" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param1" Precision="0" Scale="0" Size="1024" SourceColumn="nomDashBoard" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="nomUnivers" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param2" Precision="0" Scale="0" Size="1024" SourceColumn="nomUnivers" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="nomUtilisateur" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param3" Precision="0" Scale="0" Size="1024" SourceColumn="nomUtilisateur" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT nomDashBoard, nomUnivers, nomUtilisateur
FROM BRAHMA_DASHBOARD_UNIVERS
WHERE (nomUtilisateur = @Param1)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="nomUtilisateur" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param1" Precision="0" Scale="0" Size="1024" SourceColumn="nomUtilisateur" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>UPDATE BRAHMA_DASHBOARD_UNIVERS SET nomDashBoard = ?, nomUnivers = ?, nomUtilisateur = ? WHERE (( nomDashBoard = ?) AND ( nomUnivers = ?) AND ( nomUtilisateur = ?))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="nomDashBoard" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param1" Precision="0" Scale="0" Size="1024" SourceColumn="nomDashBoard" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="nomUnivers" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param2" Precision="0" Scale="0" Size="1024" SourceColumn="nomUnivers" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="nomUtilisateur" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param3" Precision="0" Scale="0" Size="1024" SourceColumn="nomUtilisateur" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Param4" ColumnName="nomDashBoard" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param4" Precision="0" Scale="0" Size="1024" SourceColumn="nomDashBoard" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="Param5" ColumnName="nomUnivers" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param5" Precision="0" Scale="0" Size="1024" SourceColumn="nomUnivers" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="nomUtilisateur" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param6" Precision="0" Scale="0" Size="1024" SourceColumn="nomUtilisateur" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="nomDashBoard" DataSetColumn="nomDashBoard" />
<Mapping SourceColumn="nomUnivers" DataSetColumn="nomUnivers" />
<Mapping SourceColumn="nomUtilisateur" DataSetColumn="nomUtilisateur" />
</Mappings>
<Sources>
<DbSource ConnectionRef="BrahmaSqliteConnection (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByNomDashBoard" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByNomDashBoard" GeneratorSourceName="FillByNomDashBoard" GetMethodModifier="Public" GetMethodName="GetDataByNomDashBoard" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByNomDashBoard" UserSourceName="FillByNomDashBoard">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT nomDashBoard, nomUnivers, nomUtilisateur FROM BRAHMA_DASHBOARD_UNIVERS WHERE (nomDashBoard = ?) and (nomUtilisateur = ?)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="nomDashBoard" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param1" Precision="0" Scale="0" Size="1024" SourceColumn="nomDashBoard" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="nomUtilisateur" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@Param2" Precision="0" Scale="0" Size="1024" SourceColumn="nomUtilisateur" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter> |
Partager