gbhs

Hi I can add watermark text on a .pdf document to an absolute position. This time I want to add water text of small font size to cover all of the page including margins. I know that I need relative positioning of text, fitting text to text lines depending on …

Hi to all, I have always had this problem where: if I have a datagrid with records like RecID Name 2 Tom 5 Rich 6 Harry To Save I will loop through the rows using the sql IF NOT EXISTS(SELECT * FROM myTable WHERE RecID= dgv.rows(i).cells(0).value say) BEGIN INSERT the …

Greeting to daniweb I must partition by Type and rank the following datable ( called dt) by LoanAmt column with ties Type LoanAmt Rnk ==================== A 14 A 15 A 13 A 11 A 11 B 17 B 18 B 17 B 16 As a new learner, I have read …

Hi to all vb.net community! In my application,the user may be required to install SQLExpress2008WT. The User Interface is as attached. The following steps are performed. a) Browse button browses the .exe file path (via a file dialog) and displays it. b) The Installation button does what it says, in …

Hi, I have a string like 32/355ab//3456 from which I need to extract the three separate numbers 32, 355 and 3456. The string pattern may vary. I can use Split by (say) / to separate strings. How can I extract groups of numbers from a 'mixed' string like above. The …

Hi My code below works fine to execute a SQL script. However I need to add a progress bar to indicate progress when the script is long and takes longer to execute. How do I implement it? thanks Newbie Public Class Form1 Public Sub ShellandWait(ByVal ProcessPath As String) Dim objProcess …

Hi Consider the string "Please, go Mr. Gofer and good bye" I want to split the string at the specific word 'Go' (not Go in 'Gofer' or in 'good') in my case 'Go' could be at begin of sentence or at end or somewhere inside sentence. How can I achieve …

Hi Experts I have an rdlc report onto which I have to add a watermark image, resize it and set opacity. How can I do it (programmatically)? The jpeg image is located in my resources folder of my project. thanks Newbie

Hi to all, I have to preview dataset data using printdoc and my code is below. Upon clicking the Preview button the preview dialog displays fine with data. when I close the preview dialog then click the preview button the data is not diplayed. weird behavior to me. what should …

Hi if myTable has a column like Col 10 7 3 5 9 4 How can I select three smallest numbers? my resultset should be 3 4 5 I don't prefer the following; with myT as (select col from myTable order by col) select top(3) from myT Any better idea? …

I have created a workbook template that will be used to collect some data from users. I want to restrict user input to numbers between 0 and 20 in each worksheet range A1:C5 (say). I know I can use a Macro like below to do it With oSheet Dim r …

I have created a workbook using VB.net and I need to Hide all columns to the right of Column K in all worksheets. To hide column K alone I can do Worksheet.Range("K:K", missing).EntireColumn.Hidden = true How can I hide column K and ALL the columns to the right of column …

Hi I have a Help.doc file in my application. How can I open this file on a winform to page 2 (say)? How can I open it to page 2 using a WebBrowser control? 'Microsoft.Office.Interop.Word added Private Sub OpenMyWordDoc() Dim MyWordApp As Word.Application Dim MyDoc As Word.Document MyWordApp = CreateObject("Word.Application") …

Hi All I can set paper size to landscape but I want to divide the paper to 2 pages such that each record is on a separate page. Any help will be appreciated. gbhs-newbie

Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A …

Hi I am using vs2008 Professional. Some columns of my dataset are presented in a matrix correctly. However,there is another dataset column I need to add. How can I insert a new column which is not an aggregate column to the right Thanks

Hi Experts, I have to Pad some numbers that have decimal points and I have done it successfully as follows: SELECT case when len(myValue)=1 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(5)), 2) when len(myValue)=2 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(4)), 2) when len(myValue)=3 then RIGHT('000' + CAST(CAST(myValue …

Hi I want to do a silent install of sql express 2008 (free edition) In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy". Thanks for your help SQL Newbie

Hi Experts my excel data is copied successfully to the listview. But on importing to database, I get this error. InvalidArgument=Value of '5' is not valid for 'index' ParameterName:Index ================= I have 2 problems ================= Problem 1: What should be the problem when I importing from listview(I think it is …

Hi Guys I have a "StudentNames" column in an sql table. Each student in the table has atleast two names all in one column. Assume that the following as studentNames. StudentNames ------------- John Smith Joseph Smitter Johan Smittin How can I use the LIKE statement to select students with same …

Hi to all I want use one reportviewer for several reports each with a parameter. This person has done it here http://www.sourcecodester.com/visual-basic-net/load-rdlc-report-using-report-viewer-programmatically.html without parameters. How can it be used with parameter for each report. when I change line 15 to da.Fill(ds.Employees,txtEmployeeID.text) (where txtEmployeeID holds employee ID as a SQL parameter), …

Hi I have a datagrid with 2 columns (Scores(Int) index 0 and Comment(varchar) index 1) Comment columnvalue depends on score columnvalue. This code works well in my cellvaluechanged event If e.ColumnIndex = 0 Then If Not IsDBNull(Me.dgvStudDisc.Rows(e.RowIndex).Cells(e.ColumnIndex).Value) Then If Me.dgvStudDisc.Rows(e.RowIndex).Cells(e.ColumnIndex).Value >= 0 And Me.dgvStudDisc.Rows(e.RowIndex).Cells(e.ColumnIndex).Value <= 5 Then Me.dgvStudDisc.Rows(e.RowIndex).Cells(1).Value = "Very …

Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …

Hi folks Im a newbie. I have a combobox cboTeachersName that is bound to deptTeachers table. At runtime, it contains teachers of given subject (Course). I then select a teacher and save in a field in another table called Summaries. PROBLEM IS When I load the form and load the …

Hi To All, I am a newbie. I have 4 computers that I want to connect together as a LAN. I have a switch and ready cables. One of the computers C1 will have a sqldatabase to be accessed by the other computers C2,C3 and C4. 1. How do I …

Hi to all, As a newbie, I am not able to have the following columns into a datagrid. (see database diagram attached) (I don't want to select ID columns because users may not be able to identify the students). I don't master JOINS . Infact I want to select all …

Hi Guys Im a newbie in vb.net and trying to insert data into students table and some related details to scores table. Point is, a student registered in a class(level) must offer subjects (courses) for that class. I insert a student in students table (see Cmd below). This is easy. …

Hi Folks As a newbie, my datagrid (dgvExamScores)has column4 and column5 (and othercolumns) column4 values depend on column5 values. Code works fine. PROBLEM: when I delete a column5 value, I expect the corresponding column4 to be deleted but this is not the case. Just where have I erred in my …