I'm reading data from Excel and processing the file line by line.
If the process succeeds then I need to delete that row from Excel and save it. If it fails, then continue with the next line and so on.
Initially I used OLEDB to read data from Excel, but by using this I cannot delete rows.
I think we can solve this by using COM component.
I am working on desktop application. I had created number of dynamic textbox and label and I want to save that data on clicking the save button.
View 4 Replies1) How to Delete Dynamically Allocated Array?
a) delete a[]
b)delete a[0]
c) delete[] a
d)delete [0] a
My answer a.Correct or not
2)Can we use DML statement in function?
a)Yes
b)No
c)Temp tables
d)None
My answer d.Correct or not
I read somewhere the diff b/w stored proc & functions?One of them is Stored Procedure returns more than one value whereas functions return single value.When the interviwer ask me the question,i asnwered includg my above point,but he told me no SProc do no return any value.
4)Can we return value from SPROC?
a)No
b)Using O/p Parameters
c)Using return statement
d)B & C Both
ANSWER---??
5)Views are complied or not
a)Yes
b)No
c)Partially Compiled
d)None
ANSWER---??
6)Can we user specific data in application? My answer no.Me correct 7)Diff b/w primary key & UNIQUE key excepts one diff primary doesn't allow NULLS whereas unique does.One diff i told we can craete only one primary key for a table,whereas a table can have more than one unique key.
ANy more differences?????
8) Can we call a fn. widout dbo? I ans NO. Me correct or nt
9) Four types of files created by assembly?
10) What is candidate Key?
11)Can we implement CAS in config file? I ans YES. Me correct or nt
12) dim txt as textbox
dim txt as new textbox
Both the above statements are same or not.If nt wats d diff? I ans both are same. Me correct or nt
13)CAS is part of inbuild framework? I ans YES. Me correct or nt
14)Can constructor call itself?
15)Accept method applies to
a)Textbox
b)Listbox
c)Combobox
d)None of above MY ans a. Me correct or nt
I have a form that has an array of dynamically created labels of varying size based on a search from a database. The problem I'm having is that when the user searches for a different term, it looks like some of the labels don't get new values. Here's my code for adding the labels:
If rdr.HasRows Then
ReDim Preserve entities(cnt)
While rdr.Read()
[Code].....
I've tried for loop over the controls in panel1 to dispose of any still on there in both the page_load and page_init subs, but neither had an effect. I don't know if it might have something to do with controls having the same IDs after the postback.
ive got code like the code below that creates textboxes dynamically. I want to be able to click a button and delete all of these textboxes i make, however im not sure how to do this. When i tell the program to remove the TBIndex control it does not do anything. The only way i get it to work is if i put the command in the same sub as this code. This code runs in a loop by the way.
So if the loop runs one time and creates the TBIndex control and i have a line of code right after to remove the textbox, then it does not show up on my form. But if i put the command in to remove the textboxes somewhere else and run the code the loop runs abunch of times and creates all teh textboxes and the loop is complete, then the remove control part is called and nothing happens. I just need a way to clear all the textboxes off my form with like a button. I also tried painting over the textboxes with a big grey rectangle but that dindt work.
TBIndex.Width = 54
TBIndex.Height = 20
TBIndex.Visible = True
[Code]....
I'm creating a PDF file on the fly using ITextSharp and ASP.NET 1.1. My process is as follows -
Create file on server Redirect browser to newly created PDF file so it is displayed to user
What I'd like to do is delete the PDF from the server as soon it is displayed in the users browser. The PDF file is large so it is not an option to hold it in memory, an initial write to the server is required. I'm currently using a solution that periodically polls for files then deletes them, but I'd prefer a solution that deletes the file immediately after it has been downloaded to the client machine. Is there a way to do this?
I am using zedgraph to draw bar chart in my vb.net project. The bar base is Y (meaning all bars are horizontal). I have 9 fields for user to choose from, and once a user clicks a field, one corresponding bar will show. Of course, the user can click off the selected field to remove the corresponding bar item. I can do this. The basic idea is to get all bar items and set their visibility according to user's selection. My problems is that I want to have a textlabel next to each bar (this text label is different from legend)so I set the yAxis.Type=text. There are two problems:
1) When I add bars, I still need to specify x and y value. How do I set y value in this case to make sure bar ally perfect with its text?
2) As far as I know, I can add text labels by an array as the last line code shows. But obviously this only works for bar chart with fixed bars. In my case, the number of bars and also the order is changing based on user selection. How can I set text labels?
[code...]
I'm trying to export a datagridview to Excel and open the Excel spreadsheet (not SAVE the worksheet).
Public Sub ExcelRpt(ByVal DgvName As GridView, ByVal url As String)
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
[code]....
Coming across a curious problem... I'm using a SQLCE database. In thebindingnavigatorsaveitem I have the generated code.. the validate, bindingsource.endedit, and the tableadaptermanager.updateall.Here's what I'm doing. I create a record and then click save. Then I decided to delete the record. When I try to save it again, I get an error - "System.Data.DBConcurrencyException: Concurrency violation: the DeleteCommand affected 0 of the expected
View 8 Repliesi'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
I have a code that dynamically generates some pictureBox-es. What I want to do is to save them so that they will aslo appear the next time the application is opened. Also i don't want to use an external configuration file so that the controls are generated on file-read.
Also I also have some controls that are generated by the designer
to create excel workbook dynamically where data will be input and manipulated by user. i want graph as well to be created using the data i manipulated and entered.i want as many as work sheets to be added in workbook once it is created.
View 2 Repliesthe following code will update the combobox list with new entries and even move repeated entries to the top of the list. I want to save the list so that the next time a user opens the program, the previous list appears in the combobox. Not sure how to accomplish that.
Private Sub btnCheck_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCheck.Click
're-declare "strComputer" to get value from combobox "combComputer"
Dim strComputer As String = combComputer.Text[code]....
I have a web browser control in my windows form. I am trying to automate some process in a website. During this process, the invoice pdf has been generated dynamically and shown in the web browser control. I need to save that pdf locally. Please note: there is no direct link to download the pdf. I googled a lot past couple of days and haven't found any solution yet.
View 1 RepliesI am new to .net, I got a project in which i need to import dynamically excel file into sql table. Like user will select the excel file and the sql table, then all the columns from excel file and the fields from sql table comes on the form, then user will select which column need to go to which table colums.
View 3 RepliesI was wondering if there is any way to load data from excel sheet into a datagridview in VB2008 dynamically. I have looked at few data connection codes but all of them involve the excel sheet and thw workbook name. Is there anyway that I enter the excel sheet name in a inputbox and the data from excel loads into datagridview without hardcoding the sheet name. I know data can be imported using the below code, here the programmer has to mention the excel workbook name, path and sheet name. [code]I am developing a program to perform some calculations and my data is in a number of excel workbooks and worksheets. I need to be able to bring the data from these excel sheets into the datagridview to perform calculations. So I was thinking if I could mention the excel sheet name in the GUI and then accordingly the data from that particular sheet would be loaded into the datagridview to perform calculations.
View 5 RepliesI have 2 blocks of code, if someone could help me put them together I would get the functionality I am looking for. The first block of code downloads a gridview to excel using the download dialog I am looking for:
Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
' Verifies that the control is rendered
End Sub
Private Sub ExportToExcel(ByVal filename As String, ByVal gv As GridView, ByVal numOfCol As Integer)
Response.Clear()
[Code]...
I have code for a user created button that gets placed on a custom ribbon control, within a custom drop-down menu.[code]...
View 2 RepliesI have an asp.net web forms application. In this application, students upload assignments and submit a survey along with it. For the survey, I read values from DB and dynamically generate ASP.NET Controls like radiobuttonlist, checkboxlist, textbox on the form during gridview's RowDataBound Event. I cannot do it in Page_Init method because I create only if a user click on a specific assignment which requires a survey to be submitted.
When I submit the survey form, the survey values are not saved into database. During debugging I figured it out that the values are not available in the codebehind page. The radiobuttonlist.selectedvalue returns and I get following error[code]....
I want to delete the first row from the excel file and I have impleted the code for this but it is deleting the all contents rather than deleting the first row .
[Code]..
I've been putzing around with this for awhile but I need to delete column B (minus the header) when ever it is empty.
If xlWorkSheet.Range("B2:B65565").Value = "" Then
Dim rg As Excel.Range = xlWorkSheet.Columns("B")
rg.Select()
rg.Delete()
End If
I want to delete the record from excel but i has getting the ISAM error, [Code]
View 1 RepliesI found out there are ways to Select, Insert, and Update Excel file by using OLEDB. But the limitation is that we can not delete a record.My idea is to delete row (instead of record). The question is how to programmatically delete row in excel, by id selected?I want to delete the row where id = 3. I can grab the id, but have no idea how to delete the row which contains the id 3.
View 3 RepliesOn my add button i still have to add codes that disables my navigation buttons and and my search button... and add codes that will enable them in save button... im still new thats why my codes are just simple if, else if, else conditions that just manipulates enable, visible, text, properties..also if i search my data will be search but my textboxes only shows the searched data.. i still have to add button that will only be visible if the program finds a data... and this button function is to remove the filter..rather than disabling some functions i want a messagebox to prompt the user that this functions arent functionable...
Look at my codes... i find it lame... its kinda irritating always just using True and false..
Public Class moviesForm
Private Sub moviesForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
I've got a binding navigater but i can't save and delete records i am using sql how can i get it to work. i can sroll throught the records. This is my code so far.
[Code]...
In One of my form i have a EmpBindingNavigator which allows me to save, delete and modify.
View 5 Repliesi going to add, update and delete records on xsd file (i got this xsd file through Data Sources Tab, i add new data source my VG.mdb)
View 7 RepliesI have a bound combo box with employee profile names. I have two buttons: save and delete buttons.When I edit a selected profile, I hit save and automatically the change is reflected in the bound combo box, but when I hit delete or create new profile, I have to close the app and when I open it I see the changes in the bound combo box.The combobox.Refresh() no workThis is my code:
Private Sub deleteselectedprofile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_deleteprofile_oninsideprofiledittap1.Click
Dim mconn As New SqlConnection("Data Source=(local);Initial Catalog=epmapp_db;Integrated
[code].....
I got a situation where I need to update the details of an order. So there is an order, and there are many products in that order, and the way I am updating that bit at the moment is simply 'delete and save'. But what happens is that it deletes first and them saves products which would be fair enough but if anything in save function goes wrong the order leaves with no products. So how would I know if I will get an error?
View 1 RepliesI can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 Replies