|
Hi, I want to insert into my database some information, I have everything in file a.txt:
INSERT INTO TLK (kodas, liga) VALUES ('(01-99)', 'Traumu priežastys (ne iš TLK10 klasifikacijos)')
INSERT INTO TLK (kodas, liga) VALUES ('01-99', 'Ne TLK10 traumu priežasciu klasifikacija')
INSERT INTO TLK (kodas, liga) VALUES ('1', 'Transporto ivykis')
a.txt contains about 10 000 records. I run this program, but everytime it breaks, it shows error that data would be truncated... how can I fix that?
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Kikilis
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
string eilute;
int id = 0;
StringBuilder errorMessages = new StringBuilder();
private void button1_Click(object sender, EventArgs e)
{
try
{
System.IO.StreamReader sr = new System.IO.StreamReader("a.txt");
eilute = sr.ReadLine();
string j = "Data Source=KOMPAS;Initial Catalog=MEDIS;Integrated Security=True";
SqlConnection c = new SqlConnection(j);
c.Open();
while (eilute != "" || eilute == null)
{
SqlCommand cmd = new SqlCommand(eilute, c);
cmd.ExecuteNonQuery();
cmd.Dispose();
eilute = sr.ReadLine();
}
c.Close();
}
catch (SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++)
{
errorMessages.Append("Index #" + i + "\n" +
"Message: " + ex.Errors[i].Message + "\n" +
"LineNumber: " + ex.Errors[i].LineNumber + "\n" +
"Source: " + ex.Errors[i].Source + "\n" +
"Procedure: " + ex.Errors[i].Procedure + "\n");
}
Console.WriteLine(errorMessages.ToString());
}
}
}
}
|
|
|
|
|
That means that some of the insert statements have data that is too large to fit in the specified maximum size for that field in the database.
Why don't you include the instert statement that caused the error in the error message?
---
b { font-weight: normal; }
|
|
|
|
|
different record every time, for example now it stoped after inserting second record:
in table kodas is nvarchar 100;
liga is nvarcha 150;
INSERT INTO TLK (kodas, liga) VALUES ('A69.9', 'Spirochetu sukelta infekcija, nepatikslinta')
INSERT INTO TLK (kodas, liga) VALUES ('A70', 'Papugu chlamidiju infekcija')
INSERT INTO TLK (kodas, liga) VALUES ('A70-A74', 'Kitos chlamidiju sukeltos ligos')
|
|
|
|
|
Without studying your code too closely - are you sure that you are not getting truncation errors because you are trying to insert a string which is too large for the field? ie. a 50 char string when the field is defined as VarChar(40)?
Also, this line:
while (eilute != "" || eilute == null)
looks suspect. While loops normally run while a variable != null.
Regards,
Rob Philpott.
|
|
|
|
|
|
|
|
Hi,
I'm trying to remove checkbox from datagridview column on certain rows.
I have a grid with a datagridviewcheckboxcolumn, in my grid I've got headerrows as i call them and subrows. I want to remove the checkbox from all headerrows but keem them in the subrows.
Does anyone have a solution for that?
regards Tomas
|
|
|
|
|
In grid where you are identifying row as headerrow (DataBound event) at the same place you can set visible false of check box.
Amit
|
|
|
|
|
i've tried that.. but it's a read only property... only returns true or false whether the checkbox is in the visible area of screen... as i figured it anyway...
|
|
|
|
|
Hi there 
I seem to remember seeing an article where someone showed how to populate a System.Windows.DataGrid on a Form by using databinding. Almost like how it's done in Asp.Net.
Or is the only way to work with a WinForms datagrid, to databind to a DataTable in the disconnected way?
Kind regards - Jakob 
*********************************************
Three kinds of people in the world:
- Those who can count..
- Those who can't!
10 kinds of people in the world:
- Those who understand binary
- Those who don't
|
|
|
|
|
I am trying to develop a control which will be some what similar to Sql Server Relation diagram.
Problems:
1.
I inherited my control from a list box. Now i want to draw, but the problem comes when i draw any thing it doesn't get displayed. But when i copy paste code on a form it displays the items. Couldn't understand why it doesn't work on a control.
2.
I don't know how to drop any thing on a control. I tried a simple drag drop by draging an item from a list box to my control nothing happend.
need help! plz.
|
|
|
|
|
Hi
This is Dayakar,i have one problem
i.e i have one exe file,i given to some other person now he was loading that exe but in his machine does not have any framework to load that exe. At that time default it will load all the things which are required to load that exe.
How to achive this in asp.net
-- modified at 8:55 Wednesday 26th April, 2006
Hi
This is Dayakar,i have one problem
i.e I want to execute the dotnet files without haveing dotnet environment
To solve that problem my friend told that if you have to install dotnetfx.
Is that process is right or wrong if it is wrong can you tell any other possible solutions
How to achive this in asp.net
|
|
|
|
|
hi !
u can do some thing like this ... if ur working in VS.net 2005---
right click the setup project>>> add prerequesites like .net framework , report viewer >> then from the radiobutton choose download from same location..to add framework in ur project ..
rebuild the project....
done...
else..
search google for ".net bootstrapper plugin" download and install that plugin. the framework will automatically added in ur project..
try it..
Abhinav
|
|
|
|
|
Hi
This is Dayakar
first of all i would say Thank's for your reply
i see your reply, but i am getting clearly
can you send clear details if possible
Regards
Dayakar D.N
|
|
|
|
|
how can i Shutdown PC on Lan by C#
|
|
|
|
|
There was a exact same thread yesterday (not shure which forum). Do a search!
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
using System.Management;
ManagementBaseObject mboShutdown = null;
ManagementClass mcWin32 = new ManagementClass("Win32_OperatingSystem");
mcWin32.Get();
mcWin32.Scope.Options.EnablePrivileges = true;
ManagementBaseObject mboShutdownParams = mcWin32.GetMethodParameters("Win32Shutdown");
mboShutdownParams["Flags"] = "1";
mboShutdownParams["Reserved"] = "0";
foreach (ManagementObject manObj in mcWin32.GetInstances())
mboShutdown = manObj.InvokeMethod("Win32Shutdown", mboShutdownParams, null);
|
|
|
|
|
using System.Management;
ManagementBaseObject mboShutdown = null;
ManagementClass mcWin32 = new ManagementClass("Win32_OperatingSystem");
mcWin32.Get();
mcWin32.Scope.Options.EnablePrivileges = true;
ManagementBaseObject mboShutdownParams = mcWin32.GetMethodParameters("Win32Shutdown");
mboShutdownParams["Flags"] = "1";
mboShutdownParams["Reserved"] = "0";
foreach (ManagementObject manObj in mcWin32.GetInstances())
mboShutdown = manObj.InvokeMethod("Win32Shutdown", mboShutdownParams, null);
|
|
|
|
|
Hello,
I am writing one simple C# .NET application in which I have to use some values retrieved from the database. But when I try to retrieve value of attribute of type Time without time zone it generates following exception
{"Index was outside the bounds of the array."}
System.Exception {System.IndexOutOfRangeException}
This happens only when I try to retrive this type .. for other attribute types, it is working properly.
My code is ...
//--------------------------------------------------------------
String myQuery = "Select starttime from tblecture";
OdbcCommand myCommand = new System.Data.Odbc.OdbcCommand(myQuery, conn);
OdbcDataReader dataReader = myCommand.ExecuteReader();
while(dataReader.Read())//Exception being generated on this line
{
//code to use database info
}
//--------------------------------------------------------------
Schema of tblecture table is:
Table "public.tblecture"
Column | Type | Modifiers
-----------------+------------------------+----------------------------
lectureid | integer | not null
starttime | time without time zone |
Thanks,
Regards,
Kranti
|
|
|
|
|
How can I assign a integer value to the RecordNumber Field in crystal reports? Can similarly assign values to PageNumber Feild too? If so please explain how to do these?
Looking for a favorable reply..
Sam J
|
|
|
|
|
code for detecting an IP address 
|
|
|
|
|
string hostname=Dns.GetHostName();
IPHostEntry h=Dns.Resolve(hostname);
Console.WriteLine("IP addresses for "+hostname+":");
foreach (IPAddress ip in h.AddressList) {
Console.WriteLine(ip);
}
Also
http://www.codeproject.com/csharp/network.asp[^]
|
|
|
|
|
Is there a quick and easy way to get a bitmap from a control's Graphics object? I have a Panel object that I've drawn some stuff on, and I want to generate a bitmap from it. If that wasn't possible, I was also thinking of maybe drawing stuff onto a bitmap, but Bitmap objects don't have Graphics objects...
Any ideas or suggestions?
-Daniel
|
|
|
|
|
This may be of some use:
http://www.codeproject.com/csharp/imagecapture.asp[^]
Looking at the MSDN docs, it simply enough to get an Graphics object from an Image, but getting an Image from an existing Graphics object appears to harder. By the looks of it, it will involve handles/pointers and possibly using P/Invoke
-- modified at 19:58 Tuesday 25th April, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
