- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 7
- Posts with Downvotes
- 7
- Downvoting Members
- 3
Hi, I'm having CLI0100E Wrong number of parameters. SQLSTATE=07001 exception when I try to [code] private void PopulateTable() { bool IsConnecting = true; while (IsConnecting) { try { cn = null; cn = new OleDbConnection(strConn); cn.Open(); sSqlCommand = "select a.sicil_no ,a.adi||' '||a.soyadi as isim,b.unvan_aciklama,a.ilkgir_tarihi,a.ayrilma_tarihi,a.sua,a.dogum_tarihi " + "from per015_ssk a,per003_ssk b"; … | |
Hi, I'm trying to use a public webservice, which I have been using for years with other programming environment where you have to prepare everything at a lower level of coding, placing everything with hand( soap header, body, authantication etc). In VS2008 I have succeded referencing and accessing the web … | |
Hi, I'm having problem when trying to read from ArrayList.Here is my code [code] ArrayList arrList; public ARMakbuz( ArrayList Alist) { arrList =new ArrayList( Alist); } private void ARMakbuz_ReportStart(object sender, EventArgs e) { foreach (ArrayList item in arrList) //Here I get exception { Fields["KOD"].Value = item[0]; Fields["DESC"].Value = item[7]; Fields["QTY"].Value … | |
Hi, I want to set typed dataset in my appl. joining 2 database tables. I can define dataset as xyz.xsd no problem, I define the relations. So this is a fixed set that I can use. But what if I have to add additional conditions to filter the data within … | |
Hi, I like to debug stored procedure in IBM DB2. I'm getting "string right truncation" error somewhere in stored procedure that I want to debug. How do I continue debugging from my c# code to stored procedure. c# code [code] String procName = "REG_DETAILS"; OleDbCommand cmd = conn.CreateCommand(); cmd.Transaction = … | |
Hi, I'm trying to locate a certain row in my datagridview, using textbox _textchanged event. Grid is populated with table having 2 columns as primary keys. With one column I have no problem, but using 2 columns I'm having exception . [code] private void dfSponsorname_TextChanged(object sender, EventArgs e) { try … | |
Hi, I'm having " 'System.DBNull' type object not assigned to 'System.Byte[]' type " exception on reading picture data from database into picture object. When there is a picture no problem I get it, but I cannot handle the null case. I tried many alternatives but no result. Here is the … | |
Hi, What is the best way of reading multiple aggregate data ? like so; [code] select id,sum(data1),sum(data2),sum(data3) from table1 group by id [/code] I know with ExecuteScalar you can get one aggregate data, but what about if you have more than one. I tried ExecuteReader and I'm getting exception [code] … | |
Hi, I'm having exception on this line, when some of the textboxes do not have value in [code] if (Convert.ToInt32(LeaveDay.Text) + Convert.ToInt32(SickDay.Text) + Convert.ToInt32(WorkDay.Text) > limitDay) [/code] appreciate any help thanks snky | |
Hi, I'm having problem when I read more then one datareaders in row. The second one always get exception. I know this is one of the favourite topics of ADO.NET, but could not solve my problem no matter what I do. I use a class to prepare my datareader. If … | |
[B][/B]Hi, How do I pass my variable or textbox data from form to Active Reports class where I prepare my sql string so that I can use my variable in "Where" clause..like[inlinecode] select * from personnel where name=' " + textboxName.Text + " ' "; [/inlinecode] Thanks, snky | |
Hi All, I often tend to fetch data from datasource using DataReader , these are usually a single data or single record of data cases. Within same method I reach to several datasource tables, each using datareader. This is awkward and cumbersome. Is it possible to create a class to … | |
Hi, I like to add DisplayMember and ValueMember to combobox when Loading forms. Then with combobox_SelectedIndexChanged event select the DisplayMember but assign ValueMember to a textbox field. I can add and assign the DisplayMember, but I cannot do it with ValueMember. in Designer.cs part at initiation; [code] this.cmbViziteType.Items.AddRange(new object[] { … | |
Hi all, I have ms office2003 installed on my machine. Therefore I use Excel 11. I have excel export button which worked perfectly well before I installed VS2008 SP1 . After the installation I'm getting exception from my excel export button saying " Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" I delete and … | |
Hi, Can anybody give an example of adding columns to an already populated dataset/datatable and reflecting changes to an already populated datagridview so that I can modify/added the row and use dataadapter.update to change the datasource. Thanks snky | |
Hi, I populate a datagridview with ( select a,b,c from ....) so this is my datatable, but I have more column on the grid < d,e,f > and I edit those columns which are not defined in datatable ( d,e,f) and when I update a,b,c inserted but d,e,f are not. … | |
Hi , I'm confused on dataset/datatable updating to datasource. According to one view, mass updating of datasource with datatable.rowstatechanges thru dataadapter is not professional and not to be used in real production environment. On the other hand, a lot of sources in internet and else talks about how to use … | |
Hi all, What I want to do is, when I leave a cell I want to make sure that that cell is not null, that is there is a date data there, and when I leave, I want to add some days to date and place this result on another … | |
Hi everyone, I'm having the error msg. "ıbmdadb2" E_FAIL(0X800004005) when I try to delete a row on the dataset. I populate the table in many combination of selections, no problem. But when I try to delete a line, I can do it on gridview but I cannot do it on … | |
Hi All, I know c# has limitations on assigning null values to datetime and integer value types. But is there any trick I can utilize. I'm converting my appl. from another dec. tool wher I have no null issue, to c#. What I want to do is ; I populate … | |
Hi to all, I like to reach all the cells by column name in a loop( foreach...) and compare the content of the cell in datetime type and add a value to another cell depending on the result of the comparison. I do this for all the populated rows. Question … |