|
add connection string to app.Config file under <configuration> tag such as
<configuration>
<connectionStrings>
<add providerName="System.Data.SqlClient" name="connStr1" connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=TRUE"/>
</connectionStrings>
</configuration>
right click on solution explorer second and add reference System.Configuration
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["connStr1"].ConnectionString;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connStr);
conn.Open();
|
|
|
|
|
Hi Guys. I have a file with two sequences, Sequence A and a Sequence B. Sequence A only appears once in the file and Sequence B can appear once or multiple times in the file. See Sample data below:
<B{1:F01CODENNNNXXX1234897878}{2:O1011702100608COMCODEXXXXX81287520281006081802N}{4:<br />
:20:TESTINGFILE01<br />
:28D:1/1<br />
:50H:/12345678901<br />
TEST NAME<br />
ADDRESS1<br />
ADDRESS2<br />
ADDRESS3<br />
:30:101022<br />
:21:REFERENCE1<br />
:23E:OTHR/DMST<br />
:32B:ZAR5005,00<br />
:57A:CODEXXXX<br />
:59:/12345600002345678<br />
TEST NAME2<br />
ADDRESS1<br />
ADDRESS2<br />
ADDRESS3<br />
:21:REFERENCE2<br />
:23E:OTHR/DMST<br />
:32B:ZAR7005,00<br />
:57A:CODEAAAA<br />
:59:/12345657002345678<br />
TEST NAME3<br />
ADDRESS1<br />
ADDRESS2<br />
ADDRESS3<br />
:71A:OUR<br />
-}
The portion in Bold is Sequence A and the remainder is sequence B data.
As you can see by the "TAGS" the fields starting with ':', that there are multiple Sequence B data. I need a way to pick up the data for the multiple Sequence B records. Sequence B start with :21: and ends with :59: followed by the address details. I tried a straight forward StreamReader and then populating the data but my Steamreader always goes from top to bottom in my while loop. Sample below.
string inFile;
inFile = textBox1.Text;
StreamReader sr = new StreamReader(inFile);
string holdline;
int lineCount = 0;
int clientname = 0;
int creditname = 0;
while (!sr.EndOfStream)
{
holdline = sr.ReadLine();
if (holdline.Length > 4)
{
string tag = holdline.Substring(0, 4);
string tag2 = holdline.Substring(0, 5);
if (tag == "{1:F")
{
lblBIC1.Text = holdline.Substring(6, 8).Trim();
lblClientBIC.Text = holdline.Substring(46, 8).Trim();
lblMsgType.Text = "MT" + holdline.Substring(33, 3).Trim();
lblDate.Text = holdline.Substring(36, 10).Trim();
lblSWIFTRef.Text = holdline.Substring(58, 10).Trim();
}
if (tag == ":20:")
{
int results = holdline.Length - 4;
lblA20.Text = holdline.Substring(4, results).Trim();
}
else if (tag2 == ":21R:")
{
int r1 = holdline.Length - 5;
lblA20.Text = holdline.Substring(4, r1).Trim();
lblA20.Refresh();
}
else if (tag2 == ":50H:")
{
int r3 = holdline.Length - 6;
lblA50H.Text = holdline.Substring(6, r3).Trim();
lblA50H.Refresh();
clientname = lineCount;
}
If I do things like this I end up overwriting the first Sequence B data with the second sequence B data. How can I capture both Sequence B data? Should I make use of "switch and case" statements instead?
Any advice would be greatly apreciated.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Try adding "+" characters:
lblA20.Text += holdline.Substring(4, results).Trim();
...
lblA20.Text += holdline.Substring(4, r1).Trim();
...
lblA50H.Text += holdline.Substring(6, r3).Trim();
Would be better if you used StringBuilder, but hey ho!
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Hi Griff. Not sure if that will work for what I have planned. What I am currently doing is writing the data to labels. Sequence B can be made up of multiple records/lines, each containing a set of TAGS. Tags are anything that start and end with ":". From the sample I supplied, one sequence B records starts with TAG :21: and ends with TAG :70:
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
If it's not too big, you could read the whole thing in and use a RegularExpression to parse it.
I would likely read it one character at a time rather than as lines. You can then write a little Finite State Machine.
You are also trying to do two things in one method here; I recommend splitting the method in two -- one to read/parse, one to display.
The reader/parse could return a List of Tuples, each Tuple wouyld contain the type/number of the field and the data.
|
|
|
|
|
Kwagga wrote: Any advice would be greatly apreciated.
Write a parser which reads the file and creates a data structure (presuming that the file is reasonably sized.)
Your data struct is represented by the following pseudo code
class RecordA
{
...
}
class RecordB
{
...
}
class Data
{
RecordA RecordA
List<RecordB> RecordBList
}
After you have populated Data above then you pass it to something else.
|
|
|
|
|
I want to create a UI in which user may b able to add table and can edit/update it (just like a table control we have available for development purpose). Can somebody suggest me how to inherit that control of VS so that I can clone full of its functionality? Please remember that I want to do it for a desktop based application.
Regards
saq!b
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|
|
|
Do you mean design and add a new table, or just add resords to an existing table?
If it's the latter, then as suggested, a DataGridView would probably do the trick. If not, you'll have to probably write something yourself or use some sort of DB manager.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
hello everybody,
i am developing a c# project and sqlsrver 2005.
during deployment i used to attach database from installer.
every thing works fine on xp. but on windows 7 it install perfectly but while loging it throws
exception that execute permission denied on object table name user username dbo.
its some time works fine and some use to throw this type of exception.
i search lot on google and dont get any suitable answer.
thanks in advance
|
|
|
|
|
You are obviously running into security issues and you mentioned something interesting here
its some time works fine and some use to throw this type of exception.
This is because you are installing on machines with different security settings. I suggest you read the CAS
http://msdn.microsoft.com/en-us/library/930b76w0%28VS.85%29.aspx[^]
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Is it SQL Express? SQL Compact? I doubt you are installing a full SQL Server Standard edition. Where are you intalling the files? The reason you can't find any answers on google is probably because you aren't making your searches specific enough.
|
|
|
|
|
its sql expess and i am installing in through windows installer
|
|
|
|
|
hi!
In windows application, i am using datagridview to insert value into database.
But i want put some validation in certain column. but i couldn't.
eg.: i have two columns namely,
Description and Cost. I want to insert only capital letters in Description column and only numbers in cost column.
plz guide me an idea. i will appreciate for it.
thanx and regards
|
|
|
|
|
set character casing toupper
|
|
|
|
|
|
bind it to textbox column and use text box character casing property
|
|
|
|
|
thanx monu!
one more question i want to ask.
i use menustrip and this contain two sub menu.
my query is when i click first sub menu , the DataGridView will open and some character are displayed in first column.
e.g.: menustrip contain Course and subject. when i click course link the DataGridView will open and "crse" are shown in first column of datagridview. Same condition apply with "Subject".
can u give some idea.
again thanx
|
|
|
|
|
are u fetching data from database or what.
if that is the case you can use sql query according to the criteria and bind them with gridview
|
|
|
|
|
no, actually i use this on insert command. so, thre is no data in database.
i want use maybe "HardCode".
|
|
|
|
|
do you mean that you want to insert data through gridview
plz explain your problem
|
|
|
|
|
their is an event on endedit of Datagridview on which you can work on to get ur results
|
|
|
|
|
I Developed an application in c# use of TCP. This application Work well in local network. but failed in internet I can not find the problem. any one help me
|
|
|
|
|
Could be anything!
What firewalls are involved?
Do you have permissions on the remote site?
What errors are you getting? Or what is / isn't happening?
What code are you using - post relevant fragments.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
In addition to OriginalGriff answer..,
Check the Anti Virus , This may block some Ports
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
