|
|
hello,
i really need help, i have created a dynamic datagridview, which the number of rows i write it in a xml file. When i save it for first time, in the xml file write the correct number of rows but when i save it again the "new" xml file write zero rows! i can understand why. i try to use datatable and dataset but nothing the problem is that datagridview hasnt rows.
Please some idies?
Thank you
public Form1(int cntC, int cntL)
{
InitializeComponent();
Create_dGV(cntC, cntL);
}
private void Create_dGV(int cnt, int cnt2)
{
for (int i = 0; i < cnt; i++)
{
CmbBx();
}
for (int i = dGV.RowCount; i < cnt2; i++)
{
dGV.Rows.Add();
}
for (int i = 0; i < dGV.Rows.Count; i++)
{
dGV.DefaultCellStyle.NullValue = " ";
dGV.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
dGV.AllowUserToAddRows = false;
}
private void CmbBx()
{
DataGridViewComboBoxColumn CmbBx = new DataGridViewComboBoxColumn();
List<string> data = new List<string>();
data.Add("0");
data.Add("3");
data.Add("5");
data.Add("9");
CmbBx.DataSource = data;
CmbBx.Width = 120;
CmbBx.FlatStyle = FlatStyle.Flat;
dGV.Columns.Add(CmbBx);
}
private void SaveBttn_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
{
for (int j = 0; j < dGV.ColumnCount; j++)
{
dt.Columns.Add((j).ToString(), typeof(String));
}
for (int i = 0; i < dGV.RowCount; i++)
{
DataRow d = new DataRow();
d = dt.NewRow();
for (int j = 0; j < dGV.ColumnCount; j++)
{
d[j] = dGV.Rows[i].Cells[j].Value;
}
dt.Rows.Add(d);
}
}
XmlWriterSettings settings = new XmlWriterSettings();
settings.Indent = true;
settings.OmitXmlDeclaration = true;
settings.NewLineOnAttributes = true;
using (XmlWriter writer = XmlWriter.Create(name, settings))
{
writer.WriteStartDocument();
writer.WriteStartElement("dGV");
{
writer.WriteElementString("ColumnsCount", dt.Columns.Count.ToString());
writer.WriteElementString("RowsCount", dt.Rows.Count.ToString());
for (int i = 0; i < dt.Columns.Count; i++)
{
//string lttr= "a"+ i.ToString();
//writer.WriteStartElement(lttr);
//{
// for (int j = 0; j < dt.Rows.Count; j++)
// {
// lttr= "a"+ i.ToString()+ j.ToString();
// writer.WriteElementString(lttr, dt.Rows[j][i].ToString());
// }
//}
//writer.WriteEndElement();
}
}
writer.WriteEndElement();
writer.WriteEndDocument();
}
}
// other form
private void OpenBttn_Click(object sender, EventArgs e)
{
XmlDocument xDoc = new XmlDocument();
xDoc.Load(name);
int C, R;
string hlps, hlps2;
hlps = xDoc.SelectSingleNode("dGV / ColumnsCount").InnerText;
C = Int32.Parse(hlps);
hlps = xDoc.SelectSingleNode("dGV / RowssCount").InnerText;
R = Int32.Parse(hlps);
Form1 f = new Form1(C, R);
}
}
}
modified 18-Nov-16 4:54am.
|
|
|
|
|
Yeah, there is no way anyone is going to be able to answer this because we can't see your code. Modify your question and post the relevant code that saves your data to the XML file.
Member 12856910 wrote: i try to use datatable and dataset but nothing the problem is that datagridview hasnt rows.
This last sentence didn't make any sense at all.
|
|
|
|
|
Hi,
I'm mostly asp.net/services soa/ server code .. I'm have done Win Form apps but installations is not something I have much XP with ..
Question : I have a config file and an encrypted file that I need to write during installation. The directory I was going to use is commonappdata(ProgramData) directory. I was just wondering if this is typical or has everyone found something better for reasons unknown to me .. Win7+
Thanks
Jon
|
|
|
|
|
I'd use the special folders: Where should I store my data?[^] - combining the standard "writable" folders with a GUID based app id for your installed app makes it easy for you, but harder for the user to find. Which is probably a good idea if you are writing an encrypted file as some kind of licence.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
hello sir I m Ramesh .net fresher I want to develop a desktop software in accounting software using c# . how to do this task please help me sir
|
|
|
|
|
You start by researching the requirements of the accounting software. Once you know the requirements you can start the actual design: inputs, outputs, data storage etc., etc. As a beginner I would suggest you would probably be better working on some smaller projects first.
|
|
|
|
|
Downvote countered.
This space for rent
|
|
|
|
|
|
As Richard said, you would start off by researching the requirements for accounting software. Long before you type your first line of code, you should understand what it is that you are trying to develop. Do you have an accountancy background? If so, that will help you. If not, you are going to have to talk to accountants to get an understanding of what they require. To give you an example of why this is necessary - consider the case of Value Added Tax (VAT). Will your system be able to cope with VAT added at source? What about VAT that gets applied at destination. Can you cope with different VAT rates? What about the ability to have VAT discounts (where VAT is applied at one rate for part of the year, then another rate for the rest)?
This space for rent
|
|
|
|
|
What be this VAT thing you talk about.
And that is the point, is it going to be an international package or just for his home country.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
And gawd help his "customers" ...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Or, for domestic customers who also trade internationally?
This space for rent
|
|
|
|
|
Member 11580781 wrote: how to do this task Building accounting software is not a task but a project full of thousands of tasks. Define your tasks and then build it.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
What everyone is trying to say is that it sounds like you're in way over your head.
Writing an accounting software is not an easy project and would take several developers months to get a base version and years to get a mature market competitive version. It would require in dept knowledge of different domains like database, accounting, juridical laws, development, IT hardware, ... etc...
try finding some information on existing software and check out what they can do. That will give you an idea why not doing this...
|
|
|
|
|
public class Account {
public string AccountNumber { get; set; }
public string AccountType { get; set; }
public string AccountName { get; set; }
public decimal TotalDebits { get; set; }
public decimal TotalCredits { get; set; }
}
|
|
|
|
|
Hello I need sample code to show dual screen display using usercontrol.xaml in wpf c#
I need to display a part of screen from primary monitor to another screen
|
|
|
|
|
And?
What have you tried?
Where are you stuck?
What help do you need?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
System.Windows.Forms.Screen s1 = System.Windows.Forms.Screen.AllScreens[0];
ticket.Visibility = Visibility.Visible;
System.Drawing.Rectangle r1 = s1.WorkingArea;
ticket.Height = 50;
ticket.Width = 150;
its not showing in another screen part of usercontrol.xaml name is ticket
|
|
|
|
|
Ummm... did you set the position of the window? It doesn't happen by magic.
|
|
|
|
|
I need to display a part of usercontrol.xaml in another screen ie dual screen in wpf c# any sample
|
|
|
|
|
|
iTextSharp.text.Document Doc = new iTextSharp.text.Document(PageSize.LETTER, 20, 20, 20, 20);
string PDFOutput = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "Output.pdf");
PdfWriter writer = PdfWriter.GetInstance(Doc, new FileStream(PDFOutput, FileMode.Create, FileAccess.Write, FileShare.Read));
Doc.Open();
string Folder = "C:\\Images";
foreach (string F in System.IO.Directory.GetFiles(Folder, "*.jpg")) {
Doc.NewPage();
Doc.Add(new iTextSharp.text.Jpeg(new Uri(new FileInfo(F).FullName)));
}
Doc.Close();
|
|
|
|
|
Don't repost your question in multiple forums. Pick ONE and stick with it. You already posted this in QA.
|
|
|
|
|
Hey Gang...I've got a folder with about 17,000 text files in it. I need to parse those text files and insert my parsed results into a Sql database. I've gotten it to where I'm doing about 4 - 5 files per second, but I need it to be faster that that. The text files aren't straight forward either. An example of the data in the text file is:
orld Clock Location Entries=INXX0102|Pune|India
Weather Location ID=48226|Detroit| MI (48226)
English/Metric Units=0
CLNAME001=
CLNUMBER001=xxx-xxx-xxxx
CLTYPE001=4
CLDATE001=11/09/16
CLTIME001=18:07
CLDURATION001=
CLBRIDGEDFLAG001=0
CLMISSEDCNTR001=1
CLBCALBL001=
CLNAME002=
CLNUMBER002=xxx-xxx-xxxx
CLTYPE002=4
CLDATE002=11/09/16
CLTIME002=17:59
CLDURATION002=
CLBRIDGEDFLAG002=0
CLMISSEDCNTR002=1
CLBCALBL002=
CLNAME003=
CLNUMBER003=xxxxxxxxxxxx
CLTYPE003=3
CLDATE003=11/09/16
CLTIME003=16:57
CLDURATION003= 1:54
CLBRIDGEDFLAG003=0
CLMISSEDCNTR003=0
CLBCALBL003=
etc......
This is a backup text file of an AVAYA 96xx phone. What you see above is 3 calls from the phones call history. There's more in that text file than just calls though, so to get just call info, I grab all the lines that start with "CL".
Here's a blurb of my code:
while ((line = file.ReadLine()) != null)
{
if (line.Substring(0, 2) == "CL")
{
try
{
string[] strArray = line.Split("=".ToCharArray());
string key = strArray[0];
string str = strArray[1];
One call is made up of 9 elements, so:
CLNAME, CLNUMBER, CLTYPE, CLDATE, CLTIME, CLDURATION, CLBRIDGEDFLAG, CLMISSEDCNTR, CLBCALBL all make up one call. My question to you is, how would you go about parsing this out and inserting into a database? Am I going about it the right way?
Below is my complete code:
public static void letsdoit(SqlConnection con)
{
string[] files;
string line;
int counter = 0;
using (UNCAccessWithCredentials unc = new UNCAccessWithCredentials())
{
if (unc.NetUseWithCredentials(@"\\ql1telutil1\c$\inetpub\wwwroot", "xxxxxxxxxx", "xx", "xxxxxx"))
{
files = Directory.GetFiles(@"\\ql1telutil1\c$\inetpub\wwwroot\backup96XX");
foreach (string f in files)
{
sqlString = null;
int myCounter = 0;
List<Int32> myCountList = new List<Int32>();
List<Int32> UniqueCallNumber = new List<Int32>();
System.IO.StreamReader file = new System.IO.StreamReader(f);
string[] array2 = f.Split("\\".ToCharArray());
string myStat = array2[7].ToString().Substring(0, 5);
log.Info("Getting history for extension: " + myStat);
while ((line = file.ReadLine()) != null)
{
if (line.Substring(0, 2) == "CL")
{
try
{
string[] strArray = line.Split("=".ToCharArray());
string key = strArray[0];
string str = strArray[1];
sqlString = sqlString + MinifyB(str.Trim()) + "','";
myCounter = myCounter + 1;
if(myCounter == 9)
{
try
{
addSQL =
"INSERT INTO tblStationCallHistory(CLSTATION, CLNAME, CLNUMBER, CLTYPE, CLDATE, CLTIME, CLDURATION, CLBRIDGEDFLAG, CLMISSEDCNTR, CLBCALBL) " +
"VALUES('" + myStat + "','" + sqlString.Substring(0,sqlString.Length - 2) + ")";
SqlCommand updateCMD = new SqlCommand(addSQL, con);
try
{
updateCMD.ExecuteNonQuery();
}
catch (Exception ex)
{
log.Error("There was a problem executing the command. " + ex.Message);
}
}
catch (Exception ex)
{
log.Error("There was a problem inserting the coverage path into the table. " + ex.Message);
}
sqlString = null;
myCounter = 0;
}
}
catch (Exception ex)
{
string myError = ex.Message.ToString();
}
}
counter++;
}
file.Close();
}
}
}
}
Any hints, guidance etc to help me speed this up would be greatly appreciated! Thanks for any help!!
Dave
|
|
|
|
|