-
Replied To a Post in Set Margin of Report Viewer during runtime
I don't know what happened but it just worked! THanks a lot! :) -
Replied To a Post in Set Margin of Report Viewer during runtime
It's not working :( -
Created Set Margin of Report Viewer during runtime
Hi! I have this code from the internet but it didn't work well. I want to set the margin of the Report Viewer during runtime. Because I have this form … -
Replied To a Post in Reload data in Data Grid View
Already did the tweak! dgTranslog.DataSource = Nothing -
Created Reload data in Data Grid View
Hi! I am using Data Grid View to display the data from my database. This code works properly. It displays the data. This code is inserted in the Form_Load of … -
Marked Solved Status for Load data in Data Grid View upon form_load
Hi! Could you help me initialize or load the data into a Data Grid View Control using iDB2 Connection? I've tried this code I've seen from the net but it … -
Replied To a Post in Load data in Data Grid View upon form_load
Alraedy working! Fix: '****Display all the records in dgTranslog sqlGet = "SELECT * FROM exptranslog" cmdGet.CommandText = sqlGet cmdGet.Connection = conn daGet.SelectCommand = cmdGet daGet.Fill(dsGet, "expTranslog") dgTranslog.DataSource = dsGet dgTranslog.DataMember … -
Created Load data in Data Grid View upon form_load
Hi! Could you help me initialize or load the data into a Data Grid View Control using iDB2 Connection? I've tried this code I've seen from the net but it … -
Marked Solved Status for iDB2Commands in Visual Studio 2010
Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I … -
Replied To a Post in iDB2Commands in Visual Studio 2010
Hi Sir! Thank you so much for all your codes. It really helped a lot! :D Thumbs up! -
Replied To a Post in iDB2Commands in Visual Studio 2010
Hi Sir! Thanks for the code. I think this will show the data in a table right? Is this the shortest code? Let's say what I would like to happen … -
Replied To a Post in iDB2Commands in Visual Studio 2010
Thank you so much Sir! I already resolved the problem in UPDATE! I am really happy! :) Could you help me with the fetching of records? Thanks in advance! :DDD -
Edited iDB2Commands in Visual Studio 2010
Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I … -
Marked Solved Status for Update not working using iDB2
Hi! I have no problem when trying to execute and `insert` or a `delete` SQL Command. However, this `update` command does not seems to work well and I am having … -
Began Watching iDB2Commands in Visual Studio 2010
Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I … -
Revoked Solved Status for iDB2Commands in Visual Studio 2010
Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I … -
Marked Solved Status for iDB2Commands in Visual Studio 2010
Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I … -
Created iDB2Commands in Visual Studio 2010
Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I … -
Created Update not working using iDB2
Hi! I have no problem when trying to execute and `insert` or a `delete` SQL Command. However, this `update` command does not seems to work well and I am having … -
Marked Solved Status for SQL Queries for iDB2Connection
Hi! I already established an iDB2Connection, now what I want to know, is how could I execute SQL Queries for INSERT, DELETE and UPDATE. I had tested the code already … -
Stopped Watching SQL Queries for iDB2Connection
Hi! I already established an iDB2Connection, now what I want to know, is how could I execute SQL Queries for INSERT, DELETE and UPDATE. I had tested the code already … -
Began Watching SQL Queries for iDB2Connection
Hi! I already established an iDB2Connection, now what I want to know, is how could I execute SQL Queries for INSERT, DELETE and UPDATE. I had tested the code already … -
Replied To a Post in SQL Queries for iDB2Connection
Just want to share with you guys my line of code :) '*****************************Opening of iDB2Connection Dim str, sqlDelete As String Dim conn As New iDB2Connection Dim cmdDelete As New iDB2Command … -
Created SQL Queries for iDB2Connection
Hi! I already established an iDB2Connection, now what I want to know, is how could I execute SQL Queries for INSERT, DELETE and UPDATE. I had tested the code already … -
Stopped Watching declaration of connection string using ado
Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated … -
Marked Solved Status for declaration of connection string using ado
Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated … -
Replied To a Post in declaration of connection string using ado
Hi Sir! The code for DB2 really didn't work for me :( But I tried this one since where using AS400 for DB2 iSeries. Imports IBM.Data.DB2 Imports IBM.Data.DB2.iSeries Dim str, … -
Replied To a Post in declaration of connection string using ado
Hi! I'm sorry I overlooked the DB2 Command Line Processor Plus. I already inputted the instructions you told me but still I encountered errors. Kindly check what I am doing … -
Replied To a Post in declaration of connection string using ado
Hi! I've already installed DB2 Command Line Processor but the command line states `db2=>` how can i shift to sql? I've tried inputting ` SQL> connect user1/'YourPassword'@127.0.0.1:50000/sample` but error. -
Replied To a Post in declaration of connection string using ado
hi sir! I've installed the two softwares I needed, but I cannot find this IBM DB2 folder in the All Programs but all the installation were successful. -
Replied To a Post in declaration of connection string using ado
Hi! This is my simple code just to test if it will work. `Imports IBM.Data.DB2` Dim str As String Dim sql As String Dim conn As New DB2Connection str = … -
Replied To a Post in declaration of connection string using ado
hi **@cgeier**, the code works already! The problem is that in the `conn.open`, error occurs. ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". … -
Replied To a Post in declaration of connection string using ado
Hi! As I said, we do not connect to an SQL Server. We connect to our AS400 Server which stores the DB2 Database. Also, my problem is how to make … -
Replied To a Post in declaration of connection string using ado
Hi! The code I sent it is the one that we will use. The problem is that how to use on .vb file. How to make a simple query for … -
Replied To a Post in declaration of connection string using ado
hi! i just saw this on our Web.config, now I would like to know, how can i use it to declare a connection on my .vb page. What i will … -
Replied To a Post in declaration of connection string using ado
hi **newbie26**, i see that you used OLEDB for the connection. But I am trying to do it using ADO? Is it still the same? Thanks! -
Replied To a Post in declaration of connection string using ado
Hi Sir's! cgeier is right! I am connecting to an AS/400 Server which uses DB2 as its database. Now, I am using ADO.net to connect to the database in ASP.NET. … -
Began Watching declaration of connection string using ado
Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated … -
Created declaration of connection string using ado
Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated … -
Marked Solved Status for get the selected row in gridview using GridView1_RowEditing method
Hi! This is my Gridview1 and I wanted to get the value of the recid column using the GridView1_RowEditing method <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="RECID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"> <Columns> … -
Created get the selected row in gridview using GridView1_RowEditing method
Hi! This is my Gridview1 and I wanted to get the value of the recid column using the GridView1_RowEditing method <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="RECID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"> <Columns> … -
Marked Solved Status for Input string was not in a correct format.
Here's my **formview**.. <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="recid"> <EditItemTemplate> RECID: <asp:TextBox ID="recid" runat="server" Text='<%# Eval("RECID") %>' ReadOnly="true" /> <br /> SHIPPER: <asp:TextBox ID="shipper" runat="server" Text='<%# Bind("SHIPPER") %>' /> <br /> … -
Replied To a Post in Input string was not in a correct format.
hi! the select parameters are doing well, the problem is with the update thing. And I think in the update parameters. I need to tell the update command that `@recid` … -
Created Input string was not in a correct format.
Here's my **formview**.. <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="recid"> <EditItemTemplate> RECID: <asp:TextBox ID="recid" runat="server" Text='<%# Eval("RECID") %>' ReadOnly="true" /> <br /> SHIPPER: <asp:TextBox ID="shipper" runat="server" Text='<%# Bind("SHIPPER") %>' /> <br /> …
The End.