Cameronsmith63

Please don't post "spam" or "Thank you" posts in this thread since this is meant to be used as a guide for all beginners and I am sure we would like it to be on topic. I hope you understand this. For these of you who would like to learn …

So this is a general discussion. I basically want to know what your experience has been like when converting a VS 2005 project to a VS 2013 project, and from .Net2 to .Net 4.5. What have you done to overcome the issues? Are there ways and means to do the …

Hi, for some reason I can read this file perfectly on my machine (.net framework 4.5 is installed) But when I run it on one of the servers (.net framework 4.0 is installed), i can't get the file to even open. try { // Connect to the file with the …

So I have quite a problem over here and its wrecking my brain. I am reading in information from a csv file. the contents (or a row to be specific) of the file looks like: 1763275,95603462,NDBKPOS 1102I,EFT930G_16,CONNECTNET SIM,ACTIVE,RESTAURANT,RFU,2014/01/30 10:15:11,RFU,RFU,UN, In the above row you will see a date. When filling …

Error that I get: ERROR [42000] [Microsoft][ODBC Text Driver] Undefined function 'REPLICATE' in expression. Code below: DataTable dt = new DataTable(); string tempPath = @"C:\swd\"; string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + tempPath + @";Extensions=csv,txt"; string SqlString = "Select RIGHT(REPLICATE('0', 10) + RowNr, 10)," + "RIGHT(REPLICATE('0', 10) + …

Most important things in C # Sharp, as a Student Leaning the programming.. 1. CONSOLE 2. Web Forms and other Things , Suggesstion me

Hi I have to create an sql database for work, for my students to work with. I have created a large portion of the program, but i am stuck on the searching of data. So searching for a person or department. Not sure how to do it, here is my …

I am not a programmer, nor do I pretend to be. I have slowly been taking in advice from videos I have been looking at through youtube to help with my advancement of knowledge in C#. I was looking for a way to combine a list box item to a …

Hi, I kind of hit a bump in the road with SQL and C#. I am sending information through to a stored proc like: SqlCommand TestCaseManager = new SqlCommand("TestCaseManager", thisConnection); TestCaseManager.CommandType = CommandType.StoredProcedure; TestCaseManager.Parameters.Add(new SqlParameter("@TestCaseName", TestCaseName)); if (c.Controls[2].Text.Equals(string.Empty)) {TestCaseManager.Parameters.Add(new SqlParameter("@Steps", DBNull.Value));} else {TestCaseManager.Parameters.Add(new SqlParameter("@Steps", c.Controls[2].Text));} if (UnitTester.GroupBoxCreator.SomeClass.PictureLocation.Count.Equals(0)) {TestCaseManager.Parameters.Add(new SqlParameter("@Img", DBNull.Value));} …

I keep getting this error: The process cannot access the file 'D:\Gasper\Netcool\GA000162.200' because it is being used by another process. And I have tried everything to safely delete this file. Everything. What Am i doing wrong? using System; using System.Net; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Diagnostics; using System.Linq; …

Hi All, Can anybody help me in finding this out? I want to delete csv file using C#.Net? I am using:- File.Delete("E:\TestFolder\filename.csv"); OR if (System.IO.File.Exists("E:\TestFolder\filename.csv")) { System.IO.File.Delete("E:\TestFolder\filename.csv"); } But both above are giving exception as:- Cannot access the file "E:\TestFolder\filename.csv" because it is being used by another process. Test Folder …

Hi everyone, It might sound simple but I am having nightmares with this function What is the best way to delete a file without the machine complaining that i cannot acces the file because it is in use by another process? Is this a bug in the .net framework? Is …

Hi, im new to ASP.Net, just playing around with it... Got a simple question. I am trying to display my Textboxes next to my datagrid, but for some reason, it's always at the bottom of my datagrid. I playing around with this for an introduction to ASP.net. Anyway, i've tried …

Can anyone help me with the easiest, or most efficient way to browse through files and folders? Background: I'm trying to create a media player application, that browses through folders and when i click on a file, it must do whatever it has to with it. So i got the …

I created a service that watches a folder, processes the files that gets dumped into it, then after processing, it moves the files to another folder. So i copy a number of files to this folder, and every now and then, i get an exception stating that i cannot gain …

Okey pros i have a small question.assume that below sinario where i have a Two tables called Organizatioin and Organization_Members (One organization can have many members 1 to Meny) **Organizatioin** Organization_ID - PK Organization_Name Tel **Organization_Members** Member_ID - PK Organization_ID - FK First_Name Last_Name Tel I recently developed a system …

Hi guys, is this possible? I want to click on a picture box and test the response with a message box. Only problem is, these picture box controls only get created on runtime. public Form1() { InitializeComponent(); this.WindowState = FormWindowState.Maximized; //this.PnlViewFolders.Click += new EventHandler(pictureBox1_Click); // this.pictureBox1.Click += new EventHandler(pictureBox1_Click); }// …

hi i have create database with tables using sql server 2008, having table named 'Users' i have create this stored procedure : USE [Licenses_DB] GO /****** Object: StoredProcedure [dbo].[InsertUser] Script Date: 02/17/2013 23:25:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[InsertUser] @ID int , @userName NVARCHAR(50), …

hi Actually i am trying to do a task given by my lead.First in a form i have grid view i have loaded my database content in that and i have a combobox there i have loaded my one column of my table in the combo box .so i have …

Ok so I do not know where this post belongs, but apparently, Java is the language that is used for Arduino boards...I thought that it would be C. I have no idea where to begin, but I am really interested in tinkering with Arduino boards. Like REALLY. So I need …

Dont know the application switches to my form that makes use of odbc when I close the application. protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } As I step through, when it gets to components.Dispose(), it goes to private void TerminalStatus_SelectedIndexChanged(object …

Damn, this is so much easier in a form...Anyone know how to export from a DataSet to Csv file in a console application? string sp = "SLA2Day"; var outCsvFile = @"C:\Download Report Sheets\file.txt"; SqlCommand spcmd = new SqlCommand(sp, thisConnection); spcmd.CommandType = CommandType.StoredProcedure; DataSet dsData = new DataSet(); DataTable dt = …

Can it be done? <asp:MenuItem Text="Queries" Value="Queries"> <asp:MenuItem Text="New Query" Value="New Query"></asp:MenuItem> <asp:MenuItem Text="Search Queries" Value="Search Queries"></asp:MenuItem> <asp:MenuItem Text="Open Queries" Value="Open Queries"></asp:MenuItem> <asp:MenuItem Text="Resolved Queries" Value="Resolved Queries"></asp:MenuItem> <asp:MenuItem Text="Closed Queries" Value="Closed Queries"></asp:MenuItem> <asp:MenuItem Text="Cancelled Queries" Value="Cancelled Queries"></asp:MenuItem> </asp:MenuItem> Thanks

Hi, can anyone help me with paging on a gridview please? <asp:GridView ID="GridView1" CssClass="gridStyle" runat="server" AutoGenerateColumns="false" CaptionAlign="Bottom" GridLines="Horizontal" onselectedindexchanged="GridView1_SelectedIndexChanged" OnRowEditing="GridView1_RowEditing" ShowFooter="False" AlternatingRowStyle-BackColor="White" onrowcreated="GridView1_RowCreated" RowStyle-HorizontalAlign="Center" AllowPaging="True" onpageindexchanging="GridView1_PageIndexChanging" PageSize="5"> <RowStyle BackColor="#DEDFDE" ForeColor="Black" /> <Columns> <asp:CommandField ShowEditButton="True" ButtonType="Button" ItemStyle-Width="40px" ControlStyle-CssClass="button" ControlStyle-Width="43px" ItemStyle-HorizontalAlign="Center" /> <asp:CommandField ShowSelectButton="True" ButtonType="Button" ItemStyle-Width="40px" ControlStyle-CssClass="button" ControlStyle-Width="43px" ItemStyle-HorizontalAlign="Center" /> <asp:BoundField DataField="ID" …

Hi all when i execute my code it gives me this error " no data exists for the row column" can anyone please help me,,,am using access database here is my code: private void UpdateStudent_Load(object sender, EventArgs e) { OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = new OleDbCommand("select * from …

i want import Excel work sheet into ms acess existing table try { string conn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filename + ";" + "Extended Properties=Excel 12.0 Xml;"; OleDbConnection con = new OleDbConnection(conn); OleDbCommand cmd = new OleDbCommand(); con.Open(); cmd.CommandText = @"SELECT * INTO [MS Access;Database=" + adb + …

hie m using visual studio 2005 and sql 2005 i want to export my sql database to excel..

The folders contains different images in them and the file names may match from those 2 folders and we should be able to display those images in 2 picture box having the same file names randomly. Using C# visual studio 2010. Please help me out with this code....!

hi there, i have an application that opens an excel file and get the values to the mdf file in visual studio database file. the code for opening the file is below [CODE] Microsoft.Office.Interop.Excel.ApplicationClass tt = new Microsoft.Office.Interop.Excel.ApplicationClass(); String path = a; tt.Workbooks.Open(path, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, …

Hey guys, First post here but i've been a lurker for the past few days. I'm just fiddling with some C# exercises since I decided to try my hand at programming the other day. Please excuse me for being a complete rookie! So...Pseudocode. As far as I understand its a …